cloudflare-d1:create-migration

D1 Create Migration Command

Overview

Guided migration creation with validation, SQL generation, and safe testing workflow.

Prerequisites

• Existing D1 database configured in wrangler.jsonc
• migrations/ directory exists (created during setup)
• wrangler CLI available

Steps

Step 1: Migration Type

Use AskUserQuestion to determine what kind of migration to create.

Prompt: "What type of migration are you creating?"

Options:

1. "Add new table"
2. "Modify existing table (add/remove columns)"
3. "Add indexes"
4. "Data migration (update existing records)"
5. "Custom SQL"

Store as: migrationType

---

Step 2: Gather Migration Details

Based on migrationType, collect specific details:

If "Add new table":

Ask:

• Table name: tableName
• Columns (comma-separated): columnsList
  • Example: "id INTEGER PRIMARY KEY, name TEXT, email TEXT UNIQUE"
• Add foreign keys? (yes/no): hasForeignKeys
  • If yes, ask: "Which table.column?" → foreignKeyReferences

If "Modify existing table":

Ask:

• Table name: tableName
• Change type:
  • "Add column"
  • "Drop column"
  • "Rename column"
  • Store as: changeType
• Column details: columnDetails

If "Add indexes":

Ask:

• Table name: tableName
• Columns to index (comma-separated): indexColumns
• Index type:
  • "Single column index"
  • "Composite index (multiple columns)"
  • "Unique index"
  • Store as: indexType

If "Data migration":

Ask:

• Description of data change: description
• Warning: "Data migrations should be idempotent and tested in staging first. Proceed?"

If "Custom SQL":

Ask:

• "Provide SQL file path or paste SQL directly"
• Store as: customSQL

---

Step 3: Generate Migration File

Create migration file with timestamp:

# Generate timestamp
TIMESTAMP=$(date +%Y%m%d%H%M%S)

# Create migration filename
MIGRATION_FILE="migrations/${TIMESTAMP}_<description>.sql"

Generate SQL based on migration type: