Agent skill

Data Migration

by revfactory in revfactory/harness-100

Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning.

Apache-2.0Auto-check passedDatabases

Install Data Migration

skills CLI
$ npx skills add revfactory/harness-100 --skill data-migration -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install revfactory/harness-100 data-migration --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/revfactory/harness-100.git skills-src && mkdir -p .claude/skills && cp -r skills-src/en/34-data-migration/.claude/skills/data-migration .claude/skills/data-migration && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
data-migration
GitHub stars
1.3k
Token cost
~1.8k tokens
SKILL.md length
666 words
Files
1
Skills in repo
464
Repo updated
First seen
Licence
Apache-2.0

At a glance

Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning.

  • Works in 3 steps: Preparation (performed directly by the… → Team Assembly and Execution → Integration and Final Deliverables
  • Requests like data migration
  • SKILL.md covers Execution Mode, Agent Composition, Workflow and Execution Modes by Request Scope, plus 4 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Data Migration is an agent skill from revfactory/harness-100. Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning. Use this skill for requests like 'data migration', 'DB migration', 'data transfer', 'schema conversion', 'database migration plan', 'ETL scripts', 'data transition', 'DB migration validation', 'system cutover', etc. Note: real-time CDC streaming setup, cloud infrastructure provisioning, and application code migration are outside the…

Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Database migrations, Data pipelines and ETL and Code migrations. The licence is Apache-2.0.

When your agent uses it

  • Requests like data migration
  • Schema conversion
  • Database migration plan
  • Data transition

Example prompts

  • “data migration”
  • “DB migration”
  • “data transfer”
  • “/data-migration”

Requirements

  • Python 3

Workflow steps

3 steps, taken from the step headings in SKILL.md.

  1. Preparation (performed directly by the orchestrator)
  2. Team Assembly and Execution
  3. Integration and Final Deliverables

What it can do on your machine

Read from SKILL.md and the folder at commit 8e8d35c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Data Migration loads about 1.8k tokens when it runs. Until then it costs about 138 tokens; SKILL.md has 666 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~138
When it runs · the whole SKILL.md, loaded when a task matches
~1.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from revfactory/harness-100 at commit 8e8d35c, republished under its Apache-2.0 licence (© revfactory). 666 words, ~1,778 tokens.

Download SKILL.mdSave it as .claude/skills/data-migration/SKILL.md (or your agent's skills folder).
name
data-migration
description
Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning. Use this skill for requests like 'data migration', 'DB migration', 'data transfer', 'schema conversion', 'database migration plan', 'ETL scripts', 'data transition', 'DB migration validation', 'system cutover', etc. Note: real-time CDC streaming setup, cloud infrastructure provisioning, and application code migration are outside the scope of this skill.

Data Migration — Full Migration Pipeline

An agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation queries, and rollback planning.

Execution Mode

Agent Team — Five agents communicate directly via SendMessage and perform cross-validation.

Agent Composition

AgentFileRoleType
source-analyst.claude/agents/source-analyst.mdSource analysis, data profilinggeneral-purpose
schema-mapper.claude/agents/schema-mapper.mdSchema mapping, transformation rule designgeneral-purpose
script-developer.claude/agents/script-developer.mdETL scripts, performance optimizationgeneral-purpose
validation-engineer.claude/agents/validation-engineer.mdValidation queries, integrity testsgeneral-purpose
rollback-planner.claude/agents/rollback-planner.mdRollback planning, emergency responsegeneral-purpose

Workflow

Phase 1: Preparation (performed directly by the orchestrator)
  1. Extract the following from user input:
    • Source system: DBMS type, version, connection info, schema scope
    • Target system: DBMS type, version, existing schema availability
    • Migration scope: Full/partial, target tables, data time range
    • Constraints: Allowable downtime, performance requirements, schedule
  2. Create the _workspace/ directory and subdirectories
  3. Organize the input and save it to _workspace/00_input.md
  4. If pre-existing files are available, copy them to _workspace/ and skip the corresponding phase
  5. Determine the execution mode based on the scope of the request
Phase 2: Team Assembly and Execution
OrderTaskOwnerDependenciesDeliverable
1Source analysissource-analystNone01_source_analysis.md
2Schema mappingschema-mapperTask 102_schema_mapping.md
3aTransformation scriptsscript-developerTask 203_migration_scripts/
3bValidation suitevalidation-engineerTasks 1, 204_validation_suite.md
4Rollback planrollback-plannerTasks 1, 2, 3a, 3b05_rollback_plan.md

Tasks 3a (scripts) and 3b (validation) run in parallel.

Inter-agent communication flow:

  • source-analyst completes > passes source schema to schema-mapper, volume/order to script-developer, integrity rules to validation-engineer
  • schema-mapper completes > passes mapping spec to script-developer, transformation rules to validation-engineer, reverse mapping feasibility to rollback-planner
  • script-developer completes > passes transaction boundaries to rollback-planner
  • validation-engineer completes > passes rollback trigger conditions to rollback-planner
  • rollback-planner develops the overall plan and feeds back risk items to each agent
Phase 3: Integration and Final Deliverables
  1. Verify all deliverables in _workspace/
  2. Validate cross-deliverable consistency (mapping vs. scripts, validation vs. mapping, rollback vs. scripts)
  3. Present the final migration execution checklist to the user

Execution Modes by Request Scope

User Request PatternExecution ModeAgents Deployed
"Full migration plan"Full pipelineAll 5 agents
"Analyze the source DB only"Analysis modesource-analyst only
"Just do schema mapping"Mapping modesource-analyst + schema-mapper
"Generate ETL scripts only"Script modescript-developer (assumes mapping exists)
"Create validation queries only"Validation modevalidation-engineer (assumes mapping exists)
"Just create a rollback plan"Rollback moderollback-planner (assumes full analysis exists)

Reusing existing files: If the user provides existing DDL, ERD, or schema mapping documents, copy those files to the appropriate location in _workspace/ and skip the corresponding agent.

Show full SKILL.md (247 more words)Show less

Data Transfer Protocol

StrategyMethodPurpose
File-based_workspace/ directoryDeliverable documents
Script-based_workspace/03_migration_scripts/Executable code
Message-basedSendMessageKey information transfer, feedback

Error Handling

Error TypeStrategy
DB connection unavailableFall back to DDL/ERD document-based analysis
Target schema undecidedAuto-generate recommended target schema based on source
Incompatible typesPropose two-stage conversion via intermediate type
Very large tables (>100M rows)Partition-level migration strategy
Agent failureRetry once; if still failing, proceed without that deliverable

Test Scenarios

Normal Flow

Prompt: "Create a plan to migrate an e-commerce DB from MySQL 5.7 to PostgreSQL 16" Expected result:

  • Source analysis: MySQL schema reverse-engineering, data profiling, dependency graph
  • Schema mapping: MySQL to PostgreSQL type mapping, auto-increment to sequence conversion, character set handling
  • Scripts: Python ETL code, batch processing, index management SQL
  • Validation: Row count, checksum, FK integrity, transformation accuracy queries
  • Rollback: Backup strategy, Go/No-Go criteria, step-by-step rollback procedures
Existing File Reuse Flow

Prompt: "Map this DDL file to a PostgreSQL target only" Expected result:

  • source-analyst parses the DDL for schema analysis
  • schema-mapper generates the PostgreSQL target mapping
  • script-developer, validation-engineer, and rollback-planner are not deployed
Error Flow

Prompt: "Migrate from Oracle to MongoDB" (RDBMS to NoSQL) Expected result:

  • source-analyst analyzes the relational structure
  • schema-mapper proposes an RDBMS-to-document model conversion strategy (denormalization, embedding vs. references)
  • Many irreversible transformations arise > rollback-planner develops an archive preservation strategy

Agent Extension Skills

SkillPathEnhanced AgentRole
type-mapping-encyclopedia.claude/skills/type-mapping-encyclopedia/skill.mdschema-mapperMySQL/Oracle/PostgreSQL type mapping, RDBMS-to-NoSQL, character set conversion
data-validation-patterns.claude/skills/data-validation-patterns/skill.mdvalidation-engineer5-level validation (count > schema > value > referential > business), Go/No-Go checklist

© revfactory, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in en/34-data-migration/.claude/skills/data-migration of revfactory/harness-100.

Open the folder on GitHubat commit 8e8d35c

Compare with similar skills

Data Migration next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Data Migration compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Data Migration this skillrevfactory/harness-1001.3k—~1.8kAutomated safety check: PassApache-2.0
V5 MigrationOpenLitterMap/openlittermap-web134—~1.7kAutomated safety check: PassGPL-3.0
Code MigratorFerroxLabs/wayland608—~3.7kAutomated safety check: PassApache-2.0
Glue 09 10 Migrationaws-samples/aws-glue-samples1.5k—~2.4kAutomated safety check: PassMIT-0
Reversible MigrationJuliusBrussee/caveman110k1 repos~196Automated safety check: PassApache-2.0
Managed Airflow Migrationsgoogle/skills21k—~3kAutomated safety check: PassApache-2.0

Similar skills

  • V5 Migration

    OpenLitterMap/openlittermap-web

    The olm:v5 migration script, UpdateTagsService, batch processing, migratedat, ClassifyTagsService deprecated mappings, and data migration from v4 category tables.

    134 GitHub stars~1.7k tokensUpdated 22 days ago
    DatabasesAuto-check passed
  • Code Migrator

    FerroxLabs/wayland

    Code migration specialist covering planning frameworks, strangler fig pattern, compatibility layers, feature flags, database migrations, API versioning, rollback plans, and testing migration…

    608 GitHub stars~3.7k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Glue 09 10 Migration

    aws-samples/aws-glue-samples

    Official

    Upgrade an AWS Glue ETL job from Glue version 0.9 or 1.0 to Glue 4.0.

    1.5k GitHub stars~2.4k tokensUpdated 1 mo ago
    Data & AnalyticsAuto-check passed
  • Reversible Migration

    JuliusBrussee/caveman

    Implement reversible compatibility-safe transitions. Use for schema, data, API, protocol, configuration, or dependency migrations requiring rollback and…

    110k GitHub starsUsed in 1 repo~196 tokens
    DevelopmentAuto-check passed
  • Official

    Provides guidance for migrating Apache Airflow DAGs in Managed Service for Apache Airflow (MSAA; formerly Cloud Composer).

    21k GitHub stars~3k tokensUpdated today
    Data & AnalyticsAuto-check passed
  • Postgres

    magnus919/agent-skills

    Operate PostgreSQL instances safely: configuration review, index and query-plan analysis, vacuum and bloat management, WAL archiving and point-in-time recovery, replication and failover, extensions…

    111 GitHub stars~4k tokensUpdated today
    DatabasesAuto-check passed

More from revfactory/harness-100

All 464 skills in this repo
  • Anti Bot Analyzer

    revfactory/harness-100

    A skill for analyzing website anti-bot defense mechanisms and developing legitimate evasion strategies.

    1.3k GitHub stars~1.1k tokensUpdated 6 mo ago
    Auto-check passed
  • API Error Design Patterns

    revfactory/harness-100

    Reference for designing how an API reports failures: structured error codes, response shapes, client-friendly messages, an error catalog and retry or fallback advice.

    1.3k GitHub stars~1.6k tokensUpdated 6 mo ago
    Auto-check passed
  • API Security Checklist

    revfactory/harness-100

    Walks a backend-dev agent through OWASP API Top 10 checks, authentication and authorization patterns, and defense code during API design.

    1.3k GitHub stars~1.7k tokensUpdated 6 mo ago
    Auto-check passed
  • Arg Parser Generator

    revfactory/harness-100

    Methodology for systematically designing and generating CLI tool argument parser structures.

    1.3k GitHub stars~1.2k tokensUpdated 6 mo ago
    Auto-check passed
  • Audience Segmentation

    revfactory/harness-100

    Audience segmentation skill used by the analyst and curator agents.

    1.3k GitHub stars~1.3k tokensUpdated 6 mo ago
    Auto-check passed
  • Audio Storytelling

    revfactory/harness-100

    Audio storytelling skill used by the podcast scriptwriter and show note editor.

    1.3k GitHub stars~1.6k tokensUpdated 6 mo ago
    Auto-check passed

Questions about Data Migration

What does Data Migration do?

Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning. Data Migration is an agent skill from revfactory/harness-100. Full migration pipeline where an agent team collaborates to perform source analysis, schema mapping, transformation script generation, validation query design, and rollback planning.

When should I use Data Migration?

Data Migration fits situations like: requests like data migration; schema conversion; database migration plan; data transition.

How do I install Data Migration in Claude Code?

Run `npx skills add revfactory/harness-100 --skill data-migration -a claude-code`. Or copy the skill folder (en/34-data-migration/.claude/skills/data-migration in revfactory/harness-100) into .claude/skills/data-migration in your project. Claude Code loads it when a task matches its description.

How do I install Data Migration in Codex?

Run `npx skills add revfactory/harness-100 --skill data-migration -a codex`. Or copy the skill folder (en/34-data-migration/.claude/skills/data-migration in revfactory/harness-100) into .agents/skills/data-migration in your project. Codex loads it when a task matches its description.

Can I use Data Migration in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add revfactory/harness-100 --skill data-migration -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/data-migration, .gemini/skills/data-migration, .github/skills/data-migration and .opencode/skills/data-migration in your project.

What does Data Migration need to run?

SKILL.md names no scripts, command-line tools or credentials: Data Migration is instructions for the agent only. Our summary lists: Python 3.

Does Data Migration access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Data Migration safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Data Migration use?

Data Migration is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Data Migration use?

About 1.8k tokens (SKILL.md is roughly 7.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Data Migration?

Skills that share tags, products or a category with Data Migration: V5 Migration (OpenLitterMap/openlittermap-web, 134 stars), Code Migrator (FerroxLabs/wayland, 608 stars), Glue 09 10 Migration (aws-samples/aws-glue-samples, 1.5k stars) and Reversible Migration (JuliusBrussee/caveman, 110k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Data Migration?

revfactory (a GitHub user) maintains it in revfactory/harness-100, which has 1,290 GitHub stars. The repository holds 464 skills in this directory. The repository was last updated on March 22, 2026.

Source: revfactory/harness-100 on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.