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

71%

Does it follow best practices?

Impact

92%

1.08x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./tests/ext_conformance/artifacts/agents-wshobson/framework-migration/skills/database-migration/SKILL.md

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%

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%

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%

Repository: Dicklesworthstone/pi_agent_rust
Commit: 47823e3

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

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.