Caliope vs SQLite Editor & DB Viewer

Calíope — MySQL, MariaDB, Aurora & PostgreSQL Client Calíope is a powerful, native MySQL, MariaDB, Amazon Aurora and PostgreSQL client built for Mac, iPad and iPhone. Whether you're a developer, DBA, or data analyst, Calíope gives you everything you need to connect, query, explore, and manage your databases — all in a clean, native interface designed for Apple platforms. WHAT'S INCLUDED WITH CALÍOPE PRO SQL Editor — Write and execute queries with syntax highlighting and an integrated execution history, side by side across independent tabs, each with its own live session. Reports — A saved query with its parameters declared and its output defined: which columns, in what order, with what titles and formats. Running it twice gives the same thing. Works against relational databases, SQLite files and MongoDB, exports to nine formats including a paginated PDF, and can run on a schedule. Database Explorer — Browse your full schema — tables, views, stored procedures, triggers, events and more — from an intuitive tree, with columns, indexes and foreign keys at a glance. ER Diagrams — Visualize your database structure with interactive entity-relationship diagrams. Understand table relationships and schema design without writing a single query. Secure Connections — Connect to remote servers safely with native SSH tunneling (ed25519 and ECDSA keys), SSL/TLS encryption, and per-profile credential storage in your system Keychain. Scheduled Backups — Automate backups with flexible scheduling and configurable retention, choosing exactly which databases and tables go into each job. Replication Topology — Declare the primary and its replicas, and see the whole group at once, with a diagram: each replica with its lag, its two threads and the transactions it actually owes. A replica can report 0 seconds while it runs hours behind. Multiple Sessions & Query Log — Open and switch between independent database sessions, each isolated. Every query is logged locally, so you can trace what was executed, when, and on which connection. Works without a server — A built-in SQLite editor for local .sqlite files: structure, data, SQL, pragmas, Save/Revert and CSV/JSON/SQL import and export. Plus a read-only previewer for .md, .sql, .json, .csv, .rtf and .log files. Both work offline. Widgets — Server metrics without opening the app: Mac desktop, iPhone and iPad Home and Lock Screens. One server per widget; tap to open its dashboard. AI SQL Assistant — An optional assistant that helps you write queries, explain results and suggest optimizations. It works from the first launch with Apple Intelligence: no key, no cost, and nothing leaves your device. You can also bring your own key from a supported provider — usage is billed by that provider, and Calíope does not charge for or resell AI services — or point it at a local model. Keys stay in your Keychain. ONE-TIME PURCHASE • Calíope Pro — buy once, keep forever. Pricing is shown in the App Store at the time of purchase and may vary by region. • 60-day free trial with everything unlocked before you decide. No card, no automatic charge. • One purchase unlocks Calíope on all your devices signed in with your Apple ID, with every future update included. • No subscription, no renewals. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Privacy Policy: https://caliope.org/PrivacyPolicy.html

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/