skills.rest
cwinvestments
cwinvestmentsCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

migration-planner

Generate database schema migration scripts with rollback strategies.

412|45|Updated Feb 19, 2026
Search Tags:#deployment#rollback#database#schema#migration#sql
One-click install
npx skills add https://github.com/cwinvestments/memstack --skill migration-planner-cwinvestments
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migration-planner
Source: https://github.com/cwinvestments/memstack/tree/main/skills/development/migration-planner
Command: npx skills add https://github.com/cwinvestments/memstack --skill migration-planner-cwinvestments

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users plan and execute database schema changes safely, minimizing the risk of data loss or application downtime.

Core Features & Use Cases

  • Schema Analysis: Compares current and desired database schemas to identify potential risks.
  • Migration Script Generation: Creates UP and DOWN SQL scripts for schema modifications.
  • Zero-Downtime Strategy: Provides a phased approach for deploying changes without interrupting service.
  • Rollback Planning: Defines clear procedures for reverting changes if issues arise.
  • Use Case: When a user needs to add a new column to a production table without causing downtime, this skill will guide them through the multi-phase process, including backfilling data and updating application code.

Quick Start

Use the migration planner to create a migration script for adding a new 'email' column to the 'users' table in PostgreSQL.

Frequently Asked Questions about migration-planner

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

FAQPage Schema
How do I generate a safe database schema migration script with a rollback strategy?▼

To generate a safe database schema migration script, this planner analyzes schema differences and provides UP and DOWN SQL operations paired with clear rollback procedures to revert changes if issues arise.

What is the best way to add a new column to a production database table without causing downtime?▼

Adding a new column to a production database table without downtime requires a zero-downtime strategy, utilizing a phased deployment approach that includes backfilling data and updating application code incrementally.

Does this database migration planner support PostgreSQL and MySQL with ORMs like Prisma and Drizzle?▼

Yes, this database migration planner supports various databases like PostgreSQL and MySQL, and it also works with ORM frameworks such as Prisma and Drizzle to generate compatible schema migration scripts.

How do I plan a phased deployment for production database schema changes?▼

Planning a phased deployment for production database schema changes involves analyzing current and desired schemas to identify risks, then outlining multi-phase steps for backfilling data and deploying updates without service interruption.

What are the limitations of using automated rollback procedures for SQL schema migrations?▼

Automated rollback procedures for SQL schema migrations rely on generated DOWN scripts to revert changes, but complex data transformations or deleted columns may limit the ability to fully restore the original database state without data loss.

Why do I need to backfill data when doing a zero-downtime database schema migration?▼

Backfilling data during a zero-downtime database schema migration is necessary to populate newly added columns with existing values safely while the application continues to serve traffic without interruption.

Related Skills

Explore More Software Engineering Skills→
AgentientAgentient
2

database-schema-evaluator

Analyze database schemas and generate structured multi-lens evaluation reports.

Official
Advanced
mitul-bhatiamitul-bhatia

database-migrations

Plan reversible database migrations across PostgreSQL, MySQL, and common ORMs.

Community
Advanced
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
MicrockMicrock
322

relational-database-mcp-cloudbase

Execute SQL operations and manage security rules on CloudBase Relational Database via MCP tools.

Community
Advanced