Repolode
Submit
JacobLinCool

JacobLinCool/d1-manager

A self-hostable web UI and API for managing Cloudflare D1 serverless SQL databases, with optional natural-language queries.

View on GitHubWebsite
Stars
653
Forks
341
Open issues
24
Last commit
3 days ago

What is it?

D1 Manager is a web interface and API for Cloudflare D1, the serverless SQL database. It lets you browse multiple D1 databases, list tables, inspect table schemas, run raw SQL, and edit table records through a UI, so you don't have to rely only on the command line or the Cloudflare dashboard.

The project is built with SvelteKit and is meant to be deployed on Cloudflare Pages. Databases are attached by binding them to DB_* environment variables, and access can be restricted with Cloudflare Access. The interface is available in English, Chinese, Spanish and Japanese.

An optional Semantic Query feature translates natural-language questions into SQL. It can use either the OpenAI API (with a configurable model and URL, for example via AI Gateway) or a Cloudflare AI Worker binding. The project also exposes an API for performing database operations programmatically.

Key features

  • 01Manage multiple D1 databases from one web UI
  • 02Browse tables and view table schemas
  • 03Run raw SQL queries
  • 04Edit table records directly in the interface
  • 05Translate natural-language questions into SQL via OpenAI or Cloudflare AI Worker
  • 06Programmatic API for database operations

Use cases

  • Inspecting and editing data in D1 databases without the Cloudflare dashboard
  • Giving non-SQL team members a browser-based way to query D1 data
  • Using natural-language queries to explore an unfamiliar D1 schema
  • Automating D1 operations through the built-in API

Quick start

  1. 1

    Fork the repo

  2. 2

    Set up a Cloudflare Pages project with the forked repo using the SvelteKit preset

  3. 3

    Use the build command npm run build with output directory .svelte-kit/cloudflare

    npm run build
  4. 4

    Bind your D1 databases to DB_* environment variables

Things to know

  • Setup requires deploying to Cloudflare Pages and binding D1 databases, so it is tied to the Cloudflare platform.
  • Protecting the site properly needs Cloudflare Access configured manually for each URL.
  • Semantic Query needs an OpenAI API key or a Cloudflare AI Worker binding.

In collections

Databases & SQL tools

Topics

#cloudflare-d1#sql#database-management#sveltekit#cloudflare-pages#text-to-sql#d1#database#gpt

FAQ

What is d1-manager?
A self-hostable web UI and API for managing Cloudflare D1 serverless SQL databases, with optional natural-language queries. D1 Manager is a web interface and API for Cloudflare D1, the serverless SQL database. It lets you browse multiple D1 databases, list tables, inspect table schemas, run raw SQL, and edit table records through a UI, so you don't have to rely only on the command line or the Cloudflare dashboard.
Is d1-manager free to use? What license does it have?
d1-manager is open source under the MIT license. Check the license terms before using it in commercial products.
Is d1-manager still maintained?
Actively maintained. The last commit to d1-manager was on Nov 3, 2026.
What can I use d1-manager for?
Inspecting and editing data in D1 databases without the Cloudflare dashboard Giving non-SQL team members a browser-based way to query D1 data Using natural-language queries to explore an unfamiliar D1 schema Automating D1 operations through the built-in API
How do I install d1-manager?
Fork the repo Set up a Cloudflare Pages project with the forked repo using the SvelteKit preset Use the build command npm run build with output directory .svelte-kit/cloudflare: npm run build Bind your D1 databases to DB_* environment variables
Where can I get d1-manager?
The source code and installation instructions are on GitHub: https://github.com/JacobLinCool/d1-manager

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects