Cloudflare D1 Migrations & Production Seeding

What it does

This skill adds a concrete workflow for treating Cloudflare D1 databases as schema-as-code: it defines initial schema files, creates and applies ordered migrations via Wrangler, and provides environment-aware seeding patterns for dev/test. It emphasises safe, append-only migrations, backfills, and multi-step non-destructive schema evolution so production data is preserved.

When to use it

Use this skill when you need to: set up D1 migrations for a Worker/Hono app, apply schema changes across dev→staging→prod, generate or run seed scripts for dev/test, or plan complex data migrations/backfills that must avoid downtime or data loss. Avoid using it for TypeScript query-level code or unrelated routing logic.

What's included

• Scripts: none packaged, but the skill recommends Wrangler commands and package.json script snippets for migrate/apply/seed.
• References: guidance for recommended project structure (db/migrations, db/seeds, src/db/schema.sql) and Wrangler commands.
• Instructions: explains creating timestamped migration files, applying migrations locally and to envs, seeding patterns, and multi-step schema evolution/backfill strategies.

Compatible agents

Inferred compatible tooling: agents and environments that can run shell/CLI commands (Wrangler) and provide code-level guidance — e.g., Claude Code, Codex/Copilot-style assistants that operate on repo files.