# Database Migrations

> Evolve persistent schemas safely with compatible migrations, backfills, rollback strategy, and integrity checks.

- Skill: `nafeeur/database-migrations` (Agent Skill)
- Install (CLI): `npx skillmds@latest add nafeeur/database-migrations`
- Raw SKILL.md: https://api.skillmd.com/api/skills/nafeeur/database-migrations/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: nafeeur (https://skillmd.com/u/nafeeur)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/nafeeur/database-migrations

---


# Database Migrations

- Inspect current schema, data volume, indexes, constraints, and application read/write paths.
- Prefer additive, backward-compatible phases for live systems.
- Wrap compatible changes in transactions; make migrations idempotent and versioned.
- Separate schema change, backfill, and cleanup when locks or runtime compatibility matter.
- Validate row counts, nullability, uniqueness, foreign keys, FTS/index synchronization, and rollback behavior.
- Back up or checkpoint before destructive operations.