D1Explorer vs SQLite Editor & DB Viewer

D1Explorer is a native Cloudflare D1 client for iPhone and iPad that backs up before it writes. Browse, query and edit your databases, with cost projection and Time Travel restore. FREE TO DOWNLOAD Download D1Explorer free and connect unlimited Cloudflare D1 databases. Browse tables, run SELECT queries, inspect schema and preview BLOB/JSON cells. No account, no trial timer, no read limits. 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, and one purchase covers iPhone, iPad and Mac. KEY FEATURES • Editable Data Grid — Tap a cell to edit it, add rows, then discard or commit. Pending edits are shown as the SQL they will run before anything runs, and a remote database asks once more before it is written to. • Recovery Center (Pro) — Back up before you write. "Export Snapshot" runs Cloudflare's official export, a .sql dump preserving BLOBs byte-for-byte. Time Travel rolls a D1 database back to any point in its retention window, backing up first. • Cost & Budget — Know what a database costs before the invoice arrives. Month-to-date spend on the three axes D1 bills, rows read, rows written and stored bytes, with the billable part separated. Free, including the sidebar figure on each database. Pro adds a month-end projection, a monthly budget, and an Advisor that ranks the query shapes reading the most rows, suggests a fix where the numbers support one, and copies out as Markdown. • Draft SQL & Query Editor — Describe what you want, as in "active pro users, newest first", and Apple Intelligence turns it into a SELECT you can read and edit before you run it. Or write SQL by hand. Free. • Sign in with Cloudflare — Connect without making an API token. Approve D1Explorer once on Cloudflare's own screen, decide there whether it gets write access and usage analytics, and withdraw it whenever you like. Free. • 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. • iCloud Sync — Connections follow you between your devices. Only what identifies a database travels; credentials sync separately through end-to-end encrypted iCloud Keychain. • 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 labelled READ or WRITE. • Performance Insights — Execution time and rows read per statement, plus which D1 datacenter answered and whether a replica served it. SECURITY FIRST Your Cloudflare credentials live only in the iOS Keychain, pasted token or sign-in grant alike: encrypted by the OS, never in plain text, never sent to third parties. D1Explorer talks straight to Cloudflare, with no intermediary servers. PRIVACY BY DESIGN D1Explorer collects no analytics, no telemetry, and no user data of its own. Cost & Budget and the Advisor read your usage from Cloudflare with your own credentials and send it nowhere else; the Advisor's suggestions are local arithmetic, not a language model. Draft SQL is the one feature that uses a language model, and it is Apple's on-device one: it receives your question and this database's table and column names, never a value from any row, and nothing is uploaded. The Query Notebook records SQL as you typed it, so it can contain literals from your data: clear its history or turn recording off in Settings. Local SQLite files and Wrangler project import are Mac features and are not part of the iPhone and iPad app.

SQLite Editor & DB Viewer opens, browses, and edits SQLite and .db database files right on your iPhone and iPad — no computer, no setup, no account. Whether you're a developer inspecting an app's database, a student learning SQL, or an analyst exploring data on the go, everything runs locally and offline. OPEN & BROWSE ANY DATABASE • Open .db, .sqlite, and .sqlite3 files from Files, iCloud, or share sheet • Browse every table, view rows and columns, and inspect the full schema • Fast search across tables and values • Works completely offline — your data never leaves your device RUN SQL — OR SKIP IT • Full SQL editor with syntax highlighting to run any query • Visual Query Builder: tap tables, columns, and filters and the app writes the SQL for you — no syntax to memorize • Edit rows inline, add and delete records, and commit changes safely IMPORT & EXPORT • Import spreadsheets — CSV, JSON, and Excel — straight into a table • Export tables and query results to CSV • Save databases back to your device LEARN SQL AS YOU GO • 26 interactive SQL lessons — from SELECT and WHERE to JOINs and subqueries • A practice sandbox with a ready-made sample database — try queries with zero risk • Perfect for beginners moving from "no SQL" to confident queries BUILT FOR iPHONE & iPAD • Designed for both — a full workspace on the big iPad screen • Clean dark interface, easy on the eyes PRO (optional) • Remove ads and unlock the full set of power features • Available as a monthly subscription or a one-time lifetime unlock • A free trial of each Pro feature is included — no commitment Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/