This page describes Calíope 1.5, the version I am building right now. 1.4 is on the App Store for the Mac, iPad, iPhone, Apple Watch, Apple TV and Apple Vision Pro. 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.
Open Processes from the workspace navigation bar. The table shows all processes with columns: ID, User, Host, Database, Command, Time, State, and SQL.
Enable auto-refresh with the ▶ button and enter the interval in seconds. Use the user filter to show only processes belonging to a specific user.
With SQL Server the menu has no Kill Query and the bar does not offer to Terminate the running ones: there KILL closes the whole session, not just its query, so only the session can be ended.
Keywords: processes, threads, processlist, SHOW PROCESSLIST, active
Where it is: Process list › right-click › Kill Connection / Kill Query
Open the context menu on a process in the list — right-click on macOS, press and hold on iPad — and select Kill Connection (terminates the entire connection) or Kill Query (cancels only the active query). Both actions show a confirmation before executing.
If the server refuses — usually because the thread belongs to another user and your account lacks the privilege — a bar under the list says so: “Thread #… was not terminated:” followed by the server's reason. It is announced, and it closes with its ✕. A thread that does die says nothing: it simply leaves the list.
SQL Server
With SQL Server the menu has only Kill Connection: KILL ends the whole session and rolls back its open transaction, and the client that was running the query gets the server's answer that the session is in the kill state.
Bulk-cancel threads that have been in a given state for more than N seconds.
Where it is: Process list › Idle > / Active > · Terminate
Next to Idle > and Active > in the toolbar, type a number of seconds and click that field's Terminate button. Idle closes every connection that has been waiting longer than that; Active cancels every query that has been running longer, and leaves its connection open. Before acting, Calíope says how many threads it found and asks you to confirm.
Afterwards the same bar under the list sums it up: how many of those found were terminated and, if the server refused any, how many and the reason for the first one — for example “3 of 5 terminated; 2 rejected: …”.
MySQLMariaDBAurora
The server's own threads — replication and the event scheduler — are never included.
PostgreSQL
The server's own processes — the checkpointer, the WAL writer, the autovacuum launcher — appear in the list but are never included.
SQL Server
With SQL Server there is only Idle >: KILL closes the whole session, so a running query cannot be cancelled on its own. The server's own sessions are not even listed.