/migration-writer

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

BOOST

archive228@archive228

GitHub

From plugin

loopkit

75553 skills1 agent4 commands2 MCP

Install

$ npx -y skills add Archive228/loopkit --skill migration-writer --agent claude-code

How it fires

How this skill gets triggered: by you, by Claude, or both.

Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.
You can call itInvoke it directly when you want it.
Slash command/migration-writer

Context preview

The summary Claude sees to decide when to auto-load this skill.

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

SKILL.md

migration-writer.SKILL.md

name: migration-writer
description: Write safe, reversible database migrations for this repo's conventions. Use for any schema change.
when_to_use: add/alter a table, column, index, or constraint

Migration Writer

1. Read the current schema first. Match the repo's migration tool and naming (`NNN_<verb>_<noun>`). 2. Write BOTH up and down. A migration you can't reverse is a migration you can't deploy safely. 3. **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. 4. Backfill large tables in batches, not one statement. 5. Never edit an already-merged migration — add a new one. Test with a dry-run before committing. Output the migration + the exact deploy order.

Read it on GitHub ↗

Ships withloopkit

33 battle-tested skills + minimal .claude harness for any coding agent (Claude Code, Cursor, Codex, Gemini CLI).

Get the whole plugin

Stats

Node Bash SQL Git GitHub

+4 tags

Markdown Anthropic Gemini MCP

755

Stars

124

Forks