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.
Splits the editor's SQL into individual statements for management.
Where it is: SQL Editor › SQL Statements
With SQL in the Editor, click the SQL Statements button in the toolbar. The Statement Manager opens, splitting the script by semicolons and displaying each statement with its order number, type (SELECT, INSERT, UPDATE, etc.), and a color-coded icon.
Use the search field (minimum 2 characters) to filter specific statements.
Each statement type has a distinctive icon and color.
The Manager uses visual encoding: cyan for SELECT/SHOW/DESCRIBE/EXPLAIN, green for INSERT, orange for UPDATE, red for DELETE/DROP/TRUNCATE, purple for CREATE/ALTER, and yellow for BEGIN/COMMIT/ROLLBACK.
Where it is: Statement Manager › right-click › Copy / Load / Delete
Open the context menu on a statement — right-click on macOS, press and hold on iPad —: Copy Statement (copies to clipboard), Load in Editor (replaces the editor content and closes the manager), and Remove from List (removes that statement from the manager without affecting the original editor content).
Double-clicking a statement copies it to the clipboard and closes the manager. On iPad a single tap is enough: it is the same primary action of the list, so there is no need to tap twice.
Execute a SQL script step by step with playback controls.
Where it is: SQL Editor › SQL Player
The SQL Player lets you execute the statements of a script in a controlled manner, one at a time, with transport controls similar to a media player.
How to open it: in the SQL Editor, click the SQL Player button (player icon) in the toolbar or in the editor options menu.
Available controls:
- |< (first) — jumps to the first statement in the script.
- < (previous) — moves back to the previous statement without executing it.
- ► (play) — starts automatic playback, executing each statement at the configured interval.
- ❚❚ (pause) — pauses automatic playback at the current statement.
- > (next) — advances and executes the next statement.
- >| (last) — jumps to the last statement.
- ■ (stop) — stops playback and resets to the beginning.
Interval: configure the time in seconds between automatic executions in the interval field.
Status panel: shows the current statement highlighted in the list, the executed/error statement counter, and elapsed time.
Useful for migration or data loading scripts where you need to verify the result of each statement before proceeding to the next.
Available on macOS, iPad and iPhone.
Keywords: sql player, step by step, play, pause, script, interval, transport, execute one by one, iPad