skills.rest
wpank
wpankCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-migrations

Guide zero-downtime database migrations with rollback planning and schema evolution strategies for production systems.

11|4|Updated Feb 9, 2026
Search Tags:#rollback#database#migrations#zero-downtime#production deployment#schema evolution
One-click install
npx skills add https://github.com/wpank/ai --skill database-migrations-wpank
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/wpank/ai/tree/main/skills/api/database-migrations
Command: npx skills add https://github.com/wpank/ai --skill database-migrations-wpank

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides strategies and best practices for performing database migrations in production environments without causing downtime or data loss.

Core Features & Use Cases

  • Zero-Downtime Strategies: Learn techniques like additive-only schema changes, expand-contract patterns, and parallel changes.
  • Rollback Planning: Understand how to create safe rollback procedures for both schema and data migrations.
  • Tooling Guidance: Get an overview of popular migration tools like Prisma, Knex, Alembic, and Flyway.
  • Use Case: You need to add a new column to a large, critical production table. This Skill will guide you through the safest process, ensuring no users are affected.

Quick Start

Use the database-migrations skill to learn about zero-downtime patterns for adding columns to production databases.

Frequently Asked Questions about database-migrations

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

FAQPage Schema
How do I perform zero-downtime database migrations in production?▼

Safe rollback planning for database migrations requires decoupling schema changes from data migrations, allowing you to reverse deployable code versions independently while retaining backward compatibility.

What is the expand-contract pattern for schema evolution?▼

The expand-contract pattern is a schema evolution technique that separates database migrations into expansion phases to add new structures and contraction phases to remove deprecated ones safely.

How do I plan a safe rollback for a production database migration?▼

Safe rollback planning for database migrations requires decoupling schema changes from data migrations, allowing you to reverse deployable code versions independently while retaining backward compatibility.

Which database migration tools work best for zero-downtime deployments?▼

Popular database migration tools like Prisma, Knex, Alembic, and Flyway provide version control and scripting capabilities needed to automate safe schema evolution and production deployments.

How do I add a new column to a large production table without downtime?▼

Adding columns to large production tables requires zero-downtime strategies like applying additive-only schema changes first, ensuring no existing users or queries are blocked during the database migration.

Related Skills

Explore More Software Engineering Skills→
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate
t-stringst-strings

Backend Migrations

Standardize versioned database migration scripts with rollback support and execution logs.

Official
Basic
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
christopherlouetchristopherlouet
5

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

Community
Advanced