Why We Built MyD1

Cloudflare D1 changed the game. A globally distributed SQLite database with zero ops, baked into the Workers ecosystem. For developers building at the edge, it was exactly what was missing.

D1 is a breakthrough database — but its tooling was stuck in the terminal. We built MyD1 to fix that.

But there was a catch: the tooling.

The problem

Your options for working with D1 were limited:

• wrangler d1 execute in the terminal — functional, but slow and painful for anything beyond a quick query
• The Cloudflare dashboard — web-based, limited, no table browser
• General-purpose clients like TablePlus or DBeaver — they don't speak D1's REST API at all

If you wanted to browse tables, inspect schema, or just see your data visually, you were out of luck. And if you also used MySQL or PostgreSQL alongside D1? Three different tools, three different workflows.

What we wanted

We wanted a single, native macOS app that could:

• Connect to Cloudflare D1 databases via the REST API
• Connect to MySQL, PostgreSQL, and SQLite via native protocols
• Browse tables, run queries, and inspect schema — visually
• Use AI to write SQL from plain English descriptions
• Launch instantly and use less than 50MB of memory

Nothing like this existed. So we built it.

Pure SwiftUI, zero dependencies

MyD1 is built entirely in Swift using SwiftUI. No Electron. No JVM. No web wrappers. The app binary is small, it launches instantly, and it respects your Mac's resources.

We implemented the MySQL and PostgreSQL wire protocols from scratch in pure Swift — no ODBC, no JDBC, no external libraries. For D1, we built a native REST API adapter that maps Cloudflare's HTTP endpoints to the same interface you'd use for any other database. SQLite uses the system library to open local database files directly with file validation and permission checks.

AI Agent that knows your schema

MyD1's AI Agent reads your entire database schema — tables, columns, types, foreign keys, constraints — and uses it as context when generating SQL. Ask a question in plain English, and the AI Agent writes a correct, runnable query. It can also optimize your databases and discover insights you might miss. Refine results conversationally — the AI remembers the full conversation.

It works with Anthropic, OpenAI, xAI, Ollama (local, free), and OpenRouter. The AI Agent is free for all users — bring your own API key and your data never touches our servers.

Try it

MyD1 is free to download. The Pro version unlocks analytics dashboard, extra database engines, SSH tunnels, and advanced tools for a one-time purchase.

Download MyD1 and connect to your first database in 30 seconds.

Read next: Why MyD1 Is Mac-Only — And Why That's the Point