Plan and document database schema migrations with rollback strategies.
## Workflow: Database Migration Planning **Input:** Current schema, target changes, DB engine, and table sizes. **Step 1 — Impact:** Analyze affected tables, indexes, and FK constraints. **Step 2 — Migration Script:** Generate forward SQL respecting constraints. **Step 3 — Rollback:** Create rollback script and validation queries. **Output:** Migration plan with impact, forward/rollback scripts, and checks.
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash.
Provide your current schema DDL and describe the desired changes. Include table row counts for accurate timing estimates.
Initial release
Sign in and download this prompt to leave a review.