← Open Source
JacobLinCool

d1-manager

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.

ApplicationsSpecialistsSvelte
Open on GitHub
Momentum
+1stars in 24 hours+0.2%
650
Stars
339
Forks
+2
This week
9
Contributors
Created 2023-03-01 · Updated 2026-10-15 · #6515 today
Top developers
JacobLinCoolfernandodillandmoalamri

JacobLinCool/d1-manager is ranked 6,515 with 650 stars.

Same-category comparison

JacobLinCool/d1-manager is ranked 6,515 among these 8 peers; tldraw/tldraw-offline is ranked 6,522.

Same-category comparison
NameRankMetrics
foreveryh/claude-code-switch6,490
Language:
Shell
Stars:
666
Forks:
93
Description:
One-command model switcher for Claude Code (Only for Anthropic API).
zhongyu09/openchatbi6,491
Language:
Python
Stars:
666
Forks:
92
Description:
OpenChatBI is an intelligent chat-based BI tool powered by large language models, designed to help users query, analyze, and visualize data through natural language conversations. It uses LangGraph and LangChain to build chat agent and workflows that support natural language to SQL conversion and data analysis.
PaoloJN/youtube-ai-extension6,492
Language:
TypeScript
Stars:
665
Forks:
71
Description:
Interactive YouTube extension built with React, Tailwind CSS, and Plasmo. It integrates with the OpenAI API to enable real-time video chat, providing summaries, Q&A, and context-aware responses directly on YouTube.
gaganmanku96/Finding-missing-person-using-AI6,507
Language:
Python
Stars:
655
Forks:
170
Description:
The project focuses on Tracking missing people. We are using Image processing and Machine learning along with Postgres Database.
tldraw/tldraw-offline6,522
Stars:
649
Forks:
24
Description:
A desktop app for using tldraw with local files.
chongdashu/cc-statusline6,529
Language:
TypeScript
Stars:
645
Forks:
63
Description:
Transform your Claude Code experience with a beautiful, informative statusline.
iBlinkQ/llm-wiki-obsidian-blink6,532
Stars:
644
Forks:
109
DeadWaveWave/demo2apk6,536
Language:
TypeScript
Stars:
642
Forks:
69
Description:
Turn your Vibe Coding ideas into runnable Android Apps instantly.
Key parameters and specifications
Key parameters and specifications
ParameterValue
LanguageSvelte
CategoryApplications
SubcategorySpecialists
KeywordsDatabases, Text-to-SQL
Stars650
Forks339
Contributors9
Created date2023-03-01
Updated date2026-10-15
Stars in 1 day1
Stars in 7 days2
Rank6,515
Previous rank6,696
Rank change181
7-day stars rank8,678
Previous 7-day stars rank11,113
7-day stars rank change2,435
Total stars rank15,754
Previous total stars rank15,750
Total stars rank change-4
README summary

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 [x] Multiple D1 Databases [x] List all tables in a database [x] Show table schema [x] Run SQL queries [x] Run Semantic Queries (OpenAI API or Cloudflare AI Worker

) [x] Edit table data through UI [x] I18n support (English, Chinese, Spanish, Japanese) add more (Online Editor) [x] API support (see routes/api for details) Setup 1. Setup a **Cloudflare Pages** with the forked repo 3. Use **Cloudflare Access** to protect the your site 4. **Bind databases** to environment variables Note: You can bind multiple databases to the manager. In theis example, will be in the UI, and will be . 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 ( and ) in the UI. Semantic Query You can use OpenAI API or Cloudflare AI Worker to run Semantic Query. OpenAI API: : OpenAI API key for Semantic Query. : You may use this with Cloudflare AI Gateway to proxy requests to OpenAI API. Cloudflare AI Worker: : Bind a Cloudflare AI Worker to this variable. : Cloudflare AI Worker model for Semantic Query. Screenshots Semantic Query uses OpenAI GPT

-4. 1 Mini to translate natural language queries into SQL.

Frequently asked questions

How many stars and forks are recorded?

JacobLinCool/d1-manager has 650 stars and 339 forks.

What is the repository rank?

JacobLinCool/d1-manager is ranked 6,515.

What language and category are recorded?

JacobLinCool/d1-manager has 650 stars, uses Svelte and belongs to Applications.

Which repository is closest in rank?

JacobLinCool/d1-manager is compared with tldraw/tldraw-offline, ranked 6,522 with 649 stars.

README

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

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

Setup

  1. Fork this repo
  2. Setup a Cloudflare Pages with the forked repo
    • Select the SveltKit framework preset.
    • Build command: npm run build
    • Build output directory: .svelte-kit/cloudflare
  3. 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.
  4. Bind databases to DB_* environment variables

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.

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.

Screenshots

Semantic Query uses OpenAI GPT-4.1 Mini to translate natural language queries into SQL.

Nearby in the ranking
Similar items