What's new in ClickStack. February '26.

The ClickStack TeamMar 12, 2026

Source: Clickhouse
Published: Mar 12, 2026
Added to Yomu: Aug 28, 2026

Summary

ClickStack introduced several platform updates and query performance enhancements across both open-source and Cloud environments for February 2026. ClickHouse Cloud OpenAPI now exposes ClickStack resources including dashboards, alerts, sources, and webhooks to support automated configuration-as-code workflows. In addition, ClickHouse 26.2 embeds the ClickStack UI directly into the database binary with a 4.1 MB footprint for local exploration and diagnostics. Visualizations now support native SQL mode for tables, allowing users to join disparate datasets like logs and traces across injected dynamic time variables. Finally, query execution speeds improve through streaming skip indexes, index pruning on disjunctions, and an expanded 100,000-row lazy materialization limit alongside new threshold alerting on number charts.

Context

Observability workflows require automated configuration-as-code options, native analytical querying across disparate data sources, and low-latency query performance on large datasets without heavy setup overhead.

Approach / What changed

ClickStack added Cloud OpenAPI support for dashboards and alerts, embedded the UI directly into ClickHouse 26.2 binaries, enabled native SQL table querying, implemented skip index pruning on disjunctions and streaming reads, increased the lazy materialization limit, and introduced threshold alerts on number charts.

Takeaways

ClickHouse 26.2 packages the ClickStack UI directly inside the ClickHouse binary with an additional 4.1 MB footprint, accessible locally at http://localhost:8123/clickstack.
Table visualizations now include a SQL mode that supports querying across multiple data sources, complex joins between logs and traces, and dynamic time window variable injection.
ClickStack raised the query_plan_max_limit_for_lazy_materialization threshold to 100,000 rows to defer column reads and optimize I/O on large log and trace result sets.

Developer Experience Monitoring Observability Open Source Performance

Read original post

What's new in ClickStack. February '26.

The ClickStack TeamMar 12, 2026

Source: Clickhouse
Published: Mar 12, 2026
Added to Yomu: Aug 28, 2026

Summary

Context

Approach / What changed

Takeaways

ClickHouse 26.2 packages the ClickStack UI directly inside the ClickHouse binary with an additional 4.1 MB footprint, accessible locally at http://localhost:8123/clickstack.
Table visualizations now include a SQL mode that supports querying across multiple data sources, complex joins between logs and traces, and dynamic time window variable injection.
ClickStack raised the query_plan_max_limit_for_lazy_materialization threshold to 100,000 rows to defer column reads and optimize I/O on large log and trace result sets.

Developer Experience Monitoring Observability Open Source Performance

Read original post

Related reading

Clickhouse · Mar 5, 2026
Introducing ClickStack embedded in ClickHouse
ClickHouse 26.2 introduces an embedded distribution of the ClickStack observability UI packaged directly inside the ClickHouse binary. Designed for local exploration and instance inspection, this distribution allows developers to visualize internal query logs, traces, and system metrics without deploying external services. To preserve build integrity and keep the added binary footprint around 4.1 to 4.2 MB, the team avoided a Node.js dependency by embedding a pre-built static Next.js application using CMake-generated C++ structs. Supporting components such as MongoDB, Express, and the Pyodide WebAssembly runtime were omitted, disabling alerting and persistent dashboards in favor of simplicity. Users can access the interface directly over HTTP to monitor local databases and query performance out of the box.
The ClickStack Team
Clickhouse · Mar 16, 2026
ClickHouse Release 26.2
ClickHouse version 26.2 introduces twenty-five new features, forty-three performance optimizations, and one hundred eighty-three bug fixes across the database engine. This release graduates both the text-index and the QBit vector embedding data type to production-ready status for search and retrieval workloads. For streaming ingestion pipelines where row arrival rates are low, the engine adds time-based block flushing configurations to write data parts before hitting default row or byte thresholds. The update also embeds the ClickStack observability user interface directly into the standard binary distribution, accessible through the local HTTP server port. Further enhancements include automatic min-max indexing for temporal columns in MergeTree tables, interactive time-based one-time password authentication in the client, and a high-performance prime number generator function.
ClickHouse
Clickhouse · Apr 14, 2026
What's new in ClickStack - March 2026
ClickStack announced several observability updates in its March 2026 release to improve root cause analysis, dashboard organization, and local development. The Event Deltas tool now displays baseline span distributions immediately, uses deterministic cityHash64 sampling for trace heatmaps, and applies proportional comparison scoring to accurately evaluate attributes across uneven sample sizes. Furthermore, users can directly include or exclude values from attribute comparison bars to streamline query creation during incident investigations. Dashboard capabilities expanded with a curated OpenTelemetry template gallery, multi-value filtering with optional lookup WHERE clauses, and broadened metric display units. Finally, local mode introduces browser localStorage persistence through createEntityStore, allowing developers to save dashboards and favorites without a running backend API.
The ClickStack Team
Clickhouse · May 13, 2026
ClickStack SQL Charting and Alerting
ClickStack introduced SQL-based visualizations and SQL-based alerting to allow users to build charts and alerts using arbitrary ClickHouse SQL queries. Traditional query builders trade analytical flexibility for simplicity, preventing teams from easily expressing multi-stage computations like rolling baselines, anomaly detection, or dynamic SLO calculations. To maintain interactivity within dashboards, the system supports ClickHouse query parameters and macros that inject active time ranges, interval sizes, dashboard filters, and source tables. Furthermore, SQL-based alerting evaluates the numeric columns output by these queries, such as returning binary flags when values exceed statistical boundaries. By shifting computational logic directly into SQL, teams can implement complex operational checks without relying on static external thresholds.
Drew Davis, Dale McDiarmid