AWS Redshift

Discover, explore, and query Amazon Redshift clusters and serverless workgroups safely and efficiently.

Features

• Cluster Discovery: Automatically discover both provisioned Redshift clusters and serverless workgroups
• Metadata Exploration: Browse databases, schemas, tables, and columns
• Safe Query Execution: Execute SQL queries in READ ONLY mode (safe READ WRITE support planned for future versions)
• Multi-Cluster Support: Work with multiple clusters and workgroups simultaneously

What you’ll need to connect

Required AWS Credentials:

• AWS Access Key ID: Your AWS credential access key
• AWS Secret Access Key: Your AWS credential access secret

Optional Configuration:

• AWS Region: AWS region to use (default: us-east-1)
• AWS Session Token: Required only for temporary credentials like SSO or STS AssumeRole

IAM Permissions Required:

• redshift:DescribeClusters
• redshift-serverless:ListWorkgroups, redshift-serverless:GetWorkgroup
• redshift-data:ExecuteStatement, redshift-data:BatchExecuteStatement, redshift-data:DescribeStatement, redshift-data:GetStatementResult

Database Permissions:

• SELECT permissions on tables/views you want to query
• USAGE permissions on schemas you want to explore
• Connection permissions to databases you want to access

Basic Usage

Discovery Workflow

1. Discover Clusters: Find available Redshift resources
2. List Databases: Explore databases in a specific cluster
3. Browse Database Structures: Navigate through schemas, tables, columns
4. Query Data: Execute SQL queries safely with a natural language prompt

Simple Examples

• “Show me all available Redshift clusters”
• “List databases in cluster ‘my-redshift-cluster'”
• “What tables are in the ‘public’ schema of database ‘analytics’?”
• “Execute: SELECT COUNT(*) FROM users WHERE created_date > ‘2024-01-01′”