redshift-guide
A skill from AWS's aws-data-analytics plugin that corrects common model mistakes about Amazon Redshift, starting from the point that it is not PostgreSQL, and pushes back on features Redshift lacks, such as CREATE INDEX or SERIAL.
What the skill teaches
A skill from AWS's aws-data-analytics plugin that corrects common model mistakes about Amazon Redshift, starting from the point that it is not PostgreSQL, and pushes back on features Redshift lacks, such as CREATE INDEX or SERIAL. It asks whether the cluster is provisioned or Serverless, then covers Redshift SQL, system views and metadata, connections and authentication, storage growth and VACUUM, slow queries and EXPLAIN plans, workload management and concurrency scaling, resizing, Spectrum, and using the Redshift Data API from Python. It includes safety guardrails and security notes.
Capabilities
- Write Redshift-specific SQL
- Diagnose slow Redshift queries
- Manage Redshift storage, VACUUM and workload management
- Use the Redshift Data API from Python
About
- Publisher
- Amazon Web Services
Install
What's inside
- references/redshift-auth-authorization.md
- references/redshift-sql-ddl-copy.md
- references/redshift-sql-extensions-semantics.md
- references/redshift-sql-functions-types.md
- references/redshift-sql-materialized-views.md
- references/redshift-sql-metadata.md
- references/redshift-sql-query-performance-queries.md
- references/redshift-sql-query-performance.md
- references/redshift-sql-recipes-load-api.md
- references/redshift-sql-syntax.md
- references/redshift-storage-remediation.md
- references/redshift-storage-utilization.md
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | Amazon Web Services | |
| Publisher | Amazon Web Services | source |
| Official status | Officialpublished in AWS's own GitHub organisation (github.com/aws) as part of the Agent Toolkit for AWS | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 11, 20263,464 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
More from Amazon Web Services
4 servers · 169 skills
- analyzing-release-readiness (Skill)
- Amazon ECS MCP Server (MCP server)
- Agent Toolkit for AWS (MCP server)
- chatting-with-aws-devops-agent (Skill)
- coordinating-multi-space-devops-agent (Skill)
- diff-scanning-with-aws-security-agent (Skill)
Sources
- Skill file (SKILL.md)github.com/aws/agent-toolkit-for-awsNov 10, 2026
- README (README.md)github.com/aws/agent-toolkit-for-aws · Backs: Official status, PublisherNov 13, 2026
- Licence file (LICENSE)github.com/aws/agent-toolkit-for-aws · Backs: LicenceNov 13, 2026
- Folder in the repository (redshift-guide)github.com/aws/agent-toolkit-for-aws · Backs: Includes scriptsNov 10, 2026
- GitHub repositorygithub.com/aws/agent-toolkit-for-aws · Backs: Activity, LicenceNov 11, 2026
Other MCP servers and skills for Amazon Web Services
- AWS Documentation MCP Server(MCP server)
- awslabs.amazon-mq-mcp-server(MCP server)
- awslabs.amazon-sns-sqs-mcp-server(MCP server)
- awslabs.amazon-translate-mcp-server(MCP server)
- awslabs.aws-iac-mcp-server(MCP server)
- awslabs.aws-location-mcp-server(MCP server)
- awslabs.aws-pricing-mcp-server(MCP server)
- analyzing-release-readiness(Skill)
- View all →