Database Migration Strategy (Zero-Downtime, Large Tables)
For database engineers: apply Expand-Contract Pattern to migrate tables with millions of rows without locks or downtime, with rollback plan and verification checksums.
Pro
Model: claude-sonnet-4-7
3,204 previews
0 uses
Knowledge: 2026-Q2
This prompt requires the pro plan
Upgrade plan
Your current plan: free
Adding a column to a 50M-row users table; changing a price column type; creating a composite index on a production orders table
#قاعدة بيانات#هجرة#PostgreSQL#Zero-downtime#Migration
Built-in quality guards
Anti-hallucination
Never invent APIs, functions, or libraries
Format Check
Code runs as-is without modification
Code Completeness
No TODO comments or stubs
Security Check
OWASP Top 10 considered in code