AWS Redshift
Discover Amazon Redshift clusters and Serverless workgroups, browse the data catalog, run SQL through the Redshift Data API, and review cluster health.
Categories: Data Warehouse, Database, AWS
Set up
AWS Redshift connects with credentials from your AWS Redshift account. Have these values ready:
- AWS region
- Access key ID
- Secret access key
- Go to Organization > Connectors and find AWS Redshift.
- Click Enable and choose which tools to allow.
- Each member enters their own values the first time they use it.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
AWS Redshift offers 16 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (12)
View and search information without changing it.
| Tool | What it does |
|---|---|
describe_statement | Get the status and metadata of a submitted statement (status, row count, error, run time) via the Redshift Data API. |
describe_table | Describe a table's columns (name, data type, nullability, precision/scale) through the Redshift Data API. |
get_statement_result | Fetch one page of a FINISHED statement's result set via the Redshift Data API. |
get_workgroup | Get one Amazon Redshift Serverless workgroup's full configuration by name, including its namespace, endpoint and capacity. |
list_clusters | List provisioned Amazon Redshift clusters in the account and region. |
list_databases | List the databases in a Redshift cluster or serverless workgroup through the Redshift Data API. |
list_schemas | List the schemas in a database through the Redshift Data API, optionally filtered by a name pattern. |
list_statements | List SQL statements submitted via the Redshift Data API, filtered by status and/or name, so an agent can find a prior statement's id. |
list_tables | List tables, views and external tables in a database through the Redshift Data API, optionally filtered by schema and table name patterns. |
list_workgroups | List Amazon Redshift Serverless workgroups in the account and region. |
review_cluster | Run a read-only diagnostic review of a Redshift cluster or serverless workgroup: a bounded set of health-check queries over Redshift system views (distribution skew, unsorted rows, disk usage, stale statistics), returning findings and recommendations. |
validate_credential | Verify AWS IAM credentials with minimal read-only access checks: first DescribeClusters, then ListWorkgroups and ListStatements if the prior check is permission-denied. |
Delete or overwrite (4)
Remove or replace existing data.
| Tool | What it does |
|---|---|
batch_execute_statement | Submit multiple SQL statements as one serialized batch via the Redshift Data API and return the batch statement id immediately. |
cancel_statement | Cancel a running SQL statement by id via the Redshift Data API. |
execute_statement | Submit a single SQL statement to a Redshift cluster or workgroup via the Redshift Data API and return its statement id immediately WITHOUT waiting for it to finish. |
run_query | Run a single SQL statement and BLOCK until it finishes, then return the first page of rows in one call — the convenient path for interactive queries. |