SQL Editor
Schema-aware autocomplete, SQL linter, formatter and multi-statement Player that runs the whole script or steps through it one query at a time.
The full inventory
Twenty-eight tools, one workspace.
These are the actual workspace tabs shipped in Calíope — not a marketing tour. Every one is native SwiftUI, works on macOS, iPad and iPhone, and opens as a dedicated tab you can pin, reorder or close. Twenty-six of them sit in the tool navigator; Table Builder and Visual EXPLAIN open in context from Catalogs and the SQL Editor. A MongoDB session brings six more, listed below.
Dashboard
Live server pulse: Threads_connected, QPS, InnoDB buffer pool hit rate, uptime and slow queries per second, polled at your chosen interval.
AI Assistant
Plain-English prompts against the active database's schema. Apple Intelligence and Ollama need no key at all; the cloud providers take your own. Only metadata leaves the app — never rows or credentials.
Catalogs
Full database → table → column tree with dedicated tabs for indexes, foreign keys, views, routines, triggers and events.
Query Builder
Visual constructor: drag tables to a canvas, pick columns and WHERE conditions, and watch the SQL preview update as you build.
Server information
Global and session variables, live status counters and HDD usage — all browseable in one panel with a filter box on top of every list.
Process list
Running threads with filters, guided KILL QUERY / KILL CONNECTION and bulk kill of idle or busy sessions — with confirmation before every destructive action.
SQL alerts
Custom health checks: define SQL probes, thresholds and operators, and get alerted when a metric crosses the line — long before your dashboard notices.
Backup
Granular selection of databases, tables, views and routines. Daily or weekly scheduler with retention rules and optional gzip compression.
User admin
Create and modify users, manage grants by scope and switch auth plugins — no more hand-writing GRANT / REVOKE by memory. Identifiers escaped end-to-end.
Table maintenance
Run CHECK, REPAIR, OPTIMIZE and ANALYZE across a multi-selection, with progress and per-table error reporting.
Data migration
Copy tables, views, triggers, events and stored procedures between two connected servers — without mysqldump | mysql.
ER Diagram
Interactive relational diagram with draggable tables, editable foreign keys and PNG / PDF export. Understand a legacy schema in thirty seconds.
Schema diff
Compare two schemas side by side and generate the ALTER script that reconciles them. Sync staging with production without hand-writing migrations.
Replication monitor
Master / replica state, replication lag and binlog coordinates, refreshed in real time — spot a stalled slave without SSHing into the box.
Binlog viewer
Read and filter binary log events without shelling into the server. Follow row-level changes, transactions and GTIDs from macOS or iPad.
Snippets
Reusable SQL library grouped by engine (MariaDB / MySQL / PostgreSQL) with one-shot seeding of built-in defaults per engine. Categorized, searchable, and synced across every Mac, iPad and iPhone on your Apple ID.
Query log
Persistent history of every executed query in local SQLite — searchable, filterable, exportable, and with opt-in iCloud sync.
Server health monitor
Configurable alerts on server metrics — Calíope pings you before your external monitoring does. Runs in the background across sessions.
SQLite Editor
Open and edit local SQLite files with no server: structure designer, data grid, Execute SQL, editable pragmas, Save/Revert transactions and CSV/JSON/SQL import-export. Unencrypted databases only.
File Previewer
Read-only viewer for .md, .sql, .json, .csv, .rtf and .log: rendered Markdown, highlighted SQL, re-indented JSON, CSV as a table, RTF as a document. Refreshes when the file changes on disk — and never runs anything.
Error log
What has gone wrong in the app, with its date, its device and what to do about it. Works offline.
Global search and replace
Find text across every text column of a database and replace it in bulk, seeing how each row will look before anything is written.
Reports
Save a query with its parameters and a defined output. The same report gives the same result, run after run — and the last one travels to your phone.
Replication topology
Declare which machine is the primary and which are the replicas, and see the whole group at once: binlog and position up top, and a row per replica with its lag, its two threads and its GTID drift.
Slow query log
What the server itself recorded about the queries that went over its threshold — from every client, not just this one. The settings up front, because a log that is off has nothing to show and an empty list does not say which of the two it is.
Two more contextual tools — Table Builder (visual create/alter) and Visual EXPLAIN (query plan viewer) — open in-line from Catalogs and the SQL Editor.
Document databases
And six more, when the session is MongoDB.
A MongoDB connection opens its own set of tabs — there is no SQL editor, no ER diagram and no binlog in a document database, so pretending otherwise would only produce empty screens. Every value shows its type, because in a schemaless collection two neighbouring documents may share no field at all.
MongoDB collections
Browse databases, collections and documents, and edit them as JSON.
MongoDB query
Filter documents or run an aggregation pipeline.
MongoDB indexes
Inspect, create and drop a collection’s indexes.
MongoDB server
Server status, running operations, users and roles.
MongoDB commands
Send a command to the server and see its response.
MongoDB profiler
Which operations the server recorded for crossing the threshold, and what level each database’s profiler is at.