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.
Version, host, data directory, character set, connection limit, and your own connection.
Where it is: Workspace › Tools › Server Information
Open Server Information from the tool sidebar. The Information tab gathers what identifies the server and your connection: version, host, port, data directory, character set and collation, maximum connections, and your connection id and user. The next four tabs list every variable and status counter, global and for your session, and HDD Usage shows how much each table takes on disk.
SQL Server
With SQL Server there is no server character set or socket, so those lines don't appear; the collation is the server's default one.
PostgreSQL
With PostgreSQL the character set is the server encoding, the collation is the connected database's, and there is no socket line.
Keywords: server info, version, uptime, replication, variables
The Global variables, Global status, Session variables and Session status tabs list every server variable and status counter with its current value. Type in the filter field in the toolbar to narrow the list: it matches the name or the value.
SQL Server
With SQL Server, Global variables are sys.configurations —what sp_configure changes, with the value in use— and the server properties, prefixed SERVERPROPERTY.; Global status holds the performance counters and sys.dm_os_sys_info; Session variables are your connection's SET options, and Session status is your session's row in sys.dm_exec_sessions.
PostgreSQL
With PostgreSQL, Global variables are all of pg_settings, with the unit next to the value; Global status adds up pg_stat_database across databases and counts connections from pg_stat_activity; Session variables lists only what your connection has changed, so it is usually empty, and Session status is your connection's row in pg_stat_activity.
Keywords: SHOW VARIABLES, SHOW STATUS, variables, status, filter
Size in MB of each database and table on the server.
Where it is: Server Information › HDD Usage Tab
The HDD Usage tab shows a table with the schema, the table, its size in MB and its rows, and the total below. Use the minimum MB filter in the toolbar to show only large tables.
MySQLMariaDBAurora
A last column gives each table's storage engine. The figures come from information_schema, so they need permissions on it, and the rows of an InnoDB table are an estimate.
SQL Server
With SQL Server it lists every database your login can open, with its schema (demo.dbo), and the size counts data and indexes. There is no storage engine column.
PostgreSQL
With PostgreSQL it lists the tables of the connected database in every schema, pg_catalog included; the size counts indexes and TOAST, and the rows are the planner's estimate: a table that has never been analyzed shows —. There is no storage engine column.
Keywords: HDD, disk, size, MB, information_schema, storage, space
Automatically refresh data and export information to a file.
Where it is: Server Information › Auto-Refresh / Export
The Server Info toolbar includes:
- Auto-refresh toggle — enable it to automatically update variable and status data at the configured interval.
- Export — saves the current data from the active tab (variables, status, or HDD usage) to a text file for sharing or archiving.
Keywords: auto-refresh, export, refresh, save variables, update