CtrlK
BlogDocsLog inGet started
Tessl Logo

migrating-to-amazon-redshift

Guides an end-to-end data-warehouse migration to Amazon Redshift — discovery, schema/SQL/stored-procedure/macro/script conversion, data migration, validation, performance comparison, and reporting. Source-routed via `references/<source>/`; Teradata (Vantage) is the supported source; additional sources are added as their own `references/<source>/` sets. Text-only knowledge (no executable code) — the AI generates all execution at runtime. Applies when a user wants to migrate Teradata to Amazon Redshift, convert Teradata DDL/SQL/stored procedures/macros/BTEQ to Redshift/RSQL, or assess Teradata-to-Redshift migration complexity. Applies only to migrations targeting Amazon Redshift; migrations to other platforms (Snowflake, BigQuery, Databricks, etc.) are out of scope regardless of source. Does not cover general Redshift administration, performance tuning, or troubleshooting of existing Redshift clusters (no migration involved), or sources not listed under references/.

68

Quality

83%

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 knowledge-only skill body: clear phased workflow with explicit artifacts, strong security posture, and exemplary progressive disclosure to 13 real one-level-deep references. Its weaknesses are repetition of the no-shipped-code principle (stated four times) and Security-section content that reiterates generic AWS best practice Claude already knows.

Suggestions

State the 'knowledge over shipped code — you generate execution' principle once in 'What this skill is' and delete the restatements in Operating principles ('Skill provides knowledge; you generate execution'), Conversion ('There is no converter to run'), and Security ('No shipped code or dependencies').

Cut the Security section down to migration-specific deltas (read-only DBQL fallback, staging-prefix-scoped COPY IAM_ROLE with condition keys, throwaway-target rule) and drop generic AWS guidance (IAM roles over users, TLS everywhere, Secrets Manager) that Claude already knows.

Add explicit inline per-phase validation gates (e.g., 'do not begin data migration until conversion output passes review of manual_review.json') so the workflow's checkpoints don't depend on opening orchestration.md.

DimensionReasoningScore

Conciseness

The body is mostly dense and non-tutorial, but the core design principle ('no executable code — the AI generates execution') is restated four times across 'What this skill is', 'Operating principles', 'Conversion', and 'Security', and the Security section re-explains generic AWS knowledge (IAM roles over users, TLS, Secrets Manager) Claude already has — matching 'mostly efficient but could be tightened'.

3 / 5

Actionability

For a declared instruction-only skill the guidance is concrete — named tools ('WRITE_NOS + teradatasql', 'COPY … IAM_ROLE'), exact artifact paths (output/discovery/result/inventory.json etc.), pin-exact-versions directive, and routing to specific executable references (72 conversion rules, DBC inventory SQL). It falls short of 5 only because no code or command examples appear inline in the body itself.

4 / 5

Workflow Clarity

A clear six-phase sequence with explicit data handoffs ('each phase's `result/` feeds the next'), an error-recovery loop ('fix Redshift errors ... common-errors.md'), an explicit validation phase, and a blast-radius rule (validate against throwaway Redshift first). It misses 5 because per-phase validation gates and the detailed checkpoint model are delegated to orchestration.md rather than stated inline.

4 / 5

Progressive Disclosure

The body is a genuine overview — principles, workflow, execution modes, and layout — with 13 one-level-deep references under references/teradata/, all verified to exist, each clearly signaled both in a References table and in per-phase inline pointers, exactly matching the top 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.

An exemplary description: explicit what/when with concrete trigger phrases, synonym-rich keywords, and sharply drawn scope boundaries that prevent mis-triggering. Its only weakness is length — roughly 150 words where ~50 would do, including internal source-routing and runtime mechanics that add no trigger value.

Suggestions

Trim the internal mechanics ('Source-routed via `references/<source>/`... additional sources are added as their own sets', 'Text-only knowledge (no executable code) — the AI generates all execution at runtime') to a single short clause or move them to the body — they describe bundle structure, not user-facing capability.

Compress the two boundary sentences ('Applies only to... Does not cover...') into one concise exclusion clause to cut length without losing distinctiveness.

DimensionReasoningScore

Specificity

The description lists comprehensive concrete actions ('discovery, schema/SQL/stored-procedure/macro/script conversion, data migration, validation, performance comparison, and reporting') with no coverage gaps, but interleaves them with internal-bundle mechanics ('Source-routed via `references/<source>/`', 'Text-only knowledge (no executable code) — the AI generates all execution at runtime') that pad length without capability value, placing it between the 4 and 5 anchors.

4 / 5

Completeness

It explicitly answers both what ('Guides an end-to-end data-warehouse migration to Amazon Redshift' with named phases) and when ('Applies when a user wants to migrate Teradata to Amazon Redshift, convert... or assess...') with concrete trigger phrases, exactly matching the top anchor.

5 / 5

Trigger Term Quality

Natural user phrasing is comprehensively covered with synonyms — 'migrate Teradata to Amazon Redshift', 'convert Teradata DDL/SQL/stored procedures/macros/BTEQ to Redshift/RSQL', 'assess Teradata-to-Redshift migration complexity' — matching the comprehensive-synonyms anchor rather than the 'a few natural terms missing' anchor.

5 / 5

Distinctiveness Conflict Risk

A clear niche (Teradata-to-Redshift migration) with explicit exclusions — 'migrations to other platforms (Snowflake, BigQuery, Databricks, etc.) are out of scope' and general Redshift administration excluded — giving minimal conflict risk with other skills.

5 / 5

Total

19

/

20

Passed

Validation

87%

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

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

referenced_paths_exist

Referenced path issues: 31 deeper-than-1-level

Warning

Total

14

/

16

Passed

Repository
aws/agent-toolkit-for-aws
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.