SKILL-052 Data modeling and migrations Locked skill

Migration strategy

Separate the structural change from the data backfill, and think through the rollback before you deploy — not after it breaks.

01

What this skill helps you build

A disciplined way to evolve your database schema — forward-only, reviewed, and rolled back in your head before it ever runs in production.

The production takeaway

Separate the structural change from the data backfill, and think through the rollback before you deploy — not after it breaks.

02

Inside this skill

The full skill expands these implementation areas with decisions, edge cases, prompts, tests, and framework-specific code.

Data modeling and migrations
What this helps you build

A repeatable, low drama process for changing your database over time. Instead of hand edited SQL run from someone's laptop, you get ordered, reviewed migration files that move the

🔒
Data modeling and migrations
When to use this

Use this the moment more than one person — or more than one environment — shares a database. Concretely, reach for a deliberate migration strategy when you have: A schema that has

🔒
Data modeling and migrations
The core idea

Three rules carry almost all of the safety. Migrations are forward only. You never edit a migration that has already run anywhere but your own machine. Made a mistake? Write a new

🔒
03

Unlock the full implementation

Paid access includes the complete skill body, implementation prompt, common mistakes, production checklist, and code examples where this skill includes them.