--- title: "Amazon Redshift Guide - Air Market" description: "Amazon Redshift looks like PostgreSQL and is not, so habits from Postgres quietly produce SQL it rejects. This corrects those assumptions and covers the syntax, loading, and day-to-day operations tha…" canonical: "https://airmarket.ai/app/redshift-guide" --- [Air Market](/) / [Data & Analytics](/category/data) / Amazon Redshift Guide Skill by [Amazon Web Services](/@aws) # Amazon Redshift Guide Stop writing Postgres SQL at a warehouse that is not Postgres ## What this does Amazon Redshift looks like PostgreSQL and is not, so habits from Postgres quietly produce SQL it rejects. This corrects those assumptions and covers the syntax, loading, and day-to-day operations that are specific to Redshift. Reach for it when a query, a table definition, or a permission is failing and the reason is not obvious. ### Top 3 things it does for you - Write SQL that Redshift will actually accept - Load and unload data - Work out why a query is slow or a permission is denied ## Information **Amazon Redshift Guide at a glance** | | | | --- | --- | | Kind | Skill | | Publisher | [Amazon Web Services](/@aws) | | Category | [Data & Analytics](/category/data) | | Works with | Agent Skills - an open standard supported by 40+ agents | | Version | 1 | | Size | 47 KB | | Licence | Apache-2.0 | | Repository | [aws/agent-toolkit-for-aws](https://github.com/aws/agent-toolkit-for-aws/tree/171d4fba3bc404da3473f323c3e293b4a989f089/skills/specialized-skills/analytics-skills/redshift-guide) | | GitHub stars | 2,420 (as of Nov 2026) | | Installs | 3,636, counted by skills.sh (Nov 2026) | ## Security report **Verified.** AIR scanned this exact version of Amazon Redshift Guide and flagged nothing. AIR's verdict: **safe**. **What Amazon Redshift Guide's check was run against** | | | | --- | --- | | Commit | 171d4fba3bc404da3473f323c3e293b4a989f089 | | Content hash | acbd808cf7e1b9336a33c83488883c8fc7697a506e8da27763ee03973321ea8b | | Files read | [Browse the files at this exact commit](https://github.com/aws/agent-toolkit-for-aws/blob/171d4fba3bc404da3473f323c3e293b4a989f089/skills/specialized-skills/analytics-skills/redshift-guide/SKILL.md) | A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned. [Read the full security report for Amazon Redshift Guide](/security/redshift-guide) ## About Amazon Redshift Guide Redshift resembles PostgreSQL closely enough to invite mistakes, and this guide exists to correct them. It pushes back on Postgres-derived constructs that do not belong here - index creation, string aggregation, certain catalog and type choices, auto-incrementing columns, lateral joins, returning clauses - and points at what Redshift actually uses instead. Alongside that it covers Redshift's own SQL and table definitions, loading and unloading data, its system views and metadata discovery, and the operational patterns behind slow queries, permission errors, disk pressure, workload management, concurrency scaling and resizing. Both provisioned clusters and Serverless workgroups are in scope, as is the Data API. It applies only when the task is about Redshift itself. Other data services have their own guidance, though S3 and Glue come back into scope where they meet Redshift - loading, unloading, and external tables over a data lake. ## What's inside - SKILL.md - instructions - references/redshift-sql-ddl-copy.md - reference - references/redshift-sql-extensions-semantics.md - reference - references/redshift-sql-functions-types.md - reference - references/redshift-sql-materialized-views.md - reference - references/redshift-sql-metadata.md - reference - references/redshift-sql-recipes-load-api.md - reference - references/redshift-sql-syntax.md - reference ## Questions ### Is Amazon Redshift Guide safe to install? AIR scanned this exact version of Amazon Redshift Guide and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit 171d4fba3bc4, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/redshift-guide. ### How do I install Amazon Redshift Guide? Open https://airmarket.ai/app/redshift-guide on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/aws/agent-toolkit-for-aws/tree/171d4fba3bc404da3473f323c3e293b4a989f089/skills/specialized-skills/analytics-skills/redshift-guide. Install from that link, not the branch. ## Related on Air Market - [More Data & Analytics listings](/category/data) - [Everything by Amazon Web Services](/@aws) --- Canonical URL: