cloudflare-d1:setup

D1 Setup Wizard

Overview

Interactive wizard for complete D1 setup: create database, configure bindings, generate schema, and run first migration.

Prerequisites

Check before starting:

• Cloudflare account with wrangler authenticated (wrangler whoami)
• Existing Worker project or willingness to create one
• Write access to wrangler.jsonc/wrangler.toml

Steps

Step 1: Gather Requirements

Use AskUserQuestion to collect setup preferences.

Question 1: Database Name

• Prompt: "What should your database be named?"
• Examples: "my-app-db", "production-db", "users-db"
• Validation: Alphanumeric + hyphens only (validate before proceeding)
• Store as: databaseName

Question 2: Binding Name

• Prompt: "What binding name should be used in your Worker code?"
• Default: "DB"
• Examples: "DB", "DATABASE", "USERS_DB"
• Validation: Valid JavaScript identifier
• Store as: bindingName

Question 3: Schema Source

• Prompt: "Do you have an existing schema.sql file?"
• Options:
  • "Yes - I have schema.sql" → Ask for path
  • "No - Generate basic schema" → Ask for table names
• Store as: hasSchema, schemaPath or tableNames

Question 4: Read Replication

• Prompt: "Enable read replication? (Recommended for read-heavy apps, requires paid plan)"
• Options:
  • "Yes - Enable read replication"
  • "No - Single region only"
• Store as: enableReplication

Question 5: Data Jurisdiction (if user is on paid plan)

• Prompt: "Specify data jurisdiction for compliance? (Optional, paid plan only)"
• Options:
  • "GLOBAL - Best performance (default)"
  • "EU - European Union (GDPR compliance)"
  • "US - United States"
• Store as: jurisdiction

---

Step 2: Create Database

Build and execute wrangler command based on user inputs:

# Base command
wrangler d1 create <databaseName>

# Add jurisdiction if specified and not GLOBAL
if [jurisdiction != "GLOBAL"]:
  wrangler d1 create <databaseName> --jurisdiction <jurisdiction>