Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Plans and documents detailed data migrations, including schema mapping, ETL pipeline design, validation tests, rollback strategies, and runbook creation.
Plans and documents detailed data migrations, including schema mapping, ETL pipeline design, validation tests, rollback strategies, and runbook creation.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run.
Plan, execute, and validate data migrations between systems. Covers schema mapping, ETL pipeline design, rollback strategies, and post-migration validation.
Given source and target system details, this skill: Maps source โ target schemas with field-level transformation rules Generates an ETL pipeline plan with staging, transform, and load phases Creates validation queries (row counts, checksum, referential integrity) Builds a rollback plan with point-of-no-return criteria Produces a migration runbook with go/no-go gates
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"
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
For each source entity, document: Source FieldTypeTarget FieldTypeTransformNotes(field)(type)(field)(type)(rule)(edge cases)
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
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 acceptance sampling (random 5% manual review)
Go/no-go criteria checklist Point-of-no-return definition Rollback procedure and time estimate Communication plan (users, stakeholders) Parallel run period (if applicable)
Data volume: >10M rows = batch strategy required Downtime window: Zero-downtime needs CDC/dual-write Data quality: Garbage in = garbage out. Clean BEFORE migrating Dependencies: Other systems reading from source during migration Compliance: GDPR/HIPAA data handling during transit
Deliver a migration runbook as structured markdown with: Executive summary (what, why, when, risk level) Schema mapping tables ETL pipeline specification Validation test suite Cutover runbook with rollback Timeline with milestones
Typical migration costs by complexity: Simple (1-5 tables, <1M rows): $5K-$15K or 1-2 weeks internal Medium (10-50 tables, 1-10M rows): $25K-$75K or 1-2 months Complex (50+ tables, 10M+ rows, multiple systems): $100K-$500K or 3-6 months Built by AfrexAI โ AI Context Packs for business automation. Calculate your AI automation ROI: Revenue Calculator
Long-tail utilities that do not fit the current primary taxonomy cleanly.
Largest current source with strong distribution and engagement signals.