CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

redshift-guide

Amazon Redshift is NOT PostgreSQL; corrects LLM mistakes; covers SQL, metadata, connectivity/auth, storage, query performance, and operations. Applies ONLY to Redshift (provisioned or Serverless). Pushes back on: CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query. Triggers on: Redshift SQL, Redshift CREATE TABLE, Redshift COPY/UNLOAD, slow or suddenly slow Redshift query, EXPLAIN plan, queue wait, stale statistics/ANALYZE, result cache, Redshift permission denied, Redshift disk full, storage growth, snapshot/backup cost, ghost rows/bloat, VACUUM, spill to disk, distribution skew, Redshift system views, QUALIFY, PIVOT, MERGE, materialized views, Redshift Data API (Python/boto3), Redshift workload management (WLM), concurrency scaling, Redshift resize, Spectrum, awsdatacatalog, connection failures (SSL/TLS, ODBC/JDBC, connection limit), IAM/SAML federation, IAM Identity Center, datashares. Does NOT apply to: S3 policies, Athena, Glue/Iceberg outside Redshift, Aurora, RDS, DynamoDB.

Quality

94%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

85%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-engineered router skill: dense, factual, with strong safety validation and a verified flat reference structure. Its only weaknesses are repetition of the Serverless/provisioned determination and routing cells that quote user phrasings at length, plus a few deferred execution details that keep the quick reference from being fully self-contained.

Suggestions

State the provisioned-vs-Serverless determination once (STEP 0) and have the Routing Table point back to it instead of repeating the instructions.

Trim the storage routing cell's parenthetical user-phrasing quotes to the core intents and move the full phrasing variants into the storage reference.

Inline a minimal executable example of the bounded Data API poll loop (and the exact CloudWatch metric/period for storage trends) so the quick reference covers the most common case without a file load.

DimensionReasoningScore

Conciseness

The body is dense and mostly lean — Critical Facts gives exact commands and error strings with no concept explanations — but the provisioned/Serverless determination is stated twice (STEP 0 and repeated nearly verbatim under the Routing Table), and the storage routing cell embeds long parenthetical user-phrasing quotes that could be tightened. Efficient with minor trim opportunities, matching anchor 4 rather than anchor 5's 'every token earns its place'.

4 / 5

Actionability

Concrete throughout: exact tool names ('execute_query', 'retrieve_skill_file', 'list_*'), executable fragments ('DATEADD(day, -30, GETDATE())', 'SHOW VIEW <schema.name>', "ENCRYPTED KMS_KEY_ID '<arn>'"), and exact error strings ('SUBSTR() function is not supported'). Some guidance stays high-level with execution deferred to references ('keep a bounded loop', 'trend from CloudWatch over months'), leaving minor gaps versus the fully copy-paste-ready anchor 5.

4 / 5

Workflow Clarity

Clear sequence (STEP 0 establish target type → routing table → MANDATORY load-before-answer → answer) with explicit validation for destructive operations ('WARN then confirm: RESIZE, RESTORE, VACUUM on large tables ... TRUNCATE forces an implicit COMMIT ... name the target table and say the rows are unrecoverable') and feedback loops routing error strings ('relation does not exist', 'permission denied') to diagnostic flows. The destructive/batch validation cap does not apply because those checkpoints are present.

5 / 5

Progressive Disclosure

SKILL.md is a genuine overview/router: all 12 cited 'references/*.md' paths verified to exist, references are one level deep (only sibling cross-links between the storage pair; the syntax file is a clearly labeled index while the routing table routes most SQL questions directly to the target file), and every load is well signaled ('→ Load references/...'). Matches the clear-overview, well-signaled one-level-deep anchor.

5 / 5

Total

18

/

20

Passed

Description

100%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

An exemplary description: third-person, concrete, and dense with natural trigger phrases, explicitly separating what it does, when it triggers, and what it excludes. Its length is spent entirely on triggers and scope rather than fluff, so the verbosity penalty does not bite.

DimensionReasoningScore

Specificity

Names concrete capabilities ('corrects LLM mistakes; covers SQL, metadata, connectivity/auth, storage, query performance, and operations') plus a specific pushback list ('CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query') — comprehensive, concrete coverage in third person. Anchor 4 ('several specific actions; minor gaps') fits worse because both the capability areas and the exact divergences corrected are enumerated.

5 / 5

Completeness

Explicitly answers both 'what' ('corrects LLM mistakes; covers ... operations') and 'when' ('Triggers on:' followed by a concrete trigger list), plus negative scope ('Does NOT apply to: S3 policies, Athena, ...'). Clearly the anchor-5 example pattern; not anchor 4, where the 'when' is only partially explicit.

5 / 5

Trigger Term Quality

Triggers are natural user phrasings with synonyms and variants: 'slow or suddenly slow Redshift query', 'Redshift disk full', 'ghost rows/bloat', 'spill to disk', 'connection failures (SSL/TLS, ODBC/JDBC, connection limit)', 'snapshot/backup cost'. This matches the comprehensive-with-synonyms anchor; nothing common is missing.

5 / 5

Distinctiveness Conflict Risk

'Applies ONLY to Redshift (provisioned or Serverless)' plus an explicit exclusion list ('S3 policies, Athena, Glue/Iceberg outside Redshift, Aurora, RDS, DynamoDB') gives a clear niche with minimal conflict risk. Neighboring anchor 4 ('minor overlap risk') is weaker because the exclusions proactively remove the overlap candidates.

5 / 5

Total

20

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

awslabs/mcp

Path

src/redshift-mcp-server/awslabs/redshift_mcp_server/skills/redshift-guide/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.