database-migration-safety
CommunityPrevent outages during production schema changes.
Software Engineering#database migrations#schema change#backfill#production safety#expand-contract#rollback planning#online schema change
Authorohsonerdy
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It prevents production incidents caused by unsafe database schema migrations by ensuring changes are planned and executed with clear lock-safety, rollback/one-way discipline, and the expand-contract approach.
Core Features & Use Cases
- Expand-contract migration planning: Breaks risky schema+code changes into independent phases (expand, migrate, switch, contract) so the system never lands in a broken transitional state.
- Online safety filtering by operation type: Evaluates common operations (NOT NULL, type changes, constraints, unique indexes, FK validation, drops/renames) and flags when they require expand-contract or online schema change tooling.
- Operationally safe backfill and rollback strategy: Designs throttled, resumable, idempotent backfills and enforces reversible vs explicitly one-way decisions with backup-verified rollback paths.
Quick Start
Use database-migration-safety when you are planning a production migration to get an expand-contract phase plan, a lock/online-safety verdict, and a rollback or explicitly one-way justification.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: database-migration-safety Download link: https://github.com/ohsonerdy/openclaw-frontier-stack/archive/main.zip#database-migration-safety Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.