migrate

Database Migration Manager

Detects the project's ORM, generates migrations, validates them, and manages the migration lifecycle.

---

Execution Flow

Step 1: Detect ORM

# Prisma
[ -d "prisma" ] && [ -f "prisma/schema.prisma" ] && echo "PRISMA"

# Drizzle
[ -f "drizzle.config.ts" ] || [ -f "drizzle.config.js" ] && echo "DRIZZLE"

# TypeORM
grep -q "typeorm" package.json 2>/dev/null && echo "TYPEORM"

# Sequelize
grep -q "sequelize" package.json 2>/dev/null && echo "SEQUELIZE"

# Django
[ -f "manage.py" ] && grep -q "django" requirements.txt 2>/dev/null && echo "DJANGO"

# Alembic (SQLAlchemy)
[ -f "alembic.ini" ] && echo "ALEMBIC"

# Knex
grep -q "knex" package.json 2>/dev/null && echo "KNEX"

# Golang (golang-migrate / goose)
[ -d "migrations" ] && ls migrations/*.sql &>/dev/null && echo "GO_MIGRATE"

---

Step 2: Run Action

Action: {{action}} Name: {{name}}

create - Generate a New Migration

Prisma:

npx prisma migrate dev --name {{name}} --create-only

Before running, read prisma/schema.prisma and validate:

• No destructive changes without explicit confirmation (dropping columns/tables)
• New required fields have defaults or are nullable
• Index names follow conventions
• Relations have proper onDelete behavior

Drizzle:

npx drizzle-kit generate:pg --name {{name}}

TypeORM:

npx typeorm migration:generate -n {{name}} -d src/data-source.ts

Django:

python manage.py makemigrations --name {{name}}

Alembic:

alembic revision --autogenerate -m "{{name}}"

Knex:

npx knex migrate:make {{name}}

After generation:

1. Read the generated migration file
2. Verify it matches intended changes
3. Check for destructive operations
4. Validate reversibility (down migration exists)

Migration Created
-----------------
File: prisma/migrations/20240115_add_user_roles/migration.sql
ORM:  Prisma

Changes detected:
  + CREATE TABLE "Role" (id, name, createdAt)
  + ALTER TABLE "User" ADD COLUMN "roleId" (FK -> Role.id)
  + CREATE INDEX "User_roleId_idx" ON "User"("roleId")

Safety check:
  [PASS] No destructive operations
  [PASS] New columns are nullable or have defaults
  [PASS] Foreign keys have ON DELETE behavior
  [PASS] Indexes added for foreign keys

Ready to apply with: /migrate run