{"repo":"JacobLinCool/d1-manager","free":true,"listed":false,"github":"https://github.com/JacobLinCool/d1-manager","clone":"git clone https://github.com/JacobLinCool/d1-manager.git","description":"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.","language":"Svelte","stars":640,"topics":["cloudflare-pages","d1","database","sql","gpt"],"license":"MIT","category":"databases-storage","readme_excerpt":"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 Open","default_branch":null,"files":null,"tree":[],"storefront":"/r/JacobLinCool","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/JacobLinCool/d1-manager/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}