This page describes Calíope 1.5, the version we are building right now. 1.4 is finished and in App Review, and the store serves 1.3 on the Mac and 1.2 on iPad. The changelog says which version each feature landed in.
Adds an “Open in Calíope” button to every topic. It only works with the app installed.
The schema panel, on the right-hand side of the SQL Editor, displays the schema tree; show or hide it with the sidebar button in the editor toolbar. Click the arrow next to a database to expand it and view its tables. Calíope lists all databases on the server, including the system ones (information_schema, performance_schema, mysql, sys) — Calíope is a DBA-first app and those are legitimate introspection sources.
Click the Refresh button (circular arrow icon) in the panel header to reload the list from the server.
Click on a table name in the schema tree. Calíope automatically generates a SELECT * FROM \db\.\table\LIMIT 50 and loads it in the active SQL Editor tab (or opens a new tab if none is active).
Keywords: preview, select, quick select, view table, table data
Filter tables by name in the Workspace sidebar panel.
Where it is: Sidebar › Schema tree › Search
The schema tree panel includes a filter field in its header, and it is the same in every tool that shows the schema. Type part of a name to narrow the list: the filter matches database names and object names at once, and if the database name matches, all of its objects are shown.
The filter waits a moment after your last keystroke before applying, so typing continuously does not reshuffle the list on every key. Clearing it restores the databases you had expanded before filtering.
Each database is queried the first time you expand it, so the filter cannot find what has not been fetched yet. When databases remain unexplored, the footer shows how many and offers a Search all button that loads them in order so the connection is not overwhelmed.
macOS: the field sits at the top of the panel; Escape clears it. iPad: the field is always visible in the same place, and pulling down reloads the tree.
Identical filtering, on-demand loading and context menus across every tool that shows the schema.
Where it is: Sidebar › Schema tree
Calíope draws the same tree of databases and objects in every tool that needs one: the SQL Editor, Backup, Object Migration, Table Maintenance and the Query Builder. They are not merely similar — it is the same component, so what you learn in one tool applies everywhere.
What you always get
- Filter by name in the panel header. It matches database names and object names at once; if the database name matches, all of its objects are shown. It waits a moment after your last keystroke before applying, and clearing it restores the databases you had expanded.
- Unexplored databases notice. Each database is queried the first time you expand it, so a filter cannot find what has not been fetched yet. When that happens, the footer tells you how many databases are missing and offers a Search all button that loads them.
- Context menu with copy name, copy fully qualified name and reload. Each tool adds its own entries: the SQL Editor, for instance, adds SELECT * FROM, data import and the WHERE builder.
What changes per tool
- What you can select. In the SQL Editor and the Query Builder you tap an object to use it. Backup, Migration and Maintenance use checkboxes: the database checkbox selects or clears everything under it, and to its right you see how many objects are selected out of the total.
- What is shown. Maintenance lists tables only (a REPAIR does not apply to a view), the SQL Editor lists tables and views, and Backup and Migration list all five kinds grouped into sections.
- When it loads. Backup fetches the whole catalog on open, because it needs the count and the estimated size before you touch anything. The rest load each database as you expand it.
Access quick actions on a database from the schema tree.
Where it is: Schema tree › right-click › Database
Right-click (macOS) or long press (iPad) on a database name in the schema tree to open the context menu with the following options:
- Use as active database — switches the session context to this database (equivalent to USE db_name).
- Refresh tables — reloads the table list for this database from the server.
- Refresh database list — reloads all databases in the tree.
- Copy database name — copies the name to the clipboard.
- Create table — opens the Table Builder to create a new table in this database.
iPad: pull down (pull-to-refresh) in the panel to refresh the entire database list.
Keywords: context menu, database, use database, create table, refresh, copy name, USE, pull to refresh
Access quick actions on a table from the schema tree.
Where it is: Schema tree › right-click › Table
Right-click (macOS) or long press (iPad) on a table name in the schema tree to open the context menu with:
- SELECT * FROM table — generates a SELECT * FROMdb.tableLIMIT 50 and loads it in the SQL editor.
- Refresh tables — reloads the table list for the database containing this table.
- Copy table name — copies only the table name to the clipboard.
- Copy full name — copies the full reference in db.table format to the clipboard.
- Import data… — opens the import wizard to load data from a CSV, JSON, or Excel (.xlsx) file directly into this table.
- Build WHERE… — opens the WHERE Builder to create visual filters for this table without writing SQL.
Where it is: Schema Tree › right-click › Build WHERE…
The WHERE Builder lets you construct filter conditions for a table without writing SQL manually.
How to activate it: in the schema tree, open the context menu on any table — right-click on macOS, press and hold on iPad — and select Build WHERE…
Using the builder:
1. Choose a column from the dropdown.
2. Select the operator: =, !=, >, <, >=, <=, LIKE, NOT LIKE, IS NULL, IS NOT NULL, IN, NOT IN, BETWEEN.
3. Enter the value (or both values if using BETWEEN).
4. Click + to add another condition, combined with AND or OR.
Available actions:
- Copy WHERE — copies only the WHERE clause to the clipboard to paste into the editor.
- Run SELECT — generates and runs SELECT * FROM table WHERE … directly.
The panel shows a live SQL preview as you add conditions.
Keywords: WHERE, builder, filter, condition, LIKE, BETWEEN, IN, IS NULL, no SQL, visual filter
Automatic log of all schema changes (CREATE, ALTER, DROP) executed from Calíope.
Where it is: Sidebar › Schema tree → DDL History
The DDL history automatically captures every successful data definition statement you execute from the SQL editor: CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE VIEW, DROP INDEX, etc.
Unlike the general query log, the DDL history is a semantic record of structural changes, useful for auditing and tracking changes to the database schema.
How to access:
In the left sidebar of the Workspace, click the DDL History button (clock with checkmark icon) in the top bar of the schema tree. The viewer opens as a sheet over the workspace.
Features:
- Search — filter by text within statements or by connection name.
- Copy statement — click the copy button to the right of any entry to copy it to the clipboard.
- Clear history — the trash button in the top bar deletes all entries. A confirmation dialog is shown before deleting.
Information recorded per entry:
- Execution date and time.
- Connection name (server profile).
- Full DDL statement.
The DDL history is stored locally in SQLite3 (alongside the general query log) and has no size limit; clear it manually whenever you see fit.