migration-safety

Plan and review zero-downtime database migrations with rollback and validation.

2|Updated Mar 16, 2026

Search Tags:#rollback #database #migration #safety #zero-downtime #backfill #schema-changes

Ready to run

npx skills add https://github.com/chicongst/agent-skills-installer --skill migration-safety-chicongst

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: migration-safety
Source: https://github.com/chicongst/agent-skills-installer/tree/main/skills/migration-safety
Command: npx skills add https://github.com/chicongst/agent-skills-installer --skill migration-safety-chicongst

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Plan and review data or schema migrations for safety, rollback, compatibility, and observability.

Core Features & Use Cases

Zero-downtime planning: Expand-contract approach to schema changes, with dual-write and coexistence during migration.
Rollback readiness: Comprehensive rollback steps, testing, and data integrity guarantees.
Observability & validation: Defined validation queries, performance monitoring, and compatibility checks to verify success.

Quick Start

Apply the three-phase expansion, migrate, and contract process to a test migration to validate zero-downtime before production.

Frequently Asked Questions about migration-safety

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I plan a zero-downtime database migration for large-scale schema changes?▼

Plan zero-downtime database migrations using a three-phase expansion, migrate, and contract process. This approach enforces dual-write compatibility and coexistence during the transition to ensure live databases remain fully operational.

What is the best way to guarantee rollback capability during a live data migration?▼

Guarantee rollback capability during data migration by defining comprehensive rollback steps, testing procedures, and data integrity guarantees before execution. This ensures you can safely revert schema changes if validation queries detect deployment issues.

How does the expand and contract pattern work for backfill strategies?▼

The expand and contract pattern works by first expanding the database schema to support both old and new structures, running backfill strategies to migrate data, and finally contracting by removing deprecated columns once dual-write compatibility is verified.

How do I validate database schema changes and monitor performance during a migration?▼

Validate database schema changes by executing defined validation queries, running performance monitoring, and performing compatibility checks. This observability verifies migration success and ensures risk-aware deployment across live databases.

When should I use dual-write compatibility during a database migration transition?▼

Use dual-write compatibility during database migration transitions when applying large-scale schema changes that require zero-downtime. It allows old and new schema versions to coexist safely, preventing application errors during the migrate phase.

How do I test a zero-downtime migration before executing it in production?▼

Test zero-downtime migrations by applying the three-phase expansion, migrate, and contract process to a test migration. This validates rollback procedures and compatibility matrices to ensure risk-aware production deployment.