Database Migration Manager Skill for Additive PostgreSQL Changes

Draft a versioned migration, verify older queries on a local copy, and rehearse forward and rollback paths.

Install in Claude Code

Use a local database you control and the existing migration framework. Prepare a disposable copy with three orders.

Get the complete `plugins/database/database-migration-manager/skills/managing-database-migrations` directory from the pinned GitHub commit.
Copy it into the target project's `.claude/skills/`. Check `.claude/skills/managing-database-migrations/SKILL.md`, start Claude Code at the project root, and call `/managing-database-migrations`.

Example task

Add nullable shipment_note to orders. Verify an older list query and a query reading the new column. Roll back in the disposable database, then reapply.

What to check

All three original orders remain readable. The new column appears, disappears on the test rollback, and reappears on reapply.

Original SKILL.md on GitHub · Updated 2026-11-13

Frequently asked question

Can I enforce NOT NULL as soon as the new column exists?

First check that new writes populate it, existing records have been backfilled, and older clients remain compatible. Schedule the constraint separately.