Twenty-nine tools, one workspace.

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.

Dashboard

Live server pulse: connections, queries per second, cache 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, and restore from a .sql or .sql.gz file. Scheduler (daily, weekly, weekdays, monthly or every N hours) with retention rules, on-demand presets 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, ANALYZE and CHECKSUM across a multi-selection on MySQL and MariaDB; on PostgreSQL, ANALYZE and VACUUM + REINDEX; on SQL Server, UPDATE STATISTICS, DBCC CHECKTABLE and index rebuilds; on ClickHouse, CHECK TABLE and OPTIMIZE, whole table or one partition; on Oracle Database, statistics through DBMS_STATS — with progress and per-table error reporting.

Data migration

Copy tables, views, triggers, events and stored procedures to another server, or into another database on the same one — 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

Replica state, replication lag and binlog coordinates, refreshed in real time — spot a stalled replica and read its error 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 the Mac, iPad, iPhone or Apple Vision Pro.

Snippets

Reusable SQL library grouped by engine (MariaDB / MySQL / TiDB / PostgreSQL / SQL Server / ClickHouse / Oracle Database) with one-shot seeding of built-in defaults per engine. Categorized, searchable and, with iCloud sync on, synced across every Mac, iPad, iPhone and Apple Vision Pro 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

A history of your servers’ metrics —connections, queries per second, cache hit rate, running statements, network and DML— kept on a server you choose and collected in the background while Calíope is open.

SQLite Editor

Open and edit local SQLite files with no server: structure designer, data grid, Execute SQL with highlighting and autocompletion, editable pragmas, Save/Revert transactions and CSV/JSON/SQL import-export. Unencrypted databases only.

Download the sample database — 80 MB of SQLite: two related tables, about 1,500 products and their real PNG photos, with indexes, a foreign key and a view. The text is in Spanish, with accents, emoji and other alphabets, and some values are deliberately NULL.

DuckDB Editor

Open local DuckDB files with no server: schema tree with sequences, types and macros, data grid, Execute SQL with row cap and Stop, settings, CSV/Parquet/JSON query over files in place, whole-database export and import, and attaching another database read-only.

Download the sample database — 3.8 MB, made with Calíope on DuckDB v1.5.5: a small shop with customers, products, 50,000 orders and their lines, plus a view, an index, a sequence, an ENUM, two macros and a second schema. With Calíope installed, select it in the Finder and press the space bar: its tables and first rows, without opening the app (Quick Look).

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, by hand or on a schedule.

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.

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.

Key browser

Browse keys by prefix with their type and TTL, and open each one to see its value.

Server panel

Memory, hit rate, expired keys, clients and operations per second, with persistence and pub/sub.

Memory analyzer

Walks every key, with a brake, and adds up the memory each prefix uses.

Slow commands

The commands the server recorded for going over its threshold, with the two settings that govern the log.

Connected clients

Every connection open on the server, what it is doing, and the option to disconnect it.

Command console

Send a command to the server and see its response; the dangerous ones are refused.

Node topology

Each node’s role, its replication lag in bytes and, in a cluster, which slots it serves.