Cloudflare D1

What it does

This skill allows AI agents to interact with Cloudflare D1 databases, a serverless SQLite database designed for use with Cloudflare Workers. It enables deploying, managing, and querying data within these globally distributed, zero-cold-start databases. The skill leverages the simplicity of SQLite combined with tools like Drizzle ORM for type safety and migrations, facilitating horizontal scaling across multiple smaller databases.

When to use it

• Building serverless applications that require persistent data storage close to users.
• Managing database schemas and migrations within a version control system.
• Developing Cloudflare Workers that need to interact with structured data.
• Creating type-safe queries and ensuring data integrity using Drizzle ORM.
• Deploying lightweight web applications utilizing the Hono framework (optional).

Key capabilities

• Direct interaction with Cloudflare D1 databases.
• Support for SQLite database operations.
• Integration with Drizzle ORM for type-safe queries and migrations.
• Deployment and management of D1 databases through Wrangler CLI.
• Leveraging horizontal scaling across multiple small databases.

Example prompts

• "Create a new table called 'products' in the D1 database."
• "Run the latest migration on the D1 database."
• "Query the D1 database for all users with the role of 'admin'."
• "Insert a new record into the 'posts' table with the given title and content."

Tips & gotchas

• Requires familiarity with SQLite, Wrangler CLI, and ideally Drizzle ORM.
• D1 databases are designed for horizontal scaling; avoid using them as single large databases.
• Ensure proper configuration of wrangler.toml to correctly bind the database environment variable (e.g., "DB").