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.

Put This Skill to Work. On Your Own dbt Project.

Install Altimate Code, connect your warehouse and call the skill from your terminal or your IDE. Book a demo to see it run on a project like yours.

Altimate Code: the skill browser in the terminal, a session recap and a dbt quality scan in VS Code