dora-migration-safety

To prevent data loss during database migration, schema changes are classified into safe, review-required, and destructive categories. Destructive operations are explicitly flagged and gated against accidental execution before the executable SQL text is generated.

Generating a safe migration script from a schema diff involves classifying changes and assembling structured SQL sections. The process outputs executable SQL text with clear banners for destructive operations and commented-out sections requiring manual review.

Yes, this migration safety approach supports both Prisma and Drizzle schemas. It operates directly on the schema diff to classify changes and manage down-script generation regardless of the specific ORM framework used.

The best way to separate safe additive changes from destructive drops is through SQL emission and sectioning. This approach generates structured migration SQL with clear banners for destructive operations, allowing you to review and opt-in to risky changes.

Destructive database schema changes are gated for manual review using preview gating mechanisms. The generated SQL places these operations in commented-out sections with clear banners, ensuring risky drops require explicit opt-in before reaching the console.

You should not rely solely on automated SQL emission when a schema diff contains ambiguous lossy operations requiring manual intervention. In these cases, the generated down-script and destructive sections need human review before any execution proceeds.