skills.rest
4lerman
4lermanCOMMUNITY
Explore all skills by this author →
GitHub

migration-architect

Plan, execute, and validate system migrations with Python scripts and schema analysis.

Updated Apr 2, 2026
Search Tags:#zero-downtime#migration planning#rollback strategy#system migration#compatibility analysis
One-click install
npx skills add https://github.com/4lerman/text_evaluator --skill migration-architect-4lerman
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migration-architect
Source: https://github.com/4lerman/text_evaluator/tree/main/.agents/skills/engineering-advanced-skills/migration-architect
Command: npx skills add https://github.com/4lerman/text_evaluator --skill migration-architect-4lerman

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymysql, psycopg2, sqlalchemy, requests, jsonschema, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

The Migration Architect Skill solves the complex and resource-intensive challenge of system migrations, providing automated planning, compatibility validation, and rollback strategy generation.

Core Features & Use Cases

  • Zero-Downtime Migration Planning: Develop comprehensive migration plans with phased approaches, risk assessments, and timelines.
  • Compatibility Analysis: Perform in-depth analysis of schema and API changes, identifying potential breaking points and providing migration scripts.
  • Rollback Strategy Generation: Create automated rollback plans with data recovery scripts and service rollback procedures.
  • Use Case: A company preparing for a migration from a legacy CRM to a new SaaS solution can use this Skill to plan, execute, and validate the migration, ensuring minimal business impact and smooth transition.

Quick Start

Generate a migration plan for the CRM migration using the migration-planner script: python3 scripts/migration_planner.py --input assets/sample_crm_migration.json --output migration_plan.json

Frequently Asked Questions about migration-architect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I plan a zero-downtime database migration?▼

Zero-downtime database migration requires a phased approach with automated planning scripts to assess risks, validate schema compatibility, and generate timelines. This Skill automates that planning process using Python and SQLAlchemy to ensure minimal business impact during execution.

What is a rollback strategy in system migration?▼

A rollback strategy in system migration is an automated plan for reverting services and recovering data if a migration fails. This Skill generates rollback procedures and data recovery scripts to safely restore the original infrastructure state when breaking changes occur.

How do I analyze schema compatibility before migrating a database?▼

To analyze schema compatibility before a database migration, you run automated checks using schema analysis tools to identify breaking points and API conflicts. This Skill performs in-depth compatibility analysis and generates the necessary migration scripts to resolve detected issues.

Can I use Python and SQLAlchemy for migrating legacy systems to SaaS?▼

Yes, you can use Python and SQLAlchemy to migrate legacy systems to SaaS by automating compatibility checks and generating phased migration plans. This Skill supports database and infrastructure migrations using pymysql and psycopg2 connections for comprehensive validation.

What are the limitations of automated migration planning?▼

Automated migration planning limitations include dependency on accurate input schemas and the inability to predict undocumented custom business logic. This Skill requires predefined JSON migration configurations and schema analysis tools to generate valid execution plans and rollback procedures.

Why do I need a compatibility analysis for API and schema changes?▼

You need compatibility analysis for API and schema changes to identify potential breaking points before execution. This Skill uses jsonschema validation to detect conflicts during system migration, ensuring service continuity and preventing data corruption across infrastructure components.

Related Skills

Explore More Software Engineering Skills→
s710082105s710082105
1

fr-db

Detect database schemas and generate FineReport-ready SQL queries and XML fragments.

Community
Advanced
pfangueiropfangueiro
6

deployment-runbook

Standardize production deployment runbooks with health checks and rollback strategies.

Community
Intermediate
alex-voloshin-devalex-voloshin-dev
2

deploy-production

Orchestrate production deployments with approval gates and automated rollbacks.

Community
Advanced
christopherlouetchristopherlouet
5

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

Community
Advanced