Decide on a database migration strategy
Work out how to change a schema while the system stays available.
What this prompt helps you do
A migration strategy with the compatibility phases, backfill, verification, and rollback at each step.
When to use it
A schema change affects production data and downtime is not acceptable.
What to prepare
The goal, relevant source material, constraints, examples, and the decision or action this should support.
How to get a strong result
Plan the phase where both schemas coexist; that phase is what makes the migration reversible.
How to use this prompt
Replace each placeholder with accurate context. Paste the complete prompt into Claude, review the response critically, resolve important questions, and use it as a considered input to the next decision—not as an unchecked final answer.