Evolve schemas without downtime: expand/contract (add -> backfill in batches -> switch -> drop) across separate deploys, lock-aware DDL (create indexes CONCURRENTLY, nullable-add-then-validate), reversibility, and ordered versioned migrations.
Scanned 9/23/2026
Skills Directorynpx -y skills add mcorbett51090/RavenClaude --skill safe-schema-migrations --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Safe Schema Migrations?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/mcorbett51090-safe-schema-migrations)More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.
---
name: safe-schema-migrations
description: "Evolve schemas without downtime: expand/contract (add -> backfill in batches -> switch -> drop) across separate deploys, lock-aware DDL (create indexes CONCURRENTLY, nullable-add-then-validate), reversibility, and ordered versioned migrations."
---
# Safe Schema Migrations
## Expand/contract
Add new (safely) -> **backfill in batches** -> dual-write/switch reads -> drop old. Across **separate deploys**. A rename = add-copy-switch-drop, not `ALTER RENAME` mid-traffic.
## Lock awareness
Volatile-default add, type change, or `SET NOT NULL` can lock the table. Use: nullable add + batched backfill + `ADD CONSTRAINT ... NOT VALID` then `VALIDATE`; create indexes **CONCURRENTLY**.
## Reversible + ordered
Every migration has a down path / tested rollback. Versioned, ordered, never edit a shipped migration. Sequence with `devops-cicd/release-engineer`.
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
