How does this skill prevent data corruption?

It enforces strict validation of mapping logic against production reality, ensuring developers do not rely on inaccurate test fixtures or assumed ID values.

Does it provide specific SQL tools?

The skill generates quick-reference SQL snippets for checking legacy-to-new mappings, verifying dual-writes, and spotting swapped values post-deploy.

What kind of pull requests should I use this for?

Use it for any PR involving ID mappings, column renames, enum conversions, schema changes, or background data transformations.

Can it help with large-scale data backfills?

Yes, it checks for proper batching, throttling, and transaction scoping to ensure migrations do not lock tables or overload production resources.

How does it handle rollback planning?

It mandates and validates specific rollback procedures, such as feature flags and dual-write strategies, ensuring data can be restored if a migration fails.

Data Migration Expert

Name: Data Migration Expert
Author: gvkhosla

bygvkhosla

•

Gestión de Bases de Datos

Validates database migrations and backfills to prevent data corruption by cross-referencing logic with production reality.

The Data Migration Expert skill is a specialized safeguard for production databases during structural changes, ID mappings, and enum conversions. It shifts the focus from simple code review to a production-first mindset, requiring developers to verify assumptions against live data patterns rather than static fixtures. By enforcing strict checklists for dual-write safety, batching, and rollback procedures, this skill ensures that complex schema evolutions and data transformations are executed without downtime or data loss, providing developers with the specific SQL snippets and observability strategies needed for high-stakes deployments.

Características Principales

0135 GitHub stars

02Validates ID mappings and enum conversions against production data patterns

03Audits migration scripts for batching, throttling, and transaction safety

04Enforces rollback safety through dual-write and feature flag validation

05Generates SQL snippets for post-deployment verification and observability

06Identifies orphaned associations and legacy references across the codebase

Casos de Uso

01Ensuring large-scale data backfills are performed in safe, throttled batches

02Validating high-risk enum transformations from integers to string values

03Reviewing PRs that involve renaming columns or migrating data between tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gvkhosla/compound-engineering-pi data-migration-expert

For use in Claude.ai and ChatGPT

Download Skill