Skip to main content

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
  1. Go to Organization > Connectors and find AWS Redshift.
  2. Click Enable and choose which tools to allow.
  3. 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.

ToolWhat it does
describe_statementGet the status and metadata of a submitted statement (status, row count, error, run time) via the Redshift Data API.
describe_tableDescribe a table's columns (name, data type, nullability, precision/scale) through the Redshift Data API.
get_statement_resultFetch one page of a FINISHED statement's result set via the Redshift Data API.
get_workgroupGet one Amazon Redshift Serverless workgroup's full configuration by name, including its namespace, endpoint and capacity.
list_clustersList provisioned Amazon Redshift clusters in the account and region.
list_databasesList the databases in a Redshift cluster or serverless workgroup through the Redshift Data API.
list_schemasList the schemas in a database through the Redshift Data API, optionally filtered by a name pattern.
list_statementsList 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_tablesList tables, views and external tables in a database through the Redshift Data API, optionally filtered by schema and table name patterns.
list_workgroupsList Amazon Redshift Serverless workgroups in the account and region.
review_clusterRun 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_credentialVerify 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.

ToolWhat it does
batch_execute_statementSubmit multiple SQL statements as one serialized batch via the Redshift Data API and return the batch statement id immediately.
cancel_statementCancel a running SQL statement by id via the Redshift Data API.
execute_statementSubmit 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_queryRun 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.
⌘J