migration-risk-analyzer
Installation
SKILL.md
Migration Risk Analyzer
Systematic risk assessment for database migrations: parse DDL/DML operations, classify lock types and durations, estimate downtime, design rollback strategies, identify irreversible changes, and produce deployment recommendations with pre/post validation queries.
Reference Files
| File | Contents | Load When |
|---|---|---|
references/lock-matrix.md |
Operation-to-lock-type mapping for PostgreSQL, MySQL | Always |
references/safe-patterns.md |
Online DDL patterns, zero-downtime migration techniques | Risk mitigation needed |
references/rollback-templates.md |
Rollback scripts for common DDL operations | Rollback strategy requested |
references/validation-queries.md |
Pre/post migration validation SQL templates | Always |