v1.1 — Redshift Serverless Support

What's New

Redshift Serverless support

• Setup wizard now supports both provisioned clusters and Serverless workgroups
• Use --workgroup CLI flag or configure via setup.py
• Serverless uses IAM identity directly — no --db-user needed

Security & IAM documentation

• New Security & Connection section in README with IAM policy examples for both provisioned and serverless
• Sequence diagram showing the Data API authentication flow
• Guidance on restricting --db-user impersonation via IAM conditions
• Prerequisites note on Data API access and security groups

Other

• Table of contents in README
• Built by section with Onsen link
• Cleaned up license section

v1.0.0 — Initial Release 🔴

Redshift Skill v1.0.0

Your AI-powered data analyst for AWS Redshift. Explore schemas, run queries, generate DDL, profile data — all read-only, all cross-platform, zero pip install.

✨ Highlights

• 12 Python scripts — query, schemas, tables, columns, ddl (7 types), table_info, search, sample, space, profile, analyze, setup
• 🛡️ Read-only guardrails — hard enforcement in lib/client.py, blocks DDL/DML/DCL
• 🖥️ Cross-platform — Mac + Windows, Python stdlib only, zero pip install
• 💾 Auto-save — all results saved to ~/redshift-exports/ with 20-row inline preview
• 🧮 Local analytics — analyze.py for describe, sum, avg, group-by, filter, hist on saved files
• 🏗️ DDL for 7 types — table, view, schema, database, UDF, external, group (bundled SQL from amazon-redshift-utils)
• 📈 Business analysis workflows — trend, cohort, root cause, Pareto, segmentation patterns
• 🔌 Agent-agnostic — works with Claude Code, Cursor, Codex, and more

🚀 Install

npx skills add onsen-ai/redshift-skill

📋 Prerequisites

• Python 3.8+
• AWS CLI v2 with Redshift Data API access