migration-architect

What This Skill Does

The Migration Architect is a sophisticated AI agent skill designed for engineering teams tackling high-stakes infrastructure transitions. It bridges the gap between high-level architectural planning and low-level tactical execution. By leveraging proven patterns such as the Expand-Contract model, Parallel Schema deployment, and Event Sourcing, the skill minimizes operational downtime. It functions as a specialized consultant that audits database schemas, detects breaking API changes, and generates exhaustive, automated rollback procedures to ensure business continuity during complex system overhauls.

Installation

You can integrate this skill into your environment by running the following command in your terminal within the OpenClaw environment: clawhub install openclaw/skills/skills/alirezarezvani/migration-architect Ensure your local instance has the necessary permissions to read existing configuration files and database schemas to allow for accurate compatibility analysis.

Use Cases

• Database Refactoring: Safely transitioning from a legacy monolithic database to a distributed microservices architecture using the Expand-Contract pattern.
• API Versioning: Analyzing legacy REST endpoints against new GraphQL interfaces to identify breaking changes and generate mapping logic.
• Cloud Migration: Planning the incremental data migration of large datasets from on-premise servers to cloud-native storage solutions with built-in sync verification.
• Disaster Recovery Planning: Generating automated rollback scripts and validation triggers for a critical service deployment.

Example Prompts

1. "Analyze our current SQL schema and provide a multi-phase migration plan to transition the users table to a partitioned structure using the Expand-Contract pattern."
2. "Identify potential breaking changes between v1 and v2 of our user profile API and generate a data transformation map for our integration layer."
3. "Create a detailed rollback plan for our upcoming database migration, including SQL restoration scripts and traffic routing commands for our load balancer."

Tips & Limitations

• Tips: Always provide the raw schema or OpenAPI definition files to the agent to improve the accuracy of the compatibility analysis. Define your "Point of No Return" during the strategy phase to allow the skill to generate more precise trigger conditions for rollbacks.
• Limitations: The Migration Architect is a planning and generation tool. It requires human oversight to execute destructive database operations. Always test the generated rollback scripts in a staging or development environment before running them against production data. It cannot automatically reconfigure your cloud provider settings without valid infrastructure-as-code (IaC) access.