database-migration

Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.

Install with Tessl CLI

npx tessl i github:wshobson/agents --skill database-migration

What are skills?

Review — 86%

Does it follow best practices?

If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:

npx tessl skill review --optimize ./path/to/skill

Learn more

Validation — 11 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

Evaluation results

91%

-9%

Rename Profile Column Without Downtime

Zero-downtime column rename

Criteria

Without context

With context

Multiple migration files

100%

Add new column step

100%

Backfill is separate file

100%

20%

Data copy step

100%

Idempotent backfill

100%

Remove old column step

100%

Down function: add step

100%

Down function: remove step

100%

Correct phase ordering

100%

90%

Date-prefixed filenames

100%

Standard module format

100%

Without context: $0.3197 · 4m 41s · 10 turns · 81 in / 6,174 out tokens

With context: $0.6715 · 9m 39s · 25 turns · 244 in / 8,926 out tokens

90%

33%

Split Composite Address Column into Separate Fields

Transaction-based data transformation

Criteria

Without context

With context

Transaction wrapping

100%

Commit and rollback

100%

Backup table creation

Parameterized replacements

33%

100%

New columns added

100%

Old column removed

100%

NULL or trim handling

100%

down() function present

100%

down() restores original

100%

down() reconstructs data

100%

Without context: $0.2441 · 3m 27s · 9 turns · 73 in / 4,090 out tokens

With context: $0.2631 · 2m 21s · 12 turns · 365 in / 2,813 out tokens

96%

-4%

Add Flexible User Preferences Storage Across Database Backends

Cross-database dialect handling

Criteria

Without context

With context

Dialect detection call

100%

MySQL JSON branch

100%

73%

PostgreSQL JSONB branch

100%

Dialect check in up()

100%

createTable in both branches

100%

down() drops table

100%

Both up() and down() present

100%

Primary key defined

100%

Date-prefixed filename

100%

User reference column

100%

Without context: $0.2513 · 3m 51s · 13 turns · 97 in / 3,401 out tokens

With context: $0.2960 · 3m 26s · 14 turns · 388 in / 3,042 out tokens

Evaluated: about 19 hours ago
Agent: Claude Code

Table of Contents

Rename Profile Column Without Downtime Split Composite Address Column into Separate Fields Add Flexible User Preferences Storage Across Database Backends

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.