Prompt · Developer Tools

Migration Planner

Plans a zero-downtime database migration as a safe sequence of deployable steps.

Have ready: Describe the schema change, your database, and table sizes

Fill in · 6 fields

POSTGRESQL / MYSQL / ETC.PASTE SCHEMADESCRIBE THE CHANGEHOW YOU DEPLOY, ROLLING / BLUE-GREEN / SINGLE INSTANCEAPPROXIMATE ROW COUNTSROW COUNT

Your prompt

Plan a zero-downtime migration for this schema change.

Database: [POSTGRESQL / MYSQL / ETC.]
Current schema (relevant tables):
[PASTE SCHEMA]
Desired change: [DESCRIBE THE CHANGE]
Deploy setup: [HOW YOU DEPLOY, ROLLING / BLUE-GREEN / SINGLE INSTANCE]
Table sizes: [APPROXIMATE ROW COUNTS]

Deliver an ordered plan where each step is independently deployable and rollback-safe:
1. The expand/migrate/contract phases (or your alternative), with the exact DDL/DML per step.
2. How the application code must change at each step (dual-write, dual-read, backfill job).
3. The backfill strategy for [ROW COUNT] rows without locking the table.
4. Rollback procedure for each step.
5. What to monitor during the migration and the abort criteria.

Flag anything in my plan request that is NOT zero-downtime-safe as stated.

Paste it into Muse or any assistant. Blank fields stay as [brackets].

More like this