AWS Redshift Skills

A Python skill for interacting with AWS Redshift across two deployment modes: Redshift Provisioned and Redshift Serverless, plus a shared Data API for SQL execution.

When to Use (Trigger Phrases)

Invoke this skill when the user mentions:

"List Redshift clusters"
"Create a Redshift cluster"
"Pause my Redshift cluster"
"List Redshift Serverless workgroups"
"Create a namespace"
"Run a SQL query on Redshift"
"Execute COPY from S3 to Redshift"
"UNLOAD data to S3"
"Check query status"
"List tables in Redshift"
"Describe Redshift table columns"
"Resize my Redshift cluster"

Any request involving Redshift Provisioned clusters/snapshots, Redshift Serverless workgroups/namespaces, or Data API SQL execution.

Feature List

Redshift Provisioned

• Clusters: List, describe, create, delete, resize, pause, resume, reboot clusters
• Snapshots: Create, describe, restore from, delete snapshots

Redshift Serverless

• Workgroups: List, get, create, update, delete workgroups (RPU configuration)
• Namespaces: List, get, create, delete namespaces (database configuration)

Redshift Data API

• SQL Execution: Execute single or batch SQL statements (async or sync with polling)
• Results: Get query results with pagination
• Lifecycle: Describe statement status, list recent statements, cancel running queries
• Metadata: List databases, schemas, tables; describe table columns
• Data Movement: COPY from S3, UNLOAD to S3

Initial Setup

1. Python 3.8+ with boto3>=1.26.0:

   pip install boto3>=1.26.0
   

2. AWS credentials via boto3 default chain (env vars, config files, IAM roles).

3. Environment variables (all optional, validated at point of use):

   export AWS_REGION="us-east-1"
   
   # Redshift Provisioned
   export REDSHIFT_CLUSTER_ID="my-cluster"
   export REDSHIFT_DATABASE="dev"
   export REDSHIFT_DB_USER="admin"
   
   # Redshift Serverless
   export REDSHIFT_WORKGROUP_NAME="my-workgroup"
   export REDSHIFT_NAMESPACE_NAME="my-namespace"
   
   # Shared
   export REDSHIFT_IAM_ROLE_ARN="arn:aws:iam::123456789:role/redshift-role"
   export REDSHIFT_S3_LOG_URI="s3://my-bucket/redshift-logs/"
   export REDSHIFT_SECRET_ARN="arn:aws:secretsmanager:us-east-1:123456789:secret:my-secret"
   

How to Manage Redshift

1. Redshift Provisioned

Traditional Redshift provisioned clusters with dedicated compute nodes.

• Cluster & snapshot management: scripts/provisioned/redshift_provisioned_cli.py — 12 @tool functions
• Detailed guide: references/provisioned/cluster_guide.md — Cluster lifecycle, node types, resize
• Detailed guide: references/provisioned/snapshot_guide.md — Snapshot create/restore/share

2. Redshift Serverless

Fully managed serverless data warehouse with automatic scaling.

• Workgroup & namespace management: scripts/serverless/redshift_serverless_cli.py — 9 @tool functions
• Detailed guide: references/serverless/workgroup_guide.md — Workgroup management
• Detailed guide: references/serverless/namespace_guide.md — Namespace management

3. Redshift Data API

SQL execution via the Data API. Works with both Provisioned and Serverless.

• Query execution & metadata: scripts/data_api/redshift_data_cli.py — 12 @tool functions
• Detailed guide: references/data_api/query_guide.md — SQL execution, COPY/UNLOAD

Available Scripts

References

Requirements

• When writing temporary files (scripts, notes, etc.), place them in the ./tmp folder.
• When importing scripts packages, add the skill root to path: sys.path.append(${redshift_skill_root})
• AWS credentials are handled by boto3's default credential chain — never pass access keys directly.
• All configuration environment variables are optional and validated at the point of use.

Data Privacy & Trust

• No credential storage: AWS credentials are resolved via boto3 default chain. No keys are stored or logged.
• Secret masking: All functions automatically mask potential AWS credentials in output.
• Read-only by default: Most operations are read-only queries. Write operations (cluster creation, deletion) require explicit user action.

External Endpoints

This skill connects to:

• AWS Redshift API (redshift.{region}.amazonaws.com)
• AWS Redshift Serverless API (redshift-serverless.{region}.amazonaws.com)
• AWS Redshift Data API (redshift-data.{region}.amazonaws.com)
• AWS S3 API (s3.{region}.amazonaws.com) — for COPY/UNLOAD operations