skills.rest
a53ali
a53aliCOMMUNITY
Explore all skills by this author →
GitHub

database-migration

Guide database schema migrations with expand/contract patterns and rollback strategies.

Updated Mar 15, 2026
Search Tags:#database migration#database schema#schema evolution#rollback strategy#zero downtime
One-click install
npx skills add https://github.com/a53ali/ai-dev --skill database-migration-a53ali
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/a53ali/ai-dev/tree/main/skills/engineer/database-migration
Command: npx skills add https://github.com/a53ali/ai-dev --skill database-migration-a53ali

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a comprehensive guide to planning and executing safe database schema migrations with zero downtime, ensuring compatibility and data integrity.

Core Features & Use Cases

  • Zero Downtime Migrations: Apply expand/contract patterns and backward-compatible changes to evolve your database schema without downtime.
  • Rollback Strategies: Implement tested rollback plans to revert changes in case of issues.
  • Database-Specific Gotchas: Offer guidance on common pitfalls in PostgreSQL, MySQL, and NoSQL databases, including indexing and online DDL operations.
  • Pre-Deploy Checklist: Ensure a smooth deployment with a checklist covering risk assessment, backward compatibility, and monitoring.

Quick Start

Run the database-migration skill to plan and execute a database migration.

Frequently Asked Questions about database-migration

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

FAQPage Schema
How do I migrate a database schema with zero downtime?▼

Zero downtime database schema migration uses expand/contract patterns to apply backward-compatible changes incrementally, ensuring data integrity and continuous operation during deployment.

What is the expand/contract pattern for database schema evolution?▼

The expand/contract pattern for schema evolution expands the database schema first with new columns or tables, then contracts old structures after application code is updated, preventing downtime and maintaining backward compatibility throughout the process.

How do I create a rollback strategy for database migrations?▼

A rollback strategy for database migrations involves planning backward-compatible changes and tested revert steps to safely undo schema modifications if deployment issues occur, ensuring data integrity is maintained during the reversion process.

Does zero downtime migration work with PostgreSQL, MySQL, and NoSQL databases?▼

Zero downtime migration provides specific guidance for PostgreSQL, MySQL, and NoSQL databases, addressing online DDL operations, indexing strategies, and common pitfalls unique to each database platform to ensure safe schema evolution.

What is included in a pre-deploy checklist for database schema changes?▼

A pre-deploy checklist for database schema changes covers risk assessment, backward compatibility verification, and monitoring setup to ensure smooth deployment and safe execution of zero downtime migrations.

Do I need to know SQL to plan safe database migrations?▼

Planning safe database migrations requires knowledge of SQL and schema evolution techniques to properly implement expand/contract patterns, backward-compatible changes, and effective rollback strategies for data integrity.

Related Skills

Explore More Software Engineering Skills→
amanhsnamanhsn

Migration Architect

Generate phased migration plans with risk assessments and rollback strategies.

Community
Advanced
MicrockMicrock
322

data-migration

Plan and execute database migrations with rollback and integrity validation.

Community
Advanced
rnavarychrnavarych
14

role-fullstack:deployment-workflow

Automate deployment workflows for Vercel, Railway, and Docker with zero-downtime migrations.

Community
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate