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

86%

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

71%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-structured router/index body with excellent progressive disclosure (all 12 referenced files exist, one level deep, with a mandatory routing table) and strong safety checkpoints. Its main weakness is verbosity in the storage sections, where reference-file content is inlined into the routing table and Critical Facts rather than kept in the referenced files.

Suggestions

Trim the storage routing-table rows to short intent phrases and move the diagnostic methodology ('split it into four', the CloudWatch-trend and SYS_VACUUM_HISTORY attribution detail) into references/redshift-storage-utilization.md, keeping only the route-to pointer in SKILL.md.

Shorten the storage bullet in Critical Facts to the rule ('attribute before you remediate, never reflex-VACUUM') plus the file pointers, leaving the spill/skew/cache rationale to the storage references.

Add one explicit verify-before-proceeding feedback step to the storage and slow-query flows (e.g., re-check the metric or re-run the diagnostic query after remediation) to close the validation-loop gap.

DimensionReasoningScore

Conciseness

The body is dense with non-obvious facts and assumes Claude's competence throughout, but the storage routing rows and the storage bullet in Critical Facts inline substantial reference-level detail (diagnostic flow, per-section content previews, CloudWatch trend methodology, 'never from AWS Backup's own incremental-copy documentation') that belongs in the referenced files — noticeably more than minor trimming would fix, so it fits the mostly-efficient-but-could-be-tightened (3) anchor rather than the minor-instances (4) anchor.

3 / 5

Actionability

Guidance is concrete and executable — specific SQL ('DATEADD(day, -30, GETDATE())'), views ('sys_load_error_detail', 'SVV_MV_INFO', 'SYS_VACUUM_HISTORY'), commands and flags ('--wait-time-seconds, 1–30', 'aws logs associate-kms-key', 'sslmode=verify-full') — with only the minor gap that full copy-paste recipes live in the referenced files rather than inline, which is appropriate for a router skill and keeps it at anchor 4 rather than 5.

4 / 5

Workflow Clarity

A clear sequence is present — the 'read first' divergence section, 'STEP 0: Serverless or Provisioned? ... Establish this before answering', a MANDATORY routing table ('you MUST load and read the referenced file BEFORE answering'), and warn-then-confirm guardrails for destructive operations (TRUNCATE, VACUUM on large tables) — but the body itself lacks an explicit validate→fix→retry feedback loop, keeping it below anchor 5.

4 / 5

Progressive Disclosure

The body is a genuine overview/index: every routing target from 'references/redshift-sql-syntax.md' through 'references/redshift-auth-authorization.md' exists as a real file in the bundle (all 12 verified), references are one level deep and clearly signaled ('→ Load ...'), and content is appropriately split across per-topic files with a mandatory intent→file routing table, matching the clear-overview anchor.

5 / 5

Total

16

/

20

Passed

Description

95%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.

A highly effective description: third-person voice, explicit what/when with an extensive natural trigger list, and explicit exclusions that sharply bound the skill's applicability. The only soft spot is that it names coverage domains slightly more than discrete user-facing actions.

DimensionReasoningScore

Specificity

Concrete behaviors are named — 'corrects LLM mistakes', 'Pushes back on: CREATE INDEX, string_agg, pg_catalog, text type, SERIAL, stl_query' — and coverage is comprehensive ('covers SQL, metadata, connectivity/auth, storage, query performance, and operations'), but the phrasing enumerates coverage domains more than discrete executable actions, placing it between the 'several specific actions' (4) and 'multiple specific concrete actions' (5) anchors.

4 / 5

Completeness

Both 'what' ('corrects LLM mistakes; covers SQL, metadata, connectivity/auth, storage, query performance, and operations') and an explicit 'when' ('Triggers on: Redshift SQL, Redshift CREATE TABLE, Redshift COPY/UNLOAD, ... datashares') are clearly present with concrete trigger phrases, plus an explicit negative boundary — matching the anchor-5 example pattern rather than the when-could-be-more-explicit (4) anchor.

5 / 5

Trigger Term Quality

The 'Triggers on:' clause comprehensively covers natural user phrasings with synonyms and variations — 'slow or suddenly slow Redshift query', 'stale statistics/ANALYZE', 'ghost rows/bloat', 'spill to disk', 'queue wait', 'connection failures (SSL/TLS, ODBC/JDBC, connection limit)' — matching the comprehensive-with-synonyms anchor, not merely the good-coverage-with-a-few-missing (4) anchor.

5 / 5

Distinctiveness Conflict Risk

'Applies ONLY to Redshift (provisioned or Serverless)' combined with an explicit exclusion list ('Does NOT apply to: S3 policies, Athena, Glue/Iceberg outside Redshift, Aurora, RDS, DynamoDB') establishes a clear niche with minimal conflict risk against adjacent database-service skills.

5 / 5

Total

19

/

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

aws/agent-toolkit-for-aws

Path

plugins/aws-data-analytics/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.