JacobLinCool/d1-manager

JacobLinCool/d1-manager has 656 GitHub stars and 341 forks. GitHot measured +1 stars in 24 hours and +3 in 7 days. Last checked 2026-11-11 19:16 UTC. Last push 2026-11-02.

这些数字如何统计

D1 Manager is a web UI and API for Cloudflare D1, a serverless SQL database. It provides a web interface for managing databases, tables, and records, as well as an AI assistant to help you write query in natural language.

656 星标 341 forks +1 24小时

可以做什么

Multiple D1 Databases
List all tables in a database
Show table schema
Run SQL queries

实测星标增长

24小时: +1
7天: +3
15天: 正在收集历史
1个月: 正在收集历史

各周期内的星标净变化，周期相互重叠，并非每日新增。缺失的测量保持空白。星标代表关注度，不代表软件质量。

README.md

原文

D1 Manager

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.

Features

Multiple D1 Databases
List all tables in a database
Show table schema
Run SQL queries
Run Semantic Queries (OpenAI API or Cloudflare AI Worker)
Edit table data through UI
I18n support (English, Chinese, Spanish, Japanese) add more (Online Editor)
API support (see routes/api for details)

Setup

Fork this repo
Setup a Cloudflare Pages with the forked repo
- Select the SveltKit framework preset.
- Build command: npm run build
- Build output directory: .svelte-kit/cloudflare
Use Cloudflare Access to protect the your site
- The default access rules only restrict access to preview pages, so make sure to add other urls you want protected.
Bind databases to DB_* environment variables

bind-d1

Note: You can bind multiple databases to the manager. In theis example, DB will be default in the UI, and DB_test will be test.

Environment Variables

Some plugins (e.g. Semantic Query) require additional environment variables to be set.

set-env-var

Also, there are some configuration options that can be set through environment variables.

SHOW_INTERNAL_TABLES: Show internal tables (splite_* and d1_*) in the UI.

Semantic Query

You can use OpenAI API or Cloudflare AI Worker to run Semantic Query.

OpenAI API:

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.
OPENAI_MODEL: OpenAI API model for Semantic Query. Default to gpt-4.1-mini.

Cloudflare AI Worker:

AI: Bind a Cloudflare AI Worker to this variable.
CFAI_MODEL: Cloudflare AI Worker model for Semantic Query. Default to @cf/mistral/mistral-7b-instruct-v0.1.