skills.rest
xbpk3t
xbpk3tCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

data-migrations-reviewer

Identify migration and schema change risks in code diffs.

Updated Aug 23, 2026
Search Tags:#code review#deployment#database#migrations#schema#data-integrity#backfill
One-click install
npx skills add https://github.com/xbpk3t/ce-codex --skill data-migrations-reviewer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-migrations-reviewer
Source: https://github.com/xbpk3t/ce-codex/tree/main/skills/data-migrations-reviewer
Command: npx skills add https://github.com/xbpk3t/ce-codex --skill data-migrations-reviewer

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about data-migrations-reviewer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I review database migrations for data loss risks in pull requests?▼

Review database migrations for data loss by analyzing DDL statements and backfill scripts in code diffs to detect destructive column drops, precision-losing type changes, and missing rollback plans. This migration review process flags irreversible changes before deployment.

What is a schema migration code review and when do I need it?▼

A schema migration code review identifies unsafe data transforms, missing backfills, and transactional gaps in migration scripts. You need migration review when deploying schema changes where old and new code coexist to prevent runtime errors and inconsistent state.

How to detect missing backfills for non-nullable columns during deployment planning?▼

Detect missing backfills by checking migration scripts for new non-nullable columns without existing-data handling. Code review of migration DDL flags nullable assumptions and missing backfill scripts to prevent deployment-time data integrity failures.

How do I prevent deployment incompatibilities from renamed or removed database columns?▼

Prevent deployment incompatibilities by reviewing migration diffs to find renamed or removed columns still referenced by old code paths. Migration review also surfaces dual-write omissions, missing transaction boundaries, and unsafe index operations on hot tables.

Can code review catch swapped or inverted ID and enum mappings in data transforms?▼

Code review can catch swapped or inverted ID and enum mappings by verifying hardcoded mapping tables and conditional branches in data transform scripts against expected production mappings. Migration review flags these unsafe transforms when DDL and migration scripts are visible.

What are the limitations of reviewing schema changes without visible migration scripts?▼

Without visible migration scripts or DDL statements, migration review confidence drops from high to low. Schema change analysis requires visibility of migration files to accurately flag unsafe transforms, missing backfills, and transactional gaps during code review.

Related Skills

Explore More Software Engineering Skills→
ybbms777ybbms777
1

data-migrations-reviewer

Detect critical bugs and safety risks in database migration scripts.

Community
Advanced
Sir-chawakornSir-chawakorn
9

db-migration-safety

Evaluates database migration scripts for lock risks and destructive SQL operations.

Community
Advanced
oxieoxie

staging-deployment-phase

Automate staging deployment with auto-merge for merged pull requests.

Community
Intermediate
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced