Community projects
Members of the Cloudflare developer community and broader developer ecosystem have built and/or contributed tooling — including ORMs (Object Relational Mapper) libraries, query builders, and CLI tools — that build on top of D1.
Projects
Backup/export tools
Two community tools are available for creating backups/exports of D1 databases as .sql
files. D1 exports can be restored using Wrangler.
- Cretezy/cloudflare-d1-backup which runs in your command line using the D1 API (slower but simpler.)
- nora-soderlund/cloudflare-d1-backups which runs in deployed Workers using D1 Bindings (faster but more complex.)
D1 adapter for Kysely ORM
Kysely is a type-safe and autocompletion-friendly typescript SQL query builder. With this adapter you can interact with D1 with the familiar Kysely interface.
feathers-kysely
The feathers-kysely
database adapter follows the FeathersJS Query Syntax standard and works with any framework. It is built on the D1 adapter for Kysely and supports passing queries directly from client applications. Since the FeathersJS query syntax is a subset of MongoDB’s syntax, this is a great tool for MongoDB users to use Cloudflare D1 without previous SQL experience.
Drizzle ORM
Drizzle ORM is a TypeScript ORM for SQL databases designed with maximum type safety in mind. It also comes with an automatic migrations generation tool. Drizzle automatically generates your D1 schema based on types you define in TypeScript, and exposes an API that allows you to query your database directly.
d1-orm
Object Relational Mapping (ORM) is a technique to query and manipulate data by using JavaScript. Created by a Cloudflare Discord Community Champion, the d1-orm
seeks to provide a strictly typed experience while using D1.
workers-qb
workers-qb
is a zero-dependency query builder that provides a simple standardized interface while keeping the benefits and speed of using raw queries over a traditional ORM. While not intended to provide ORM-like functionality, workers-qb
makes it easier to interact with your database from code for direct SQL access.
d1-console
Instead of running the wrangler d1 execute
command in your terminal every time you want to interact with your database, you can interact with D1 from within the d1-console
. Created by a Discord Community Champion, this gives the benefit of executing multi-line queries, obtaining command history, and viewing a cleanly formatted table output.
L1
L1
is a package that brings some Cloudflare Worker ecosystem bindings into PHP and Laravel via the Cloudflare API. It provides interaction with D1 via PDO, KV and Queues, with more services to add in the future, making PHP integration with Cloudflare a real breeze.
Staff Directory - a D1-based demo
Staff Directory is a demo project using D1, HonoX, and Cloudflare Pages. It uses D1 to store employee data, and is an example of a full-stack application built on top of D1.
Feedback
To report a bug or file feature requests for these community projects, create an issue directly on the project’s repository.