D1 Manager is a web UI and API for Cloudflare D1, a serverless SQL database. It provides a user-friendly interface for managing databases, tables, and records, as well as an API for performing operations programmatically. D1 Manager simplifies database management, enabling users to focus on their data.
- Multiple D1 Databases
- List all tables in a database
- Show table schema
- Run SQL queries
- Run Semantic Queries (with
OPENAI_API_KEYenv var set)
- Edit table data through UI
- I18n support (English, Chinese) add more
- API support (see routes/api for details)
- Fork this repo
- Setup a Cloudflare Pages with the forked repo
- Use Cloudflare Access to protect the your site
- Bind databases to
Note: You can bind multiple databases to the manager. In theis example,
defaultin the UI, and
Some plugins (e.g. Semantic Query) require additional environment variables to be set.
Also, there are some configuration options that can be set through environment variables.
SHOW_INTERNAL_TABLES: Show internal tables (
d1_*) in the UI.
OPENAI_API_KEY: OpenAI API key for Semantic Query.
OPENAI_API_URL: You may use this with Cloudflare AI Gateway to proxy requests to OpenAI API.
Semantic Query uses OpenAI GPT-3.5 Turbo to translate natural language queries into SQL.