Integration · Databases
AI agents for Amazon Redshift
Run SQL on an Amazon Redshift cluster or Redshift Serverless workgroup through the Redshift Data API, read the results page by page, and browse databases, schemas, tables and columns, signed with an AWS access key.
- Actions
- 7
- Read
- 5
- Write
- 2
Actions
What your agents can do in Amazon Redshift
Run SQL on an Amazon Redshift cluster or Redshift Serverless workgroup through the Redshift Data API, read the results page by page, and browse databases, schemas, tables and columns, signed with an AWS access key. No database connection or network route is needed.
Read 5
Look things up. Nothing changes.
Get statement status
Gets a statement's Status (SUBMITTED, PICKED, STARTED, FINISHED, FAILED or ABORTED), its Error when it failed, HasResultSet, ResultRows, Duration in nanoseconds and the QueryString.
Get statement results
Reads a FINISHED statement's rows, up to 100 MB a page.
List schemas
Lists the schemas of the connection's database, optionally matching a LIKE pattern such as sales%.
List tables
Lists tables and views, optionally in schemas and with names matching LIKE patterns.
Describe a table
Lists a table's columns: ColumnList, each with name, typeName, length, precision, scale, nullable and columnDefault.
Write 2
Create, change or send.
Run SQL
Starts one SQL statement in the connection's database, with optional named parameters (:name in the SQL, values as text).
Cancel a statementDeletes data
Cancels a statement that is still running.
A person can approve first
Any write action can be set to wait for a person's approval before it runs, so an agent asks before it changes anything. Actions that delete data ask first by default.
Connection
How it connects
Connect it once in the console, then give it to the agents and workflows that need it.
Enter the sign-in details Amazon Redshift gives you for its API.
What you enter
- Access key ID
- Secret access key
Settings
- Region
- Database
Kept safe
- Credentials are stored encrypted with your organization's own keys.
- They are opened only by the process that makes the call, at the moment it runs, and never go into a prompt or the browser.
- Calls go only to the tool's own servers.
Ideas
Ideas to start with
Starting points made only from the actions above. Mix them with any other tool your agents can use.
- 01
Ask about your Amazon Redshift data
Ask a question in plain words. The agent can get statement status, get statement results or list schemas in Amazon Redshift, then answers with what it found.
- 02
Let an agent update Amazon Redshift
Have the agent run SQL or cancel a statement in Amazon Redshift as part of a larger task. Turn on approval and a person signs off on each change first.
- 03
Share what it finds in Slack
Give one agent Amazon Redshift and Slack: it can get statement status in Amazon Redshift and post a summary to a Slack channel in the same run.
Works well with
More Databases tools
- PostgreSQL5 actionsRead and query a PostgreSQL database directly: Amazon RDS and Aurora, Google Cloud SQL, Azure, Neon, Supabase, or your own server with a public address.
- MySQL5 actionsRead and query a MySQL database directly: Amazon RDS and Aurora MySQL, Google Cloud SQL, Azure, PlanetScale, or your own server with a public address.
- MongoDB7 actionsRead and query a MongoDB database directly: MongoDB Atlas (mongodb+srv) or your own server with a public address.
- BigQuery5 actionsRun SQL on BigQuery, browse datasets, tables and their columns, and stream rows into a table, in a Google Cloud project, signed in with the person's own Google account.
- Snowflake9 actionsRun read-only SQL in Snowflake and page through the results, and list databases, schemas, tables, columns and warehouses, through the SQL API with a programmatic access token or a key pair.
- Pinecone8 actionsSearch, add, read and delete vectors in a Pinecone index: similarity search by vector or by a stored record's ID, text search on indexes with integrated embedding, index statistics and the list of indexes in the project.
FAQ
Amazon Redshift and MyDeepAgents
Can MyDeepAgents connect to Amazon Redshift?
Yes. The Amazon Redshift connector has 7 actions: 5 read and 2 make changes. Your agents can call them as tools, and your workflows can run them as steps.
How do I connect Amazon Redshift?
Enter the sign-in details Amazon Redshift gives you for its API. You'll need: Access key ID and Secret access key. The connection also asks for: Region and Database. Credentials are stored encrypted with your organization's own keys and are opened only at the moment of a call.
Can an agent change data in Amazon Redshift without asking?
Only if you let it. Each of the 2 actions that change data can be set to wait for a person's approval before it runs, and the one that deletes data asks first by default.
Can I use Amazon Redshift in workflows as well as agents?
Yes. Every Amazon Redshift action also works as a step in a workflow, and the same connection serves your agents and your workflows.
Early access
Put Amazon Redshift to work
Connect it in a few minutes, give an agent the actions it needs, and decide which changes wait for a person.