database-migration-helper

What problem does it solve?

This Skill simplifies the complex and error-prone process of creating database migrations across various ORMs (Prisma, TypeORM, Alembic, Sequelize) and raw SQL. It ensures migrations are safe, reversible, and include proper schema changes and data transformations, preventing data loss and downtime.

Core Features & Use Cases

• Multi-ORM Migration Templates: Provides structured templates for Prisma, TypeORM, Alembic, and Sequelize, including up and down logic.
• Complex Data Migrations: Guides through transforming and migrating data between schema versions, ensuring data integrity.
• Use Case: When you need to add a role column to your users table and backfill existing users with a default role, use this Skill to "create a database migration." It will generate the necessary up and down SQL, including data migration logic, for your chosen ORM.

Quick Start

Create a database migration to add a 'role' column to the 'users' table and set a default value.