database-migrator

Solid

Migrates databases between providers (Postgres, MySQL, Supabase, PlanetScale, MongoDB). Reads source schema, generates migration scripts, handles data type mapping, foreign keys, indexes, triggers, stored procedures. Validates migration with row counts and checksums. Generates migration-plan.md with step-by-step execution guide, rollback procedures, estimated downtime.

API & Backend 180 stars 30 forks Updated 4 days ago MIT

Install

View on GitHub

Quality Score: 91/100

Stars 20%
75
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# 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. - Low: Same underlying engine (e.g., Postgres to Supabase). Mostly connection and permission changes. - Medium: Same paradigm, d...

Details

Author
OneWave-AI
Repository
OneWave-AI/claude-skills
Created
7 months ago
Last Updated
4 days ago
Language
N/A
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

API & Backend Listed

database-migration

Use when planning or applying a raw-SQL database migration to a live PostgreSQL database — adding columns, renaming columns or tables, changing types, creating indexes, adding foreign keys, or running data backfills. Covers zero-downtime patterns (expand / contract, batched backfill, NOT VALID foreign keys, CONCURRENTLY indexes), the unpooled-connection requirement for DDL, branched-database workflows, and rollback strategy. Do NOT use for ORM-managed migrations driven by Prisma/Drizzle/TypeORM CLI scaffolding (the generation rules are tool-specific), for chasing a migration that has already failed in production (use `debugging`), or for designing the row-level-security model itself (use `owasp-security`). Do NOT use for design the row-level-security model for our new tenant table. Do NOT use for the migration crashed in production — find the root cause. Do NOT use for explain our migration conventions in the contributor docs. Do NOT use for refactor the migration runner helper for clarity.

0 Updated yesterday
jacob-balslev
API & Backend Listed

migration-planner

Plan and track cross-platform or cross-service migrations (Supabase to Firebase, single to multi-tenant, schema migrations, etc). Generates rollback-safe migration plans with state tracking.

2 Updated today
Silex-Research
API & Backend Listed

database-migration-script-generator

Generate database migration scripts for Liquibase, Flyway, Alembic with rollback safety, data preservation, and zero-downtime patterns

6 Updated 6 days ago
williamzujkowski