data-migration-expert

Included with Lifetime

$97 forever

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 to validate the ID mappings and migration safety" <commentary>Since the PR involves ID mappings and data migration, use the data-migration-expert to verify the mappings match production and check for swapped values.</commentary></example> <example>Context: The user has a migration that transforms enum values. user: "This migration converts status integers to string enums" assistant: "Let me have the data-migration-ex...

AI Agents

What this skill does


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

- [ ] For each CASE/IF mapping, confirm the source data covers every branch (no silent NULL).
- [ ] If constants are hard-coded (e.g., `LEGACY_ID_MAP`), compare against production query output.
- [ ] Watch for "copy/paste" mappings that silently swap IDs or reuse wrong constants.
- [ ] If data depends on time windows, ensure timestamps and time zones align with production.

### 4. Check Observability & Detection

- [ ] What metrics/logs/SQL will run immediately after deploy? Include sample queries.
- [ ] Are there alarms or dashboards watching impacted entities (counts, nulls, duplicates)?
- [ ] Can we dry-run the migration in staging with anonymized prod data?

### 5. Validate Rollback & Guardrails

- [ ] Is the code path behind a feature flag or environment variable?
- [ ] If we need to revert, how do we restore the data? Is there a snapshot/backfill procedure?
- [ ] Are manual scripts written as idempotent rake tasks with SELECT verification?

### 6. Structural Refactors & Code Search

- [ ] Search for every reference to removed columns/tables/associations
- [ ] Check background jobs, admin pages, rake tasks, and views for deleted associations
- [ ] Do any serializers, APIs, or analytics jobs expect old columns?
- [ ] Document the exact search commands run so future reviewers can repeat them

## Quick Reference SQL Snippets

```sql
-- Check legacy value → new value mapping
SELECT legacy_column, new_column, COUNT(*)
FROM <table_name>
GROUP BY legacy_column, new_column
ORDER BY legacy_column;

-- Verify dual-write after deploy
SELECT COUNT(*)
FROM <table_name>
WHERE new_column IS NULL
  AND created_at > NOW() - INTERVAL '1 hour';

-- Spot swapped mappings
SELECT DISTINCT legacy_column
FROM <table_name>
WHERE new_column = '<expected_value>';
```

## Common Bugs to Catch

1. **Swapped IDs** - `1 => TypeA, 2 => TypeB` in code but `1 => TypeB, 2 => TypeA` in production
2. **Missing error handling** - `.fetch(id)` crashes on unexpected values instead of fallback
3. **Orphaned eager loads** - `includes(:deleted_association)` causes runtime errors
4. **Incomplete dual-write** - New records only write new column, breaking rollback

## Output Format

For each issue found, cite:
- **File:Line** - Exact location
- **Issue** - What's wrong
- **Blast Radius** - How many records/users affected
- **Fix** - Specific code change needed

Refuse approval until there is a written verification + rollback plan.

Files: 1

Size: 4.9 KB

Complexity: 15/100

Category: AI Agents

Source: https://github.com/ratacat/claude-skills/tree/main/skills/data-migration-expert

Related in AI Agents

skill-development

Included

Comprehensive meta-skill for creating, managing, validating, auditing, and distributing Claude Code skills and slash commands (unified in v2.1.3+). Provides skill templates, creation workflows, validation patterns, audit checklists, naming conventions, YAML frontmatter guidance, progressive disclosure examples, and best practices lookup. Use when creating new skills, validating existing skills, auditing skill quality, understanding skill architecture, needing skill templates, learning about YAML frontmatter requirements, progressive disclosure patterns, tool restrictions (allowed-tools), skill composition, skill naming conventions, troubleshooting skill activation issues, creating custom slash commands, configuring command frontmatter, using command arguments ($ARGUMENTS, $1, $2), bash execution in commands, file references in commands, command namespacing, plugin commands, MCP slash commands, Skill tool configuration, or deciding between skills vs slash commands. Delegates to docs-management skill for official documentation.

AI Agentsscripts

reprompter

Included

Transform messy prompts into well-structured, effective prompts — single or multi-agent. Use when: "reprompt", "reprompt this", "clean up this prompt", "structure my prompt", rough text needing XML tags and best practices, "reprompter teams", "repromptception", "run with quality", "smart run", "smart agents", multi-agent tasks, audits, parallel work, anything going to agent teams. Don't use when: simple Q&A, pure chat, immediate execution-only tasks. See "Don't Use When" section for details. Outputs: Structured XML/Markdown prompt, quality score (before/after), optional team brief + per-agent sub-prompts, agent team output files. Success criteria: Single mode quality score ≥ 7/10; Repromptception per-agent prompt quality score 8+/10; all required sections present, actionable and specific.

AI Agentsscripts

adaptive-compaction

Included

Adaptive add-on policy and recovery layer that decides WHEN to compact, prune, snapshot, or fork -- replacing fixed-percent auto-compaction across Claude Code, Codex, and MCP-capable hosts. Trigger on auto-compact timing or damage: "when should I compact", "is it safe to compact now or start a fresh session", "auto-compact fires too early/mid-task", "switching to an unrelated task but the window still has space", "context rot", "answers get worse the longer the session runs", "the agent forgot the plan or my decisions after it summarized", "add a layer on top that manages context without changing the agent", raising autoCompactWindow to give the policy room, or installing/tuning a cross-tool compaction policy or PreCompact hook -- even when "compaction" is never said but the problem is context-window pressure or post-summarization memory loss. Do NOT use to summarize a conversation, build RAG, write a summarization prompt (decides WHEN not HOW), or answer max-context-length trivia.

AI Agentsscripts

agent-skill-creator

Included

Create cross-platform agent skills from workflow descriptions. Activates when users ask to create an agent, automate a repetitive workflow, create a custom skill, or need advanced agent creation. Triggers on phrases like create agent for, automate workflow, create skill for, every day I have to, daily I need to, turn process into agent, need to automate, create a cross-platform skill, validate this skill, export this skill, migrate this skill. Supports single skills, multi-agent suites, transcript processing, template-based creation, interactive configuration, cross-platform export, and spec validation.

AI Agentsscripts

llm-wiki

Included

Use when building or maintaining a persistent personal knowledge base (second brain) in Obsidian where an LLM incrementally ingests sources, updates entity/concept pages, maintains cross-references, and keeps a synthesis current. Triggers include "second brain", "Obsidian wiki", "personal knowledge management", "ingest this paper/article/book", "build a research wiki", "compound knowledge", "Memex", or whenever the user wants knowledge to accumulate across sessions instead of being re-derived by RAG on every query.

AI Agentsscripts

skill-master

Included

Agent Skills authoring, evaluation, and optimization. Create, edit, validate, benchmark, and improve skills following the agentskills.io specification. Use when designing SKILL.md files, structuring skill folders (references, scripts, assets), ingesting external documentation into skills, running trigger evals, benchmarking skill quality, optimizing descriptions, or performing blind A/B comparisons. Keywords: agentskills.io, SKILL.md, skill authoring, eval, benchmark, trigger optimization.

AI Agentsscripts