Afrexai Data Migration

# Data Migration Planner

Plan, execute, and validate data migrations between systems. Covers schema mapping, ETL pipeline design, rollback strategies, and post-migration validation.

## What It Does

Given source and target system details, this skill:
1. Maps source → target schemas with field-level transformation rules
2. Generates an ETL pipeline plan with staging, transform, and load phases
3. Creates validation queries (row counts, checksum, referential integrity)
4. Builds a rollback plan with point-of-no-return criteria
5. Produces a migration runbook with go/no-go gates

## Usage

Tell your agent:
- "Plan a migration from Salesforce to HubSpot CRM"
- "Create a data migration runbook for moving from MySQL to PostgreSQL"
- "Map our legacy ERP data to the new system schema"

## Migration Framework

### Phase 1: Discovery
- Inventory all source tables/objects and record counts
- Document data types, constraints, and relationships
- Identify data quality issues (nulls, duplicates, orphans)
- Map business rules that affect data interpretation

### Phase 2: Schema Mapping
For each source entity, document:
| Source Field | Type | Target Field | Type | Transform | Notes |
|---|---|---|---|---|---|
| (field) | (type) | (field) | (type) | (rule) | (edge cases) |

### Phase 3: ETL Pipeline
```
Extract → Stage (raw) → Clean → Transform → Validate → Load → Verify
```
- **Extract**: Full vs incremental, API vs direct DB, rate limits
- **Stage**: Raw landing zone, no transforms, audit trail
- **Clean**: Dedup, null handling, encoding fixes
- **Transform**: Type conversions, lookups, calculated fields
- **Validate**: Pre-load checks (counts, checksums, business rules)
- **Load**: Batch size, parallelism, error handling
- **Verify**: Post-load reconciliation

### Phase 4: Validation
- Row count match (source vs target, per table)
- Checksum validation on key columns
- Referential integrity checks
- Business rule validation (e.g., all active accounts migrated)
- User acceptanc...

# Data Migration Planner

Plan, execute, and validate data migrations between any systems — CRM, ERP, databases, SaaS platforms.

**No more spreadsheet-driven migrations that miss half the edge cases.**

This skill gives your AI agent a complete migration framework:
- Schema mapping with field-level transform rules
- ETL pipeline design (extract → stage → clean → transform → validate → load → verify)
- Validation test suites (row counts, checksums, referential integrity)
- Cutover runbooks with rollback procedures
- Cost and timeline estimation

## Quick Start

Just tell your agent what you're migrating:
```
"Plan a data migration from Salesforce to HubSpot"
"Create a migration runbook for MySQL to PostgreSQL"
"Map our legacy system data to the new platform"
```

## Who This Is For

- Engineering teams planning system migrations
- CTOs evaluating migration complexity and cost
- Consultants scoping migration projects
- Ops teams executing database consolidations

## What You Get

| Phase | Output |
|---|---|
| Discovery | Source inventory, data quality report |
| Schema Mapping | Field-level mapping tables with transforms |
| ETL Pipeline | Full pipeline spec with error handling |
| Validation | Test suite with pass/fail criteria |
| Cutover | Go/no-go checklist, rollback plan, comms |

## More AI Business Tools

🔗 [AI Context Packs](https://afrexai-cto.github.io/context-packs/) — Industry-specific agent configurations ($47/pack)
🔗 [AI Revenue Calculator](https://afrexai-cto.github.io/ai-revenue-calculator/) — Find where AI saves you money
🔗 [Agent Setup Wizard](https://afrexai-cto.github.io/agent-setup/) — Configure your AI agent in minutes

**Built by [AfrexAI](https://afrexai-cto.github.io/context-packs/)** 🖤💛