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",
  "timestamp": "ISO8601",
  "source": {
    "type": "string",
    "connection": "string"
  },
  "target": {
    "type": "string",
    "connection": "string"
  },
  "differences": {
    "tables": {
      "added": [],
      "removed": [],
      "modified": []
    },
    "columns": [],
    "constraints": [],
    "indexes": [],
    "procedures": []
  },
  "migration": {
    "scripts": [],
    "order": [],
    "rollback": []
  }
}

Integration with Migration Processes

• database-schema-migration: Primary comparison tool
• data-format-migration: Schema analysis

Related Skills

• data-migration-validator: Post-migration validation
• query-translator: SQL conversion

Related Agents

• database-migration-orchestrator: Uses for planning
• data-architect-agent: Schema design review