Database Migration Plan
Plans a schema change that ships without downtime, in steps that are each independently safe and reversible.
Free — no card needed
Create a free account
to open Database Migration Plan — and the other 364 prompts across 21 categories.
Already have an account?
Running it, start to finish
- Describe the change with real table sizes and write volume.
- Deploy each step separately, verifying between.
- Stop at the point of no return and confirm before proceeding.
What you get back
The output this produces, every time.
- Starts from which application versions must coexist with which schema states.
- Names the operations that lock dangerously at your data size, which is where staging-clean migrations fail.
- Marks the point of no return as a decision rather than something discovered.
Getting better results
Where this usually goes wrong, and how to avoid it.
- Give it real table sizes. Section 3 is entirely dependent on them. A migration that is instant at 10k rows can hold a lock for minutes at 10 million.
- Watch replication lag during backfill. A batched backfill that outruns replication takes down read replicas, which is usually where your traffic is.
- Check every intermediate state is overnight-safe. Section 7 matters because migrations get interrupted. A plan only safe when completed in one sitting is not a plan.
More Coding prompts
All Coding →- Coding
Refactor With a Safety Net
Plans a refactor as a sequence of individually safe, individually shippable steps, with the characterisation tests that make each one verifiable.
ClaudeChatGPT000Open → - Coding
Review for the Bug, Not the Style
A code review that hunts correctness failures and states the exact input that breaks each one, instead of listing naming preferences.
ClaudeChatGPTGemini000Open → - Coding
API Design Review
Reviews an API for the mistakes that cannot be fixed later — naming, error semantics and anything that becomes a breaking change.
ClaudeChatGPTGemini000Open →
Written for The AI University. Every prompt in this library is original work — authored, tested and revised here, not collected from elsewhere. 365 of them, free with an account.