CtrlK
BlogDocsLog inGet started
Tessl Logo

database-migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

64

Quality

76%

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

Fix and improve this skill with Tessl

tessl review fix ./.kiro/skills/database-migrations/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

75%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 highly actionable, code-dense reference whose examples are immediately executable across PostgreSQL and four migration tools. Its weaknesses are structural: duplicated when-to-use sections, a twice-explained expand-contract pattern, and no explicit post-migration validation/feedback loops for destructive or batch operations.

Suggestions

Merge the duplicate 'When to Activate' and 'When to Use This Skill' sections and drop one of the two expand-contract explanations to cut ~40 lines of redundancy.

Add explicit validation feedback loops for destructive/batch operations, e.g. check `prisma migrate status` / `migrate ... version` after applying, and an 'if dirty: force VERSION then re-run' recovery step.

Move the per-ORM workflow sections (Prisma, Drizzle, Django, golang-migrate) into one-level-deep references/ files, keeping SKILL.md as the overview of core patterns and the safety checklist.

DimensionReasoningScore

Conciseness

The body is mostly dense, code-first content, but it duplicates whole sections — "When to Activate" and "When to Use This Skill" repeat nearly the same bullet list, and the expand-contract pattern is fully explained twice ("Renaming a Column (Zero-Downtime)" and "Zero-Downtime Migration Strategy"). This is more than minor trimming, matching anchor 3 ('could be tightened') rather than 4.

3 / 5

Actionability

Fully executable, copy-paste-ready guidance throughout: exact SQL for every pattern (including a batching loop with FOR UPDATE SKIP LOCKED and GET DIAGNOSTICS), per-tool CLI commands ("npx prisma migrate dev --create-only", "migrate -path migrations -database \"$DATABASE_URL\" up"), and complete Django migration classes. This matches the anchor-5 example of executable code covering common cases.

5 / 5

Workflow Clarity

The expand-contract strategy has a clear phased sequence with a day-by-day timeline, and the Migration Safety Checklist plus "Verify data consistency" in Phase 2 act as checkpoints. It is capped below 5 for destructive/batch database operations because there are no explicit fail-and-retry validation loops — only a passing "force VERSION (fix dirty state)" hint — whereas anchor 5 requires explicit validate/fix/revalidate steps.

4 / 5

Progressive Disclosure

No bundle files exist and the single-file body is well-sectioned (per-DB patterns, per-ORM workflows, strategy, anti-pattern table), with each subsection compact enough to justify inlining. It is a 4 rather than 5 because at ~340 lines the four ORM-specific workflow sections could be split into one-level-deep reference files, and the two 'when to use' sections fragment navigation.

4 / 5

Total

16

/

20

Passed

Description

78%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 strong description: third-person, specific about tools and capability areas, with an explicit 'Use when' clause. Main gaps are noun-phrase rather than verb-led actions and a trigger clause narrower than the skill's actual scope.

Suggestions

Rewrite the capability list with verb-led actions (e.g., 'Plan and apply safe schema changes, backfill data, and execute zero-downtime deploys') to sharpen specificity.

Broaden the trigger clause to include troubleshooting failed migrations and reviewing migration PRs, which the body identifies as core use cases.

DimensionReasoningScore

Specificity

Phrases like "schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate)" list several concrete capability areas plus specific tools. It sits at anchor 4 rather than 5 because capabilities are stated as noun topics ("best practices for X") rather than multiple concrete verb-led actions, leaving minor gaps in coverage.

4 / 5

Completeness

Both what ("Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments...") and when ("Use when planning or implementing database schema changes") are explicitly present. It falls short of anchor 5 because the trigger clause is narrow — it omits troubleshooting, reviewing migration PRs, and setting up migration tooling, which the body itself lists as use cases.

4 / 5

Trigger Term Quality

Natural terms users would say — "database migration", "schema changes", "rollbacks", "zero-downtime", plus five tool names — give good keyword coverage. Not a 5 because common variations users actually say ("add a column", "ALTER TABLE", "migrations", "backfill") are missing.

4 / 5

Distinctiveness Conflict Risk

A clear niche with distinct triggers: database migrations with named engines and ORMs ("PostgreSQL, MySQL... Prisma, Drizzle, Django, TypeORM, golang-migrate") is unmistakable and would not plausibly fire a general SQL, ORM, or devops skill. Matches the anchor-5 example's structure of distinct, specific triggers.

5 / 5

Total

17

/

20

Passed

Validation

93%

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

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Repository
affaan-m/ECC
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.