---
title: "ClickStack SQL Charting and Alerting"
url: https://daily.dev/posts/clickstack-sql-charting-and-alerting-zcnhaurp5
source_url: https://clickhouse.com/blog/clickstack-sql-charting-and-alerting
type: article
source: "ClickHouse"
published: 2026-05-18T12:53:28.754Z
updated: 2026-05-18T12:53:56.715Z
tags: ["machine-learning", "devops", "sql", "observability", "clickhouse"]
reading_time: 10
upvotes: 7
comments: 1
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickStack SQL Charting and Alerting

**[ClickHouse](https://daily.dev/sources/clickhouse)** · 10 min read · 7 upvotes · 1 comments

## Summary

ClickStack now supports SQL-based charting and alerting, allowing users to write arbitrary ClickHouse SQL queries for dashboards and alert conditions. This moves beyond predefined query builders to enable advanced observability workflows like rolling baseline anomaly detection, statistical SLO calculations, and multi-signal correlation. SQL alerts can encapsulate full alerting logic in the query itself, returning a binary 1/0 to trigger alerts rather than relying on static thresholds. Dynamic query parameters and macros (compatible with Grafana's ClickHouse plugin conventions) keep dashboards interactive. The feature integrates with existing PagerDuty and Incident.io alert integrations.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://clickhouse.com/blog/clickstack-sql-charting-and-alerting>

## Community discussion

Top comments from developers on daily.dev.

**@jamstraw** · 0 upvotes

> SQL-based alerting adds a lot more flexibility for advanced observability workflows. Really interesting update.

## Similar posts on daily.dev

- [What's new in ClickStack. October '25.](https://daily.dev/posts/what-s-new-in-clickstack-october-25--a7dpo5ddh) · ClickHouse · 1 upvotes · 0 comments
- [Alerting arrives in ClickStack for ClickHouse Cloud](https://daily.dev/posts/alerting-arrives-in-clickstack-for-clickhouse-cloud-pldpexzcq) · ClickHouse · 0 upvotes · 0 comments
- [What's new in ClickStack - April 2026](https://daily.dev/posts/what-s-new-in-clickstack---april-2026-vcftqkhl2) · ClickHouse · 3 upvotes · 0 comments

---

Tags: [#machine-learning](https://daily.dev/tags/machine-learning), [#devops](https://daily.dev/tags/devops), [#sql](https://daily.dev/tags/sql), [#observability](https://daily.dev/tags/observability), [#clickhouse](https://daily.dev/tags/clickhouse)

[View this post on daily.dev](https://daily.dev/posts/clickstack-sql-charting-and-alerting-zcnhaurp5)