D1 Manager offers a web UI and API for Cloudflare D1, a serverless SQL database. It targets developers and users needing to manage D1 databases, tables, and records, with an AI assistant for natural language querying, simplifying database operations.

How It Works

The project utilizes SvelteKit for its web framework, providing a reactive UI and API endpoints. It connects to Cloudflare D1 databases via environment variable bindings. A key feature is the "Semantic Query" capability, which translates natural language prompts into SQL using either OpenAI's API or a Cloudflare AI Worker, abstracting complex query writing.

Quick Start & Requirements

• Deploy to Cloudflare Pages using the SvelteKit framework preset.
• Build command: npm run build
• Build output directory: .svelte-kit/cloudflare
• Bind D1 databases using DB_* environment variables (e.g., DB for default, DB_test for test).
• Optional: OPENAI_API_KEY, OPENAI_API_URL, OPENAI_MODEL for OpenAI integration.
• Optional: Bind a Cloudflare AI Worker to AI and set CFAI_MODEL for Cloudflare AI integration.
• Protect the site using Cloudflare Access.

Highlighted Details

• Web UI for database, table, and record management.
• API support for programmatic operations.
• AI assistant for natural language to SQL query translation.
• Supports multiple D1 databases and internationalization (English, Chinese, Spanish, Japanese).

Maintenance & Community

No specific community links (Discord/Slack) or roadmap are provided in the README. The project is maintained by JacobLinCool.

Licensing & Compatibility

The README does not explicitly state a license. Compatibility for commercial use or closed-source linking is not specified.

Limitations & Caveats

The project is presented as a solution for managing D1 databases, but the lack of explicit licensing information and community channels may pose adoption risks. Details on specific error handling or performance benchmarks are not provided.