SQLite Mobile Client vs SQL Multi Studio

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

SQL Multi Studio is a full database client for iPhone and iPad: SQL Server, Azure SQL, PostgreSQL, MySQL, MariaDB, Oracle, SQLite, MongoDB, Redis and Microsoft Access, all in one app. CONNECT • Pick any of the 10 engines, or open a file (SQLite .db, Access .mdb/.accdb) • Saved connections grouped by category (Production, Development…), passwords kept in the iOS Keychain • SSH tunnel with a test button before you connect • Several servers open at once, even different engines, side by side QUERY EDITOR • Syntax highlighting, autocomplete, formatter and linter • One tab per server: SQL Server in one tab, PostgreSQL in the next, MongoDB in a third • Several result sets from one run, each in its own tab • Variables (:name), snippets, pinned queries, history, find and replace, EXPLAIN • Focus mode: editor and results fill the screen, with a divider you can drag, in portrait and landscape • JetBrains Mono, bold text and any font size RESULTS • Sort, filter, column stats and pages of 50 to 500 rows • Edit cells in place, in a form, or many rows at once, with the SQL shown before every change • Line, bar and pie charts, compare two results, export to CSV, Excel and JSON • Row menu: edit, clone, copy as INSERT or JSON, view details, delete OBJECT EXPLORER • Tables, views, procedures, triggers, columns, keys and indexes • Table menu: top rows, count, find, distinct, INSERT/UPDATE/DELETE forms, edit structure, CREATE/DROP scripts, notes, data generator • Database menu: ER diagram, table sizes, global search, index advisor, server info, backup and restore scripts • Create tables, views, procedures and triggers from guided forms TOOLS MENU • Execution history, pinned queries, connection health, query alerts with notifications • Slow query log, rollback log, compare results, cross-server query • Migration runner, EXPLAIN visualizer, schema compare, data generator • Sysadmin Control: users, their database access and live sessions SETTINGS • Light, dark and pure black (AMOLED) themes, 10 languages • Face ID / Touch ID lock, Safe Mode (read-only per connection) • Encrypted backup of your connections to your own Google Drive MongoDB: shell commands like db.orders.find().sort().limit(), edit documents in the grid. Redis: keys grouped by namespace, readable hashes, lists, sets and streams. Access files are never changed, and can be converted to SQLite to edit the data. A one-time in-app purchase unlocks editing data on SQL Server, Azure SQL and Oracle, several servers at once, the SSH tunnel, rollback, Safe Mode, Excel and JSON export, CSV import and the analysis tools (ER diagram, table sizes, global search, index advisor, schema compare, migration runner, data generator, connection health, slow query log, query alerts, cross-server query and compare results). Everything runs on your device. Your data never passes through any server of ours.