Database Migrator

Move schemas, data, and logic between database providers. This is a cross-provider migration engine, not a schema designer: it handles data type incompatibilities, provider-specific SQL dialects, foreign key ordering, sequence and auto-increment translation, trigger rewrites, and stored procedure conversion. It validates with row counts and checksums and produces an auditable migration-plan.md.

Contents

• references/schema-discovery.md -- Extraction queries for relational, MongoDB, Supabase, and PlanetScale sources.
• references/type-mapping.md -- Data type maps (PG/MySQL/Mongo) and SQL function translation.
• references/script-generation.md -- DDL, sequence, trigger, procedure, and view translation.
• references/data-migration.md -- Export, transform, and import commands per provider.
• references/validation.md -- Row count, checksum, FK integrity, index, and spot-check queries.
• references/rollback-and-downtime.md -- Rollback scripts, backup/restore, downtime estimation.
• references/migration-plan-template.md -- Full migration-plan.md output template.
• references/edge-cases.md -- Large tables, lossy mappings, document flattening, multi-schema, quality checklist.

Supported Paths and Complexity

Supported source/target pairs: PostgreSQL, MySQL, Supabase (Postgres), PlanetScale (MySQL), and MongoDB, in any direction.