/migrate

Manage database schema migrations.

Usage

/db-migrate [action] [--name <migration_name>]

Arguments

• action: create, run, status, rollback (default: run)
• --name: Name for new migration

Instructions

When this skill is invoked:

Agent Behavior

Autonomy:

• Complete migration operation end-to-end
• Verify migration success
• Report any issues clearly

Safety:

• Always check migration status before running
• Warn about destructive operations
• Suggest backup for production

Actions

Create Migration

/migrate create --name add_user_profile

1. Read prd/00_technology.md for migration command
2. Generate migration:

   {migration_create_command} --name {name}

3. Report created file location
4. Suggest next steps

Run Migrations

/migrate run

1. Check migration status:

   {migration_status_command}

2. Run pending migrations:

   {migration_run_command}

3. Regenerate client (if applicable):

   {db_generate_command}

4. Verify success

Check Status

/migrate status

1. Show migration status:

   {migration_status_command}

2. List pending migrations
3. List applied migrations

Rollback (Careful!)

/migrate rollback

1. ⚠️ Warn about data loss
2. Confirm with user
3. Execute rollback:

   {migration_rollback_command}

Common Workflows

After schema changes:

# 1. Generate client (if ORM requires)
/migrate create --name describe_changes

# 2. Review generated migration

# 3. Run migration
/migrate run

# 4. Verify
/migrate status

Before deployment:

# Check pending migrations
/migrate status

# Run in production (with backup!)
/migrate run

Example Output

$ /migrate create --name add_user_preferences

📋 Creating migration: add_user_preferences

Running: {migration_create_command} --name add_user_preferences

✅ Migration created: {migration_file_path}

Next steps:
1. Review the generated migration
2. Run: /migrate run
3. Regenerate client: {db_generate_command}

$ /migrate status

📋 Migration Status

Applied:
✅ 001_initial_schema (2026-01-10)
✅ 002_add_users (2026-01-12)
✅ 003_add_posts (2026-01-14)

Pending:
⏳ 004_add_user_preferences

Run '/migrate run' to apply pending migrations.