Migrations
Catch Breaking Schema Changes Before They Hit Production
Catch breaking schema changes before production.
Analyze DDL and schema changes for data loss, compatibility, and downstream risk.
The problem it solves
Schema changes can look harmless while still breaking consumers: dropped columns, type narrowing, nullability changes, renamed fields, missing defaults, or removed constraints.
What it does
Compares old and new schema definitions.
Flags breaking changes and data loss risks.
Highlights type narrowing, dropped columns, and compatibility issues.
Supports safer production migration review.
When to use it
BEFORE
applying DDL migrations
BEFORE
merging schema YAML or dbt contract changes
DURING
warehouse migrations
WHEN
reviewing pull requests that alter table shape
How it works
The skill compares the two schemas, runs migration analysis, and flags each risk with severity and why it matters.