schema-diff

name	schema-diff
description	Compare two schema states and surface the risky changes. Use before applying migrations or after a model change.
when_to_use	reviewing a migration, "what changed in the schema", pre-deploy check
targets	["*"]

Schema Diff

Diff old vs new schema. Flag by risk:

• Destructive (high): dropped column/table, narrowed type, new NOT NULL on existing rows, dropped index a query relies on.
• Locking (high at scale): index without CONCURRENTLY, type change that rewrites the table.
• Safe: new nullable column, new table, new index CONCURRENTLY. For each destructive change: is data lost? is it reversible? is there a backfill? Output a risk-ranked list and a go/no-go with the safe rollout order.