Caliope vs MagicSQL

Calíope — Database Client for Mac, iPad and iPhone Calíope is a powerful, native client for MySQL, MariaDB, Amazon Aurora, PostgreSQL, SQL Server, Oracle, ClickHouse and Redis, 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. A DuckDB editor opens .duckdb files and queries Parquet, CSV or JSON where they already are. Plus a read-only previewer for .md, .sql, .json, .csv, .rtf and .log files. All 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

Manage your databases on the go — like a pro. MagicSQL is the first mobile SQL client that brings together MySQL, PostgreSQL, MS SQL Server, MariaDB and SQLite with SSH tunneling, a full-featured editor and a multi-tab interface. Not a stripped-down viewer — a real professional tool for your phone and tablet. ▸ FIVE DATABASES, ONE INTERFACE MySQL · MariaDB · PostgreSQL · MS SQL Server · SQLite Switch between servers without leaving the app. ▸ CONNECT SECURELY - SSH tunneling with password OR private key - SSL/TLS encryption - Live status: green dot + ping time in ms show instantly which servers are reachable - Connection test with clear diagnostics: SSH, DB, or network errors are reported separately ▸ MULTI-TAB DATA BROWSER - Open multiple tables simultaneously in tabs — like on the desktop - Split View: compare two tables side by side - Inline cell editing with double-tap - Column filters, full-text search, pagination - Duplicate, delete, or export rows as JSON - Column sorting and adjustable column widths ▸ PRO SQL EDITOR - Syntax highlighting for keywords, strings, numbers, comments - Context-aware autocomplete (knows your tables and columns) - Live error detection with wavy-underline markers - Snippet toolbar for common statements - Query history with copy & re-run ▸ TABLE DESIGNER WITHOUT SQL Create tables visually with every professional property included: - Primary key, Auto-Increment, Unique - UNSIGNED for numeric types (MySQL) - ON UPDATE CURRENT_TIMESTAMP for updated_at columns - Default value with quick picks: NULL, NOW(), 0, '', UUID() - Comment, charset, collation, engine ▸ VIEWS, FUNCTIONS AND TRIGGERS Beginner-friendly builders with templates, or full SQL code control. Create views, stored functions and triggers without spending hours in the docs. ▸ USER MANAGEMENT Create MySQL users and assign privileges through three clear tabs: Account, Privileges, Password. ▸ AUTO-RECONNECT App went to background? No problem. MagicSQL keeps the connection alive with keep-alive pings and reconnects automatically when needed — no data loss, no need to re-enter anything. ▸ DARK THEME, CODING FONT Eye-friendly design with a professional monospaced font built for code. No distracting animations, no ads, no tracking — just tools that work. ▸ WHAT MAKES MAGICSQL DIFFERENT? Other mobile SQL apps often just display data. MagicSQL is a real mobile IDE: SSH tunneling for secure remote connections, multiple tables in tabs at once, an editor with live assistance, a visual designer — and all of it for five database systems. Optimized for fast thumb input, uncompromising on professional features. ▸ PRIVACY Your server credentials stay exclusively on your device. No cloud, no tracking, no ads. MagicSQL talks directly to your servers — nothing goes through third parties. ▸ SETTINGS Adapt to your workflow: connection timeout, keep-alive, auto-reconnect, default row limit, text size, NULL highlighting, syntax highlighting, query history, destructive-action confirmation — everything is respected. For developers, DBAs, DevOps and anyone who wants their databases under control everywhere. Download MagicSQL and work like a pro — from your couch, on the train, or in the server room.