npx keyloom migrate up

# Apply specific number of migrations
npx keyloom migrate up --steps 2

# Dry run (show what would be executed)
npx keyloom migrate up --dry-run

npx keyloom migrate down

# Rollback specific number of migrations
npx keyloom migrate down --steps 2

# Rollback to specific migration
npx keyloom migrate down --to 20240101000000

npx keyloom migrate status

# Show detailed migration info
npx keyloom migrate status --verbose

Migration Status

Database: postgresql://localhost:5432/myapp
Adapter: Prisma

Applied Migrations:
✓ 20240101000000_initial_schema
✓ 20240102000000_add_rbac
✓ 20240103000000_add_refresh_tokens

Pending Migrations:
○ 20240104000000_add_audit_log
○ 20240105000000_add_mfa_support

Status: 2 pending migrations

npx keyloom migrate create add_user_preferences

# Create with specific adapter
npx keyloom migrate create add_user_preferences --adapter prisma

migrations/
└── 20240106120000_add_user_preferences/
    ├── migration.sql
    └── rollback.sql

prisma/migrations/
└── 20240101000000_initial_schema/
    └── migration.sql

-- CreateTable
CREATE TABLE "users" (
    "id" TEXT NOT NULL,
    "email" TEXT,
    "name" TEXT,
    "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "users_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE UNIQUE INDEX "users_email_key" ON "users"("email");

drizzle/migrations/
├── 0001_initial_schema.sql
└── meta/
    └── _journal.json

CREATE TABLE IF NOT EXISTS "users" (
	"id" varchar(191) PRIMARY KEY NOT NULL,
	"email" varchar(191),
	"name" varchar(191),
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL
);

CREATE UNIQUE INDEX IF NOT EXISTS "users_email_idx" ON "users" ("email");

migrations/
├── 001_initial_schema.up.sql
├── 001_initial_schema.down.sql
├── 002_add_rbac.up.sql
└── 002_add_rbac.down.sql

-- Up migration
CREATE TABLE users (
  id VARCHAR(191) PRIMARY KEY,
  email VARCHAR(191) UNIQUE,
  name VARCHAR(191),
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

-- Down migration
DROP TABLE IF EXISTS users;

🔍 Pre-migration checks...
✓ Database connection successful
✓ Migration table exists
✓ No conflicting migrations
✓ Backup recommended for production

📝 Applying migrations...

→ 20240104000000_add_audit_log
  ✓ CREATE TABLE audit_events
  ✓ CREATE INDEX idx_audit_events_user_id
  ✓ Migration completed in 0.12s

→ 20240105000000_add_mfa_support  
  ✓ ALTER TABLE users ADD COLUMN mfa_enabled
  ✓ CREATE TABLE mfa_secrets
  ✓ Migration completed in 0.08s

✅ Applied 2 migrations successfully

🔍 Post-migration validation...
✓ All tables created successfully
✓ Indexes applied correctly
✓ Foreign key constraints valid
✓ Migration history updated

npx keyloom migrate down --steps 1

⚠️  Rolling back migration: 20240105000000_add_mfa_support

This will:
- DROP TABLE mfa_secrets
- DROP COLUMN users.mfa_enabled

? Continue with rollback? (y/N) › y

📝 Rolling back...
✓ Rollback completed successfully

⚠️  WARNING: This rollback may cause data loss!

The following data will be permanently deleted:
- Table: mfa_secrets (contains 150 records)
- Column: users.mfa_enabled (contains data for 45 users)

? Type 'CONFIRM' to proceed: › CONFIRM

# Use Prisma's migration system
npx keyloom migrate up
# Equivalent to: npx prisma db push

# Use Drizzle Kit for migrations
npx keyloom migrate up
# Equivalent to: npx drizzle-kit push

# Execute raw SQL migrations
npx keyloom migrate up --adapter postgres

# Automatic backup prompt
npx keyloom migrate up

⚠️  Production database detected!

Recommended: Create backup before migration
? Create backup now? (Y/n) › Y

📦 Creating backup...
✓ Backup saved: backup_20240106_120000.sql

# Check for breaking changes
npx keyloom migrate up --check-breaking

# Apply non-breaking migrations first
npx keyloom migrate up --safe-only

🔒 Acquiring migration lock...
✓ Lock acquired (expires in 30 minutes)

📝 Applying migrations...
✓ Migrations completed
✓ Lock released

Error: Migration failed at step 3/5

Error: Could not acquire migration lock

Error: Cannot rollback - no down migration found

Warning: Database schema differs from migration history

npx keyloom migrate up --migrations-dir ./custom/migrations

# Development
npx keyloom migrate up --env development

# Staging
npx keyloom migrate up --env staging

# Production
npx keyloom migrate up --env production --require-backup

export default defineKeyloom({
  migrations: {
    hooks: {
      beforeMigration: async (migration) => {
        console.log(`Starting migration: ${migration.name}`);
      },
      afterMigration: async (migration) => {
        console.log(`Completed migration: ${migration.name}`);
      },
    },
  },
});