Database Schema and Migration Review
Check constraints, indexes and migration safety.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Review a database schema and a planned migration. Paste the schema excerpt and the migration script: [SCHEMA_MIGRATION]. Table sizes and traffic: [SIZE_TRAFFIC]. Downtime allowed: [DOWNTIME]. Check keys and constraints, data types, nullability, naming, indexes for the known queries, risky operations on large tables, locking behaviour, backfills, rollbacks and compatibility with the running application during deployment. Return a table with Item, Issue, Risk (red, amber, green) and Fix, a staged migration plan with checks between stages, and a rollback procedure. Also suggest how to rehearse the migration on a copy of production data, how to measure its duration, and which monitoring to watch during deployment. Add a decision point at which the team abandons the migration and restores service. Further, suggest the monitoring queries to run before, during and after the change, the communication to send to the support team, and a short list of the application versions that must be deployed first. Include the signs that the migration is causing harm.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.