Zero-Downtime Database Migration Plan

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.

Plus Model: claude-sonnet-4-7 3,106 previews 0 uses Knowledge: 2026-Q2
This prompt requires the plus plan

Your current plan: free

Upgrade plan
Use case

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

Anti-hallucination

No fabricated statements, options, or lock behavior unsupported by the specified engine

Security Check

Migrate personal data without unauthorized exposure, preserving access controls per PDPL

Completeness

Cover expand, backfill, switch, contract, and rollback without truncation

Format Check

Adherence to six-section structure, SQL statements, and phase table

← Back to library
Sign in to use