D1Explorer - Database Manager
Cloudflare D1 & SQLite editor
Only for Mac
Free · In‑App Purchases
Mac
New: Connection Doctor names the permission your API token is missing instead of showing an HTTP status, and the Cost Advisor ranks the queries costing you the most.
D1Explorer is a native macOS database explorer for Cloudflare D1 and SQLite. Browse tables, run queries, and edit data from a fast interface built in Swift and SwiftUI.
FREE TO DOWNLOAD
Download D1Explorer free and connect unlimited D1 and local SQLite accounts. Browse tables, run SELECT queries, inspect schema, preview BLOB/JSON cells, and import Wrangler projects. No account, no trial timer, no limits on reads.
Unlock D1Explorer Pro with a one-time in-app purchase for every write feature: row inserts, updates, and deletes, inline cell editing, table and column changes, and DML/DDL in the query editor. Pro also unlocks the Recovery Center, the Query Notebook, and Cost & Budget's projections and Advisor. Pay once, no subscription, on every Mac signed into the same Apple ID.
Bought D1Explorer before the free tier? Pro unlocks automatically, with no second payment.
KEY FEATURES
• Connection Doctor — Ask a connection what it can actually do. It checks the token, this database, and the permissions behind editing, exporting, restoring, and cost analytics, then names the one you are missing instead of an HTTP status. Free, and every check is a read.
• Cost & Budget — Know what a database costs before the invoice arrives. Month-to-date spend across the three axes D1 bills on, rows read, rows written, and stored bytes, with the billable part separated from what your plan covers. Free, including the figure each remote database shows in the sidebar. Pro adds a month-end projection and a monthly budget per database. Needs a token with Account Analytics: Read.
• Advisor (Pro) — See which query shapes cost you the most, ranked by rows read, the thing D1 bills. Each carries its run count, average time, estimated cost, and rows returned per row read, with a suggested fix where the numbers support one, such as an index for a scan returning twenty rows out of thousands. The findings copy out as Markdown, ready to hand to a coding agent.
• Recovery Center (Pro) — Back up before you write. D1 "Export Snapshot" runs Cloudflare's official export, a .sql dump preserving BLOBs byte-for-byte, and local SQLite uses VACUUM INTO. Time Travel restore rolls a D1 database back to any point in Cloudflare's retention window, backing up first, with one-click undo.
• iCloud Sync — Connections follow you between Macs. Only what identifies a database travels; tokens sync separately through end-to-end encrypted iCloud Keychain, and local SQLite files never sync. Both are switches in Settings.
• Wrangler Project Import — Point D1Explorer at a Worker repo and it finds every local D1 under .wrangler/state, resolves binding names from wrangler.toml, and adds them in a click.
• SQL Query Editor — Write and execute SQL with syntax highlighting, in tabs you open with Cmd+T. Run with Cmd+Return for instant results.
• Query Notebook (Pro) — Never lose the query that fixed production. Save named snippets and keep a per-connection history of everything you've run, failures included, each showing LOCAL or REMOTE, READ or WRITE, time, and rows read.
• Performance Insights — Execution time, network overhead, and rows read per statement, plus which datacenter answered a D1 query and whether a replica served it.
SECURITY FIRST
Your Cloudflare API tokens live only in the macOS Keychain: encrypted by the OS, never in plain text, never sent to third parties. D1Explorer talks straight to Cloudflare's API, with no intermediary servers. Local SQLite files use security-scoped bookmarks under the App Sandbox.
PRIVACY BY DESIGN
D1Explorer collects no analytics, no telemetry, and no user data of its own. Everything happens on your Mac. Cost & Budget and the Advisor read your usage from Cloudflare with your own token and send it nowhere else; those suggestions are local arithmetic, not a language model. The Query Notebook records SQL as you typed it, so it can contain literals from your data: clear a connection's history or turn recording off in Settings.
Ratings & Reviews
- This app hasn’t received enough ratings or reviews to display an overview.
Connection Doctor tells you why a connection is not working, instead of showing you an HTTP status.
• New Connection Doctor, on the stethoscope button above the table list or by right-clicking a connection. It checks whether the token is in the Keychain, whether it can read this database, and whether it carries the permissions behind editing, exporting, restoring, and the analytics Cost & Budget needs, then names the permission you are missing. Free.
• Every check is a read. Capability is inferred from calls a token without the permission is refused for, so nothing is written, created, or mutated to find out whether it could be, and no result is ever stored.
• Local SQLite connections get their own checks, including the security-scoped bookmark that stops resolving once the file moves, which is how a local connection quietly breaks.
• New Advisor tab in Cost & Budget (Pro), ranking the query shapes running against a database by the rows they read, since rows read is what D1 bills on. Each carries its run count, average time, estimated cost, and rows returned per row read, plus a suggestion where the numbers clearly support one, such as an index for a statement that scans thousands of rows to return twenty.
• The advice is local arithmetic, not a language model, and nothing is sent anywhere. Cloudflare strips bound parameters before recording a statement, so no value from your data appears in that list.
• The Advisor's findings copy out as Markdown, ready to hand to a coding agent, with each statement's full SQL rather than the pane's shortened preview. The report says up front that these are heuristics computed from row counts, which have never seen your schema, so an agent treats them as candidates to check rather than instructions to follow. Any row's full SQL also expands and copies on its own.
• Connections now follow you between Macs. The list syncs through iCloud, and only what identifies a database travels: its name, account ID, database ID, and database name. API tokens sync separately through iCloud Keychain, which is end-to-end encrypted and readable only by your own devices. Local SQLite connections never sync, since their bookmark cannot resolve inside another device's sandbox. Both are independent switches in Settings, on by default.
• D1 queries now show which datacenter answered them, in the same strip as execution time and rows read: the colo, whether the primary or a replica served it, and the region when it was a replica.
• An expired token, a token missing a permission, and a malformed statement are now three different errors instead of one string. They previously all arrived as a raw HTTP status and response body, which sent people hunting through their SQL for a bug that was never there.
• Importing a Wrangler project is easier to find. It is now an option in the New Connection sheet and a button on the empty connections list, not only an item tucked inside the toolbar "+" menu.
The developer, Magenta Creations, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Collected
The developer does not collect any data from this app.
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
- Seller
- Magenta Creations
- Size
- 2.1 MB
- Category
- Developer Tools
- Compatibility
Requires macOS 26.0 or later.
- Mac
Requires macOS 26.0 or later.
- Mac
- Languages
- English
- Age Rating
4+
- 4+
- In-App Purchases
Yes
- D1Explorer Pro $5.99
- Copyright
- © 2026 D1Explorer

