ClickHouse Engineering Blog & Tech Articles

The ClickHouse Terraform provider now manages ClickStack dashboards, alerts, sources, and webhooks, putting observability config in version control.

ClickStack and Hud now share trace IDs, pairing service-level observability with function-level runtime forensics so coding agents can assess risky changes before they ship, catch regressions right after deploy, and fix them with real production context.

ClickHouse Grafana plugin 4.20 brings compact query mode, click-to-filter log investigation, guided variable and annotation editors, and OpenTelemetry dashboards

iFood rebuilt its in-house security platform on ClickHouse Cloud, getting 9-16x faster queries at 40-50% of the cost and unlocking agentic threat hunts that cut a week of analyst work down to two hours.

Explore ClickStack’s latest upgrades, from richer trace navigation and Prometheus connectivity to smarter dashboards, quieter alerts, faster filtering and support for exponential histogram metrics.

This release brings speedups for GROUP BY ... ORDER BY ... LIMIT, three JOIN improvements, four vector search improvements, position-aware phrase search, EXPLAIN ANALYZE, unified URL access, and more!

Physical Intelligence runs both its OLAP and OLTP workloads on ClickHouse managed Postgres and ClickHouse Cloud

How ClickHouse Managed Postgres uses WAL-aware backpressure to slow client writes, protect disk space, and let the archiver recover.

How we rebuilt ClickHouse Cloud's autoscaling orchestration on Kubernetes' controller-runtime and a ClickHouse-powered signals table, adding a reactive fast path that scales services up in seconds instead of waiting for the next scheduled pass.

You can choose any of these hundred database systems and run queries. You can create tables and databases, insert data, drop tables, etc. Every database comes with a preloaded dataset of 100 million records, so you can test example queries. It has not onl

I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.

clickhousectl v0.4.0 adds horizontal autoscaling for Cloud services, ClickPipe schema discovery, finer control over ClickPipe ingestion, and opt-out anonymous usage telemetry.

We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.

Using ClickHouse for observability and wondering which interface best fits your workflows? We explore ClickStack, Grafana, and when it makes sense to use both.

ClickHouse is joining the Open Secure AI Alliance alongside NVIDIA and other industry leaders to help build open tools that keep AI agents secure.

Treating a Gaggia espresso machine like a distributed system: instrumenting an ESP32 with OpenTelemetry, streaming shots and whole-house sensors into ClickHouse Cloud, and putting ClickStack (plus an LLM agent) on top to turn every pull into a queryable,

Why ClickHouse Managed Postgres runs strict memory overcommit by default, and how it turns an instance-wide OOM restart into a single failed query — shown side by side on identical hardware, with no measurable throughput cost.

We have relaunched clickhouse.com/docs on Mintlify, with a redesigned search and Ask AI experience, a docs MCP server, simpler navigation, an interactive API playground, and expanded localization — built for both human readers and the coding agents

ClickHouse has achieved the AWS Small and Medium Business Competency, joining a select group of AWS Partners recognized for deep expertise in real-time analytics for small and medium businesses.

A behind-the-scenes look at hdx-evals, the open-source framework we built to benchmark the ClickStack MCP server against a raw SQL baseline using deterministic synthetic incidents, sandboxed Claude agents, and blind LLM grading — and why the MCP scored hi

How a coding agent used clickhousectl to stand up a distributed ClickStack across the US, Europe, and Japan, with regional ingestion and one global view.

PostgresBench now includes HA benchmarks, comparing the performance of managed Postgres services under production-style HA configurations. This post explains the architectures behind each service and analyzes the trade-offs between availability guarantees

Recent improvements to the OpenTelemetry Collector's Datadog receiver let teams reroute telemetry from their existing Datadog agents and SDKs to ClickStack. or any OTel destination making migrations and evaluations simpler than ever.

January’s ClickStack update brings Managed ClickStack, dramatically faster text search with new indexing options, materialized view powered alerts, and a wave of usability upgrades across the stack.

Learn how to clone massive tables in ClickHouse instantly, without copying a single byte. Discover how immutable data parts and part-level copy-on-write make safe experimentation and migrations effortless.

Using ClickHouse as a webhook endpoint with HMAC verification

Search and uncover technology trends across 10 billion GitHub events in real time.

Februarys' ClickStack update brings major improvements to both Cloud and open source, including new query workflows, enhanced metrics exploration, performance optimizations, and expanded alerting options.

5 Ways to Parse Dates and DateTimes in ClickHouse

This post walks through the common pitfalls we see when AI generates ClickHouse schemas, drawn from real conversations with our Solutions Architecture team and patterns across dozens of customer engagements.

This post shows a lightweight metrics layer for ClickHouse using MooseStack, an open source developer agent harness for ClickHouse.

ClickHouse 26.2 is here! In this post, text-index and QBit data type become production-ready.

ClickHouse is fast by design, but raw database speed isn't enough. This post explores how ClickStack tightly integrates with ClickHouse to generate optimized queries — from progressive time window pagination and chunked charts to automatic use of materi

How to query datetime columns in ClickHouse - from hourly bucketing to rush hour analysis with real taxi data.

Learn how to send structured .NET logs directly to ClickHouse using Serilog — with full schema control, full-text search, and SQL queries over your log data.

High-performance full-text search, even on object storage. This deep dive from the ClickHouse engineers explains the new text index design and how it keeps queries fast at scale.

How ClickHouse Cloud's two-window recommender and target-tracking CPU algorithm cut scale-down latency from 30 hours to 3 hours while eliminating oscillations and reducing infrastructure costs.

Ten best practices for getting the most out of ClickHouse, from primary key design and data types to materialized views, ReplacingMergeTree, and join optimization — illustrated with benchmarks on a 150M row dataset.

ClickStack now supports Role-Based Access Control, giving teams precise control over who can access dashboards, searches, and notebooks. With flexible roles, fine-grained permissions, and seamless ClickHouse Cloud integration.

ClickStack gets a literary upgrade with "AI Summarize", transforming raw logs into vivid, story-driven narratives that finally explain what's really happening in your systems.

How to remain competitive in the AI era of software engineering

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

ClickHouse 26.3 is here! In this release, async inserts are turned on by default, we've got more JOIN reordering, materialized CTES have arrived, and more!

Retention limits, sampling, and metric roll-ups aren't observability best practices - they're workarounds for storage systems that can't handle full-fidelity data, and they're becoming a hard blocker for AI-driven workflows.

A Solutions Architect’s experience building a retail analytics platform with AI agents, real-time dashboards, and full observability on the ClickHouse data platform

ClickStack’s March release introduces smarter Event Deltas, AI-powered notebooks, and full SQL chart flexibility, making investigation faster and dashboards more powerful.

We see ClickHouse and Grafana as a key part of the observability experience. Here's our vision for making the plugin more powerful and easier to use.

Learn how ClickHouse uses primary indexes, lightweight projections, and skip indexes to prune data before reading it. Demonstrated on a 243 million row UK property sales dataset.

otel.fyi is a search-first site for OpenTelemetry Collector docs, making it easy to quickly find and understand configuration for receivers, processors, exporters, and extensions without digging through scattered documentation.

ClickHouse Cloud now shards indexes across replicas, turning a fixed per-node memory cost into a shared distributed resource. The result: lower memory usage, faster index analysis, and better performance for petabyte-scale workloads.