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.

1.08x

Quality

67%

Does it follow best practices?

Impact

99%

1.08x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./plugins/framework-migration/skills/database-migration/SKILL.md

Evaluation results

100%

25%

Address Data Migration

Transaction-based data transformation migration

Criteria

Without context

With context

Transaction wrapping

100%

Commit on success

100%

Rollback on error

100%

Parameterized query replacements

100%

Per-record iteration

100%

Old column removed in up

100%

Down function reverses transformation

100%

Correct up/down module structure

100%

New columns added before data copy

100%

Run/rollback commands documented

100%

Production Schema Refactoring Without Downtime

Zero-downtime column rename and type change

Criteria

Without context

With context

Rename: add new column first

100%

Rename: data copied to new column

100%

Rename: old column removed last

100%

Type change: new column added

100%

Type change: data cast and copied

100%

Type change: old column dropped

100%

Type change: new column renamed

100%

Migration down functions present

100%

Phased deployment described

100%

CLI commands included

100%

Correct module.exports structure

100%

97%

-1%

Multi-Database Safe Migration with Rollback Safety Net

Cross-database migration with checkpoint-based rollback

Criteria

Without context

With context

Dialect detection

100%

JSONB for PostgreSQL

100%

JSON for MySQL

100%

Column default value set

100%

62%

Backup table created

100%

Migration verification

80%

100%

Backup dropped on success

100%

Restore on failure

100%

Down function present

100%

Run/rollback commands documented

100%

Module.exports structure

100%

Repository: wshobson/agents
Commit: 91fe43e

Evaluated: 27 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Address Data Migration Production Schema Refactoring Without Downtime Multi-Database Safe Migration with Rollback Safety Net

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.