database-migration

Reversible database migrations require generating both up and down operations. This skill designs these patterns complete with pre-migration backups, verification queries, and a rollback plan to ensure safe deployment and incident recovery.

Yes, it supports zero-downtime production deployments across PostgreSQL, MySQL, and other engines. It handles schema changes and data migrations while enforcing complete up and rollback patterns with verification queries.

The best way to prepare is by generating a comprehensive deployment runbook alongside the migration. This skill provides a runbook for on-call incidents, including index impact analysis and post-migration validation.

To ensure data backups and verification are included, you need a migration plan that enforces these steps. This skill automatically incorporates pre-migration data backups and verification queries into the generated migration files.

Yes, this database migration approach works with PostgreSQL, MySQL, and other database engines. It designs safe, reversible schema changes and data migrations tailored to your specific database environment.

Validating database schema changes involves running post-migration validation and verification queries. This skill generates these checks and provides a deployment runbook to verify the success of your production migrations.