Setting the file. One moment.
Skill 103 · Querying PostHog Data
Subchapter 103.31
references/models-alerts.mdMarkdown2 KBView on GitHub
Alerts monitor insight values and notify subscribed users when thresholds are breached.
| Column | Type | Nullable | Description |
|---|---|---|---|
id | String | NOT NULL | Alert UUID. |
team_id | Integer | NOT NULL | |
name | String | NOT NULL | User-given name of the alert. |
insight_id | Integer | NOT NULL | Insight the alert watches; joins to insights.id. |
enabled | Boolean | NOT NULL | Whether the alert is active. |
state | String | NOT NULL | Current alert state: ‘Firing’, ‘Not firing’, ‘Errored’, or ‘Snoozed’. |
calculation_interval | String | NOT NULL | How often the alert is evaluated, e.g. ‘daily’. |
condition | JSON | NOT NULL | JSON definition of the threshold/condition to check. |
config | JSON | NOT NULL | JSON alert configuration (series, comparison settings, etc.). |
created_at | DateTime | NOT NULL | When the alert was created. |
last_notified_at | DateTime | NOT NULL | When a notification was last sent. |
last_checked_at | DateTime | NOT NULL | When the alert was last evaluated. |
next_check_at | DateTime | NOT NULL | When the alert is next scheduled to be evaluated. |
snoozed_until | DateTime | NOT NULL | Alert is snoozed (no notifications) until this time. |
skip_weekend | Boolean | NOT NULL | Whether evaluation is skipped on weekends. |
schedule_restriction | JSON | NOT NULL | JSON restricting which days/hours the alert may fire. |
insight_id → system.insights.id)team_id)AlertSubscription (not exposed as a system table)condition.type determines evaluation mode:
absolute_value — fires when the value crosses the threshold boundsrelative_increase — fires when the value increases beyond the thresholdrelative_decrease — fires when the value decreases beyond the thresholdconfig.series_index selects which series in a multi-series insight to monitorreal_time requires a Scale or Enterprise planevery_15_minutes requires a Boost, Scale, or Enterprise add-onalert:write scope. Reconnect the MCP connection if these tools are unavailable