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

59 stars 10 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add ratacat/claude-skills --skill data-migration-expert
Manual install
git 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-expert

Personal 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
Read the full skill on GitHub

Details

Skill name
data-migration-expert
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

59

ratacat/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 & Plugin Authoring10

Skill Installer

59

ratacat/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).

Software Development10

Agent Browser

59

ratacat/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".

AI, LLMs & Agents10

Design Iterator

59

ratacat/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

AI, LLMs & Agents10

Data Integrity Guardian

59

ratacat/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

AI, LLMs & Agents10

Iterative Retrieval

32

joneqian/claude-skills-suite

Pattern for progressively refining context retrieval to solve the subagent context problem

AI, LLMs & Agents

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.