CtrlK
BlogDocsLog inGet started
Tessl Logo

database-migrations-sql-migrations

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Focus on data integrity and rollback plans.

38

Quality

36%

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 ./skills/database-migrations-sql-migrations/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

11%Scale 1-5

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

This skill is essentially a hollow template with no actionable content. Despite targeting a complex domain (zero-downtime SQL migrations with rollback plans), it provides no SQL examples, no concrete migration patterns, no validation scripts, and no actual workflow steps. The content reads like a table of contents for a skill that was never written.

Suggestions

Add concrete, executable SQL migration examples for at least one database (e.g., a PostgreSQL expand-contract column rename with specific ALTER TABLE statements and data backfill scripts).

Define an explicit multi-step workflow with validation checkpoints: e.g., 1. Create migration script → 2. Run in staging → 3. Validate row counts/checksums → 4. If errors, execute rollback script → 5. Only when validated, apply to production.

Include a concrete rollback script template paired with a migration script, showing the exact SQL for both forward and backward operations.

Remove generic filler sections ('When to Use', 'Do Not Use', 'Context') and replace the vague 'Instructions' with specific, domain-relevant guidance such as lock-avoidance strategies, batch size recommendations, and concurrent read handling.

DimensionReasoningScore

Conciseness

The content is padded with sections that add no value ('When to Use', 'Do Not Use', 'Context') and explains things Claude already knows. The 'Overview' paragraph restates the skill description verbatim. Instructions are generic filler ('Clarify goals, constraints, and required inputs') rather than domain-specific guidance.

2 / 5

Actionability

There is zero concrete, executable guidance anywhere in this skill. No SQL code examples, no specific commands, no migration script templates, no actual rollback procedures. Every instruction is abstract and vague (e.g., 'Apply relevant best practices and validate outcomes').

1 / 5

Workflow Clarity

Despite the skill being about multi-step migration processes involving destructive/batch operations, there are no sequenced steps, no validation checkpoints, and no feedback loops. The 'Output Format' lists deliverables but provides no workflow for producing them. Database migrations are inherently destructive/batch operations, and the complete absence of validation steps is critical.

1 / 5

Progressive Disclosure

There are no bundle files and no actual references to external files despite mentioning 'implementation playbooks.' The content is a flat, shallow document that neither provides inline detail nor points to supplementary materials. The section structure exists but contains no substantive content worth organizing.

2 / 5

Total

6

/

20

Passed

Description

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

The description identifies a clear domain (SQL database migrations) and includes useful specifics like supported databases and zero-downtime focus, giving it reasonable distinctiveness. However, it lacks an explicit 'Use when...' clause, which is critical for skill selection, and the concrete actions could be more detailed (e.g., generating migration scripts, handling schema changes). Adding trigger guidance and more specific actions would significantly improve it.

Suggestions

Add an explicit 'Use when...' clause with trigger phrases like 'Use when the user asks about database migrations, schema changes, altering tables, or deploying database updates with minimal downtime.'

List more concrete actions such as 'generate migration scripts, add/remove columns safely, rename tables, create rollback scripts, handle data backfilling'.

Include additional natural trigger terms like 'schema change', 'alter table', 'DDL', 'migration script', or 'database deploy'.

DimensionReasoningScore

Specificity

Names the domain (SQL database migrations) and mentions a couple of concrete concepts (zero-downtime strategies, rollback plans, data integrity), but doesn't list specific actions like 'generate migration scripts', 'add columns', 'rename tables', or 'create rollback scripts'. The actions remain somewhat abstract.

3 / 5

Completeness

The 'what' is reasonably clear (SQL database migrations with zero-downtime strategies, data integrity, rollback plans), but there is no explicit 'when' clause or trigger guidance. Per rubric rules, a missing 'Use when...' clause caps completeness at 3.

3 / 5

Trigger Term Quality

Includes good natural keywords: 'SQL', 'database migrations', 'zero-downtime', 'PostgreSQL', 'MySQL', 'SQL Server', 'rollback', 'data integrity'. Missing some common user phrases like 'schema change', 'alter table', 'migration script', 'deploy database changes', or 'DDL'.

4 / 5

Distinctiveness Conflict Risk

Fairly distinct by specifying database migrations with zero-downtime strategies and naming three specific database engines. Minor overlap risk with general database management or SQL query skills, but the migration and zero-downtime focus narrows the niche well.

4 / 5

Total

14

/

20

Passed

Validation

90%

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

Validation10 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

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

Warning

Total

10

/

11

Passed

Repository
administrakt0r/AI-Agents-Safe-Coding-Skills
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.