Migration Architect
Generate zero-downtime migration plans, compatibility checks, and rollback runbooks when moving databases or services without taking the product offline.
Overview
Migration Architect is an agent skill most often used in Operate (also Ship launch, Build backend) that plans zero-downtime migrations with automated compatibility checks and rollback procedures.
Install
npx skills add https://github.com/alirezarezvani/claude-skills --skill migration-architectWhat is this skill?
- Three core scripts: `migration_planner.py`, `compatibility_checker.py`, `rollback_generator.py`
- Reference catalogs for migration patterns, zero-downtime techniques, and data reconciliation strategies
- Sample JSON specs for database and service migrations plus before/after schema fixtures
- Tiered as POWERFUL engineering migration strategy with automated plan and rollback procedure generation
- Emphasizes compatibility validation before cutover and explicit rollback paths
- 3 core scripts: migration_planner, compatibility_checker, rollback_generator
Adoption & trust: 534 installs on skills.sh; 17.5k GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You must migrate a live database or service but lack a staged plan, compatibility proof, or tested rollback—and cannot afford hours of user-facing outage.
Who is it for?
Technical founders maintaining production SaaS or APIs who face schema upgrades, replatforming, or strangling a monolith and need agent-assisted runbooks rather than improvised weekend deploys.
Skip if: Greenfield schema sketching with no users, trivial local-only SQLite resets, or organizations that already own a full enterprise migration program and tooling chain.
When should I use this skill?
Planning or executing a production database or service migration that requires compatibility validation, zero-downtime technique selection, and explicit rollback documentation.
What do I get? / Deliverables
You produce a migration plan from the bundled scripts, documented compatibility findings, and generated rollback steps so cutover and reconciliation can run with defined validation gates.
- Generated migration plan artifact
- Compatibility analysis report
- Rollback procedure document
Recommended Skills
Journey fit
Spans multiple journey phases - primary shelf plus alternate fits below.
Large cutovers and reconciliation are Operate concerns once you run real traffic, even though planning often starts earlier before launch. Infra is the canonical shelf because the skill packages planner scripts, compatibility analysis, and rollback generation for production migration execution—not day-one UI coding.
Where it fits
Draft a forward-compatible API and schema delta knowing a blue-green database migration is scheduled next quarter.
Rehearse cutover checklists and rollback_generator output before a major version launch window.
Run compatibility_checker against before/after JSON schemas, then execute migration_planner steps with reconciliation monitoring post-cutover.
How it compares
A migration planning and rollback workflow package—not a single-purpose SQL linter or a cloud vendor one-click upgrade button.
Common Questions / FAQ
Who is migration-architect for?
Engineering-minded solo builders and small teams responsible for production cutovers—database upgrades, service moves, or infra replatforms—who want scripted plans and rollback docs.
When should I use migration-architect?
During Operate infra when scheduling a live migration; during Ship launch prep when rehearsing cutover; and during Build backend when a schema or API change must be forward-compatible with an upcoming move.
Is migration-architect safe to install?
It includes powerful planning scripts that should run against staging specs first—never blind production execution. Review the Security Audits panel on this Prism page and restrict shell access until you trust the repo scripts.
SKILL.md
READMESKILL.md - Migration Architect
# Migration Architect **Tier:** POWERFUL **Category:** Engineering - Migration Strategy **Purpose:** Zero-downtime migration planning, compatibility validation, and rollback strategy generation ## Overview The Migration Architect skill provides comprehensive tools and methodologies for planning, executing, and validating complex system migrations with minimal business impact. This skill combines proven migration patterns with automated planning tools to ensure successful transitions between systems, databases, and infrastructure. ## Components ### Core Scripts 1. **migration_planner.py** - Automated migration plan generation 2. **compatibility_checker.py** - Schema and API compatibility analysis 3. **rollback_generator.py** - Comprehensive rollback procedure generation ### Reference Documentation - **migration_patterns_catalog.md** - Detailed catalog of proven migration patterns - **zero_downtime_techniques.md** - Comprehensive zero-downtime migration techniques - **data_reconciliation_strategies.md** - Advanced data consistency and reconciliation strategies ### Sample Assets - **sample_database_migration.json** - Example database migration specification - **sample_service_migration.json** - Example service migration specification - **database_schema_before.json** - Sample "before" database schema - **database_schema_after.json** - Sample "after" database schema ## Quick Start ### 1. Generate a Migration Plan ```bash python3 scripts/migration_planner.py \ --input assets/sample_database_migration.json \ --output migration_plan.json \ --format both ``` **Input:** Migration specification with source, target, constraints, and requirements **Output:** Detailed phased migration plan with risk assessment, timeline, and validation gates ### 2. Check Compatibility ```bash python3 scripts/compatibility_checker.py \ --before assets/database_schema_before.json \ --after assets/database_schema_after.json \ --type database \ --output compatibility_report.json \ --format both ``` **Input:** Before and after schema definitions **Output:** Compatibility report with breaking changes, migration scripts, and recommendations ### 3. Generate Rollback Procedures ```bash python3 scripts/rollback_generator.py \ --input migration_plan.json \ --output rollback_runbook.json \ --format both ``` **Input:** Migration plan from step 1 **Output:** Comprehensive rollback runbook with procedures, triggers, and communication templates ## Script Details ### Migration Planner (`migration_planner.py`) Generates comprehensive migration plans with: - **Phased approach** with dependencies and validation gates - **Risk assessment** with mitigation strategies - **Timeline estimation** based on complexity and constraints - **Rollback triggers** and success criteria - **Stakeholder communication** templates **Usage:** ```bash python3 scripts/migration_planner.py [OPTIONS] Options: --input, -i Input migration specification file (JSON) [required] --output, -o Output file for migration plan (JSON) --format, -f Output format: json, text, both (default: both) --validate Validate migration specification only ``` **Input Format:** ```json { "type": "database|service|infrastructure", "pattern": "schema_change|strangler_fig|blue_green", "source": "Source system description", "target": "Target system description", "constraints": { "max_downtime_minutes": 30, "data_volume_gb": 2500, "dependencies": ["service1", "service2"], "compliance_requirements": ["GDPR", "SOX"] } } ``` ### Compatibility Checker (`compatibility_checker.py`) Analyzes compatibility between schema versions: - **Breaking change detection** (removed fields, type changes, constraint additions) - **Data migration requirements** identification - **Suggested migration scripts** generation - **Risk assessment** for each change **Usage:** ```bash python3 scripts/compatibility_checker.py [OPTIONS] Options: --bef