Zero-Downtime Database Migration Plan
"Zero-Downtime Database Migration Plan" is a ready-made prompt from the Zayenha Prompt library in Programming & Tech, written for claude-sonnet-4-7. It has a main prompt to copy into the model, built-in quality guards, and a verification prompt to run in a second window to review the answer. The full text needs the Plus plan; the description is open to all.
Design a zero-downtime schema or data migration using the expand-then-contract pattern, with backward compatibility, safe rollback, and verification, without inventing unsupported engine features.
Your current plan: free
Altering a large live table schema without downtime, migrating data between two representations while the app stays up, splitting or retyping a column on a high-load production system safely.
Built-in quality guards
No fabricated statements, options, or lock behavior unsupported by the specified engine
Migrate personal data without unauthorized exposure, preserving access controls per PDPL
Cover expand, backfill, switch, contract, and rollback without truncation
Adherence to six-section structure, SQL statements, and phase table
Frequently asked questions
How do I use this prompt?
Copy the main prompt and paste it into claude-sonnet-4-7 or the model you use, replace what is in square brackets with your details, then run the verification prompt in a second window with the answer pasted in, and review it before relying on it.
Is this prompt free?
Its full text requires the Plus plan or higher. Free prompts you can copy at once without an account are on the ready-made Arabic prompts page.
Which model was this prompt written for?
It was written for claude-sonnet-4-7 and follows how that model works; you can run it on other models too, reviewing the result, since no single wording guarantees the best result on every model.