schema-comparator

# Schema Comparator Skill Compares database schemas between source and target environments to identify differences and generate migration scripts. ## Purpose Enable database migration planning for: - Schema diff generation - Data type mapping - Constraint comparison - Index analysis - Migration script generation ## Capabilities ### 1. Schema Diff Generation - Compare table structures - Identify column differences - Detect missing objects - Generate change reports ### 2. Data Type Mapping - Map types across databases - Handle type conversions - Identify precision changes - Document compatibility ### 3. Constraint Comparison - Compare primary keys - Analyze foreign keys - Check unique constraints - Verify check constraints ### 4. Index Analysis - Compare index definitions - Identify missing indexes - Analyze index usage - Recommend optimizations ### 5. Stored Procedure Comparison - Compare procedure signatures - Identify logic differences - Detect parameter changes - Flag deprecated procedures ### 6. Migration Script Generation - Generate DDL scripts - Create rollback scripts - Handle dependencies - Order changes correctly ## Tool Integrations | Tool | Databases | Integration Method | |------|-----------|-------------------| | Flyway | Multi | CLI | | Liquibase | Multi | CLI | | Redgate SQL Compare | SQL Server | CLI | | SchemaHero | Kubernetes | CLI | | pgdiff | PostgreSQL | CLI | | mysqldiff | MySQL | CLI | ## Output Schema ```json { "comparisonId": "string", ...