DB Monitor

Active Monitors

–

DB Connections

–

Alerts (24h)

–

Failed (24h)

–

Query Monitors

Name	Purpose	Connection	Cron Schedule	Type	Status	Actions
Loading…

Credentials Manager

Alert History

Monitor	Triggered At	Rows	Status	Webhook	Query
Loading…

📋

Add Monitor

Name

Purpose

Database Connection

SQL Query

Date placeholders: {{today}} {{yesterday}} {{tomorrow}} {{first_of_month}} {{last_of_month}} {{now}} {{days_ago:N}} {{days_ahead:N}} {{months_ago:N}} {{year}} {{month}} {{day}}

Cron Schedule

min hour day month weekday — e.g. 0 8 * * 1-5 = weekdays 8 AM

Webhook URL override (optional)

Mattermost / Slack incoming webhook URL, or any HTTP endpoint

Alert Email To (optional)

Comma-separated recipients — requires SMTP settings in .env

Monitor Type

Truth: fires whenever the query returns ≥1 row.
Trend: extracts a numeric value each run and fires on statistical anomaly.
Assertion: checks a column value against an expected value, or compares scalar results from two queries and fires when they don't match.

📈 Trend / Anomaly Settings

Detection Method

Value Column (optional)

Name of the numeric column, e.g. cnt or total

Threshold

z-score units

Window (snapshots)

How many past snapshots form the baseline

Min Samples

Snapshots to collect before alerting starts

Alert Direction

✅ Assertion Settings

Assertion Mode

Alert fires when the column value meets the condition you define.

Column to Check

Column name to extract from the first result row

Expected Value

Value to compare against (auto-cast to column's type)

Operator — Alert fires when: actual value [operator] expected

Example: column=is_active operator== expected=false → alert when pipeline is inactive

Primary Column

Column to extract from the primary query above

Secondary Connection

DB connection for the secondary query (leave blank to reuse primary)

Secondary Query

The query whose result will be compared against the primary. Supports {{date}} placeholders.

Secondary Column

Column to extract from secondary result (defaults to primary column)

Tolerance

Max allowed numeric difference before alerting (0 = exact match)

Active

🔑

Add Database Connection

Display Name

Database Type

Host

Port

Username

Password

Database / Schema Name

🔍

Rendered Query Preview

Date placeholders resolved to today's values — query is not executed.

📈

Trend History

#	Captured At	Value	Context