data-migrations-reviewer

What problem does it solve?

Detect risky schema changes and data transformation issues that can cause runtime errors, data loss, or inconsistent state during deployment windows where old and new code coexist.

Core Features & Use Cases

• Detect swapped or inverted ID/enum mappings by verifying hardcoded mapping tables and conditional branches against expected production mappings.
• Flag irreversible or destructive migrations such as column drops, precision-losing type changes, and data-deleting backfills that lack rollback plans.
• Identify missing backfills and nullable assumptions by checking for new non-nullable columns without existing-data handling.
• Surface deployment-time incompatibilities including renamed or removed columns still referenced by old code paths, dual-write omissions, missing transaction boundaries, and unsafe index operations on hot tables.
• Confidence calibration and triage guidance to mark findings as high, moderate, or low confidence depending on whether DDL and migration scripts are visible.

Quick Start

Run a focused code review asking the data migrations reviewer to analyze the diff for migration files, schema changes, data transforms, and backfill scripts to list concrete risks and required fixes.