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.

SQL Alerts

SQL alerts

Watches the value returned by a query of yours and flags ALERT when it crosses the threshold you define.

Where it is: Workspace › Tools › SQL Alerts

Open SQL Alerts from the workspace navigation bar. The table lists every configured rule with its current value and an ALERT / OK indicator.

Each rule is a query of yours: Calíope runs it at the defined interval, takes the value of the column you named and compares it against the threshold with the chosen operator (>, <, =, <>). There are no predefined metrics — you decide what to watch with SQL.

Auto-refresh: press the play button and enter the interval in seconds so rules re-evaluate on their own. When a rule meets its condition its row is flagged ALERT and the view footer counts how many are active. Re-evaluation stops when you press pause or close the tab.

Load example adds a ready-made rule —active connections above 100— so you start from something that works.

This tool sends no system notifications: the warning is the flagged row while the tab is open. For warnings that do reach the system, see the Server alerts and Replication monitor topics.

Keywords: SQL alerts, alert, threshold, rule, metric, watch, auto-refresh, interval, polling, monitor

Configure alert rules

Define which query is watched and the condition that raises the alert.

Where it is: SQL Alerts › Configure

Press Configure in the tool bar. In the sheet, press + to add a rule and fill in:

- Name — how you will recognise it in the table.
- SQL — the query returning the value to watch. It should return a single row: the first one is read.
- Column — the result column holding the value. If the name matches none, the first column is used.
- Operator and Threshold — the condition that triggers the alert.

For example: SQL = SHOW STATUS WHERE Variable_name = 'Threads_connected', column = Value, operator = >, threshold = 100.

If the value is not numeric, the comparison is done as text and only = and <> make sense.

Rules are stored on this computer, apply to every open session and sync to your other devices if you have iCloud sync enabled.

Keywords: configure alert, rule, SQL, column, operator, threshold, threads_connected