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.
Complete history of executed queries with timing and status.
Where it is: Workspace › Tools › SQL Log
Open the Query Log from the workspace navigation bar. It displays all queries from the current and past sessions, along with their session ID, timestamp, execution time, and status (OK/Error).
Keywords: log, history, queries, query log, record
Show only queries from a specific session.
Where it is: Query Log › Session selector
The Session picker in the Log toolbar lets you filter by connection session. Each time you connect to the server, a unique session ID is generated. Choose All sessions to view the complete history or select a specific session.
Keywords: session, filter, ID, connection session
Filter log entries by query text.
Where it is: Query Log › Search
Type at least 2 characters in the search field in the Log toolbar. The text filter is cumulative with the session filter: both are applied simultaneously.
Keywords: search, filter, text, query, find
Show only queries from a specific connection profile.
Where it is: Query Log › Connection selector
The second picker in the Log toolbar filters entries by connection profile. Choose the server or profile name from the dropdown to see only the queries executed in that context. Select All connections to view the complete history.
Keywords: connection, filter, profile, server, connection filter
Show only successful queries or only those that produced an error.
Where it is: Query Log › OK / Error selector
The third picker in the Log toolbar filters by execution status: All, OK (successful queries only), or Error (failed queries only). Combine it with the session filter and the text search to quickly narrow down the relevant entries.
Keywords: error, ok, status, filter result, success, failure
Reload log entries from local storage.
Where it is: Query Log › Reload button
Tap the reload button (circular arrow icon) in the Log toolbar to force a manual refresh. Useful when the log does not reflect queries executed in another tab or in a recent session.
Keywords: refresh, reload, update, log, manual
Copy the result of a logged query to the clipboard.
Where it is: Query Log › right-click › Copy result
Open the context menu on any entry in the Query Log — right-click on macOS, press and hold on iPad — and select Copy result. The result (response text or error message) is copied to the clipboard without needing to re-run the query.
Keywords: copy, result, clipboard, log, context menu
Permanently delete all entries from the SQLite log.
Where it is: Query Log › Purge / Clear
The persistent log is stored in a local SQLite database (query_log.db) in the application support directory. To delete everything, use either of these two methods:
- Red "Clear" button in the top filter bar.
- "Purge" button in the file info bar at the bottom of the view.
In both cases Calíope shows a confirmation dialog before deleting. The operation removes all rows from the executedqueries table; it does not affect the in-memory session history or the DDL audit log.
This action cannot be undone.
Keywords: clear, purge, delete, remove, log, sqlite, wipe
Check the location of the query_log.db file and how much space it uses.
Where it is: Query Log › File bar (footer)
The bottom bar of the Persistent Log always shows:
- Full path of the query_log.db file (app support directory).
- Size in B, KB, MB, or GB as appropriate, updated each time the log is reloaded.
On macOS — tap Show in Finder to open Finder with the file selected. From there you can make a manual backup or move it.
On iPad — tap Copy path to copy the path to the clipboard.
The typical path on macOS is:
~/Library/Application Support/Caliope/query_log.db
Keywords: path, size, finder, query_log.db, file, location, mb, gb
Share your query history between Mac, iPad and iPhone via iCloud.
Where it is: Query Log › iCloud sync button
The cloud icon in the upper-right corner of the Query Log controls synchronisation with iCloud CloudKit. The feature is disabled by default and is entirely optional.
Enabling synchronisation
Tap the cloud icon (grey outline) to enable it. Calíope will ask you:
- Upload existing history — uploads all current local entries to iCloud.
- New entries only — starts syncing from now without uploading previous history.
From that point on, every executed query is saved simultaneously to the local database and to iCloud. The result field is stored with a maximum of 500 characters.
Disabling synchronisation
Tap the filled (blue) cloud icon to disable it. Calíope will ask you:
- Download history from iCloud — downloads all iCloud entries to the current device.
- No, just disable — disables sync without touching local data.
Status indicators
| Icon | Meaning |
|---|---|
| Grey cloud (outline) | Sync disabled |
| Filled blue cloud | Sync active, up to date |
| Loading indicator | Synchronisation in progress |
| Red crossed-out cloud | Sync error (hover to see details) |
Retention
The same retention policy configured for the local log (default 90 days) is automatically applied to iCloud records once a day. This keeps both stores aligned to the same time horizon.
Privacy
Data is stored in your personal iCloud account (CloudKit private database), invisible to other users and to Apple.
Keywords: icloud, sync, synchronise, cloudkit, cloud, history, share, ipad, mac
What to do when the cloud icon appears in red.
Where it is: Query Log › Red cloud button
When the sync icon appears crossed out in red, tap it to see the error details and available options:
- Retry — attempts synchronisation again. Use this if the error was temporary (no network, iCloud down).
- Disable sync — disables synchronisation without downloading data. Local history is not modified.
Common causes and solutions:
| Error | Cause | Solution |
|---|---|---|
| "You are not signed in to iCloud" | The iCloud account is not active | Open System Settings → Apple Account |
| "iCloud temporarily unavailable" | Apple servers are down or no network coverage | Wait a few minutes and tap Retry |
| "Account restrictions" | Parental controls or MDM blocking CloudKit | Contact your device administrator |
| "Could not verify status" | No internet connection at launch | Check network and tap Retry |
Note: The iCloud account status is verified automatically when the app opens. If the problem is resolved (e.g. you connect to the internet), the icon will return to blue after the next query is executed.
Keywords: error, icloud, sync, red, retry, unavailable, account, troubleshoot
Calíope sends a notification when iCloud log sync fails silently.
Where it is: Calíope › Preferences › Notifications
If the iCloud sync of the query history fails (no connection, full quota, account unavailable), Calíope can alert you with a local notification so you don't lose records without knowing it.
Covered scenarios:
- No Internet connection at sync time.
- iCloud quota exceeded — the notification uses a specific message indicating storage is full.
- iCloud account temporarily unavailable.
Enable or disable:
Go to Preferences › Notifications and use the iCloud sync failure toggle. This toggle only appears when iCloud log sync is enabled in Preferences.
The cooldown between notifications is 15 minutes to avoid spam (sync is checked on every executed query).
Keywords: notification, icloud, sync, failure, quota, offline, alert