SQLite Mobile Client vs D1Explorer

DB Compass for SQLite allows you to access your SQLite databases. You can manage your data with a very clean and simple iOS user interface. FEATURES (with in-app purchase): • Table data: add, edit and delete record • Table data: browse, filter, sort, and quick search on fetched data • Assisted table creation • Blob preview and export • Blob update (from iOS Photos or Files) • Export data grid to CSV, HTML, Excel, MSAccess(XML) and SQLite format • Import CSV, MSAccess(MDB/ACCDB) or DBF tables • View ER Diagram (interactive and with PNG/PDF export) • A.I. integration (OpenAI & Ollama) • Siri-Shortcuts actions • Charts & Widgets OpenAI, Gemini and Claude integration requires api key and is only available in allowed regions. Ollama and LM Studio integration requires your server to connect. -- This is a Premium app and some features may require an in-app lifetime unlock -- For feedback or suggestions contact info@dbcompass.net

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.