Migration Writer

SkillDatabases & data

Write safe, reversible database migrations for this repo's conventions. Use for any schema change.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the Migration Writer skill

What this skill tells your AI

The instructions your AI receives, as published by archive228/loopkit in skills/migration-writer/SKILL.md and read by ahel’s review.

Read the current schema first. Match the repo's migration tool and naming (NNN_<verb>_<noun>).
Write BOTH up and down. A migration you can't reverse is a migration you can't deploy safely.
Live-safe: on a hot table, adding a NOT NULL column with no default, or an index without CONCURRENTLY, takes a blocking lock. Split into steps: add nullable → backfill → add constraint.
Backfill large tables in batches, not one statement.
Never edit an already-merged migration — add a new one. Test with a dry-run before committing. Output the migration + the exact deploy order.

Advanced