Data Migration Expert
Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations. <example>Context: The user has a PR with database migrations that involve ID mappings. user: "Review this PR that migrates from action_id to action_module_name" assistant: "I'll use the data-migration-expert agent
Install
npx skills add ratacat/claude-skills --skill data-migration-expertgit clone --depth 1 https://github.com/ratacat/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/skills/data-migration-expert ~/.claude/skills/data-migration-expertPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
You are a Data Migration Expert. Your mission is to prevent data corruption by validating that migrations match production reality, not fixture or assumed values. ## Core Review Goals For every data migration or backfill, you must: 1. **Verify mappings match production data** - Never trust fixtures or assumptions 2. **Check for swapped or inverted values** - The most common and dangerous migration bug 3. **Ensure concrete verification plans exist** - SQL queries to prove correctness post-deploy 4. **Validate rollback safety** - Feature flags, dual-writes, staged deploys ## Reviewer Checklist ### 1. Understand the Real Data - [ ] What tables/rows does the migration touch? List them explicitly. - [ ] What are the **actual** values in production? Document the exact SQL to verify. - [ ] If mappings/IDs/enums are involved, paste the assumed mapping and the live mapping side-by-side. - [ ] Never trust fixtures - they often have different IDs than production. ### 2. Validate the Migration Code - [ ] Are `up` and `down` reversible or clearly documented as irreversible? - [ ] Does the migration run in chunks, batched transactions, or with throttling? - [ ] Are `UPDATE ... WHERE ...` clauses scoped narrowly? Could it affect unrelated rows? - [ ] Are we writing both new and legacy columns during transition (dual-write)? - [ ] Are there foreign keys or indexes that need updating? ### 3. Verify the Mapping / Transformation Logic
Details
- Skill name
data-migration-expert- Repository
- ratacat/claude-skills
- Path
skills/data-migration-expert/SKILL.md- Repo updated
- 11 February 2026
FAQ
What does the Data Migration Expert skill do?
Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations. <example>Context: The user has a PR with database migrations that involve ID mappings. user: "Review this PR that migrates from action_id to action_module_name" assistant: "I'll use the data-migration-expert agent
How do I install the Data Migration Expert skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add ratacat/claude-skills --skill data-migration-expert. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Data Migration Expert popular?
It lives in ratacat/claude-skills, which has 59 GitHub stars and 10 forks.
Related skills
Skill Creator
59ratacat/claude-skills
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations.
Skill Installer
59ratacat/claude-skills
Install Codex skills into $CODEX_HOME/skills from a curated list or a GitHub repo path. Use when a user asks to list installable skills, install a curated skill, or install a skill from another repo (including private repos).
Agent Browser
59ratacat/claude-skills
Browser automation using Vercel's agent-browser CLI. Use when you need to interact with web pages, fill forms, take screenshots, or scrape data. Alternative to Playwright MCP - uses Bash commands with ref-based element selection. Triggers on "browse website", "fill form", "click button", "take screenshot", "scrape page", "web automation".
Design Iterator
59ratacat/claude-skills
Use this agent PROACTIVELY when design work isn't coming together on the first attempt. If you've made 1-2 design changes and the result still feels off, suggest using this agent with 5x or 10x iterations for deeper refinement. This agent takes screenshots, analyzes what's not working, implements improvements, and repeats N times to systematically fix design issues. Perfect when colors feel wrong, layouts aren't balanced, or the overall aesthetic needs work that single changes can't achieve. <example>Context: User asks to change button color but result still looks off. user: "Change the button
Data Integrity Guardian
59ratacat/claude-skills
Use this agent when you need to review database migrations, data models, or any code that manipulates persistent data. This includes checking migration safety, validating data constraints, ensuring transaction boundaries are correct, and verifying that referential integrity and privacy requirements are maintained. <example>Context: The user has just written a database migration that adds a new column and updates existing records. user: "I've created a migration to add a status column to the orders table" assistant: "I'll use the data-integrity-guardian agent to review this migration for safety
Iterative Retrieval
32joneqian/claude-skills-suite
Pattern for progressively refining context retrieval to solve the subagent context problem
Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.