Help us improve
Share bugs, ideas, or general feedback.
From role-database
Guides schema and data migrations across engines with tools like Flyway, Liquibase, Alembic, Prisma Migrate. Covers zero-downtime patterns (expand-contract), cross-engine (MySQL→PG), CDC (Debezium). Use for schema changes or DB migrations.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:database-migrationThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Load from `references/` based on what's needed:
Creates, validates, executes, and rolls back schema migrations for PostgreSQL, MySQL, MongoDB using Flyway, Alembic, Prisma, Knex.
Provides best practices for safe database migrations: schema changes, data backfills, rollbacks, zero-downtime deploys for PostgreSQL, MySQL, Prisma, Drizzle, Django.
Guides safe database migrations for schema changes, data backfills, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and ORMs like Prisma, Drizzle, Kysely, Django, TypeORM.
Share bugs, ideas, or general feedback.
Load from references/ based on what's needed:
Migration tool comparison table (11 tools across all languages). Expand-contract pattern step-by-step (expand, dual-write, backfill, switch, contract). Online DDL operations matrix (PostgreSQL vs MySQL locking behavior). PostgreSQL concurrent index creation with INVALID index recovery. Batch migration for large tables. MySQL online tools (pt-osc, gh-ost). Load when: choosing a migration tool, implementing zero-downtime changes, or migrating large tables.
MySQL to PostgreSQL type mapping and pgloader one-liner. Oracle to PostgreSQL key syntax differences and tooling. MongoDB to PostgreSQL flattening patterns. CDC-based migration with Debezium connector config and AWS DMS overview. Migration validation (row count + checksum comparison). CI/CD pipeline integration with Flyway. Safety checklist and anti-patterns. Load when: migrating between database engines, using CDC for live migration, or integrating migrations into CI/CD.