cloudflare-d1-migrations-and-production-seeding

What problem does it solves?

Designing, running, or refining Cloudflare D1 schema management, migrations, and data seeding for dev/staging/production environments can be complex and error-prone, especially with Hono/Workers apps. This Skill automates the lifecycle, ensuring predictable, reproducible, and safe D1 schema evolution across all environments.

Core Features & Use Cases

• Automated Schema & Migration Management: Design D1 schemas using SQL and manage migrations via Wrangler, ensuring append-only changes and version control.
• Environment-Aware Migration Workflows: Implement safe migration strategies for dev, staging, and production databases, including package.json scripts for repeatable execution.
• Data Seeding & Evolution: Create seed scripts for development/test data and plan for safe data migrations (e.g., column renames) without losing data.

Quick Start

Create initial D1 schema and migrations for users/posts, set up dev/staging/prod migration commands for D1, and add seeding for local dev.