skills.rest
CristoVentures
CristoVenturesOFFICIAL
Explore all skills by this author →
GitHub

data-migration-expert

Validate database migrations with rollback plans and SQL verification queries.

2|Updated Apr 14, 2026
Search Tags:#rollback#migrations#validation#sql#data-integrity#data-migration
One-click install
npx skills add https://github.com/CristoVentures/LocalCents --skill data-migration-expert-cristoventures
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-migration-expert
Source: https://github.com/CristoVentures/LocalCents/tree/main/.agent/skills/data-migration-expert
Command: npx skills add https://github.com/CristoVentures/LocalCents --skill data-migration-expert-cristoventures

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps teams validate and secure database migrations by ensuring mappings, transformations, and backfits align with production data, preventing data corruption and rollback risks.

Core Features & Use Cases

  • Data mapping validation: Verifies ID mappings and enums against production data to avoid swapped values.
  • Migration safety & rollback: Checks for safe up/down paths, dual-write, and fallback plans.
  • Concrete verification plans: Produces SQL queries and test steps to prove correctness post-deploy.

Quick Start

Validate migrations against a PR by running the verification workflow to confirm mappings and rollback safety.

Frequently Asked Questions about data-migration-expert

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

FAQPage Schema
How do I validate data mappings and enums during a database migration?▼

To validate data mappings during a database migration, verify ID mappings and enums against production data to prevent swapped values and ensure schema changes align with current records.

What is the best way to ensure safe rollback readiness for SQL schema changes?▼

Safe rollback readiness for SQL schema changes requires explicit up and down migration paths, dual-write strategies, and durable fallback plans to prevent data corruption during deployment.

How do I verify data integrity after a production database backfill?▼

Verify data integrity after a production database backfill by running concrete SQL queries and explicit test steps that prove transformation correctness across all touched tables.

Can I use migration validation checks on pull requests with schema changes?▼

Yes, you can run migration validation checks directly on pull requests to review schema changes, verify production-aligned mappings, and confirm safe transformation logic before merging.

When do I need a dedicated rollback plan for data migrations?▼

You need a dedicated rollback plan for data migrations whenever executing schema changes or data backfills to ensure fallback capabilities and protect production data from transformation failures.

What should I check to prevent data corruption during database migrations?▼

To prevent data corruption during database migrations, check that transformation logic is safe, mappings align with production data, and explicit verification steps validate correctness post-deploy.

Related Skills

Explore More Software Engineering Skills→
j-cogburnj-cogburn

migration-safety

Detect dangerous database migration patterns and generate rollback plans.

Community
Advanced
jovermierjovermier
1

deployment-verification-agent

Generate Go/No-Go deployment checklists with SQL verification queries and rollback procedures.

Community
Intermediate
nakafaainakafaai
78

convex-migrations

Evolve Convex database schemas with zero-downtime migration patterns.

Official
Advanced
wesleyosantos91wesleyosantos91
6

database-migration

Create and review reversible database migration scripts with rollback logic.

Community
Intermediate