Summary

What it is

A column-oriented DBMS designed for real-time analytical queries, with native support for reading from and writing to S3.

Where it fits

ClickHouse occupies the performance tier above pure lakehouse queries. It can use S3 as a storage backend (S3-backed MergeTree) while maintaining its own columnar indexes for sub-second query performance — bridging the gap between S3 data lakes and dedicated analytics databases.

Misconceptions / Traps

ClickHouse with S3 storage is not the same as querying S3 directly. ClickHouse maintains local indexes and metadata for performance; it uses S3 for durability and cost.
The S3 table function (for ad-hoc S3 reads) and the S3-backed MergeTree engine (for persistent tables) are different features with different performance characteristics.

Key Connections

depends_on Apache Parquet — reads/writes Parquet for S3 interop
implements Separation of Storage and Compute — S3-backed storage with independent compute
scoped_to S3, Lakehouse

Definition

What it is

A column-oriented database management system designed for real-time analytical queries, with native support for reading from and writing to S3. The 25.x series (early 2026) added **bidirectional Iceberg read/write**, **Delta Lake INSERT** support, and native **Apache Paimon** compatibility — converting ClickHouse from a hot-tier accelerator into a first-class lakehouse engine. ClickHouse Inc. acquired **Langfuse** (LLM observability) in March 2026, planting an LLM-trace-store flag adjacent to the analytics engine.

Why it exists

Some analytical workloads require sub-second query performance on recent data, which pure S3-backed query engines cannot consistently deliver. ClickHouse uses S3 as a storage backend while maintaining its own columnar indexes for speed; with Iceberg/Delta/Paimon integration it can also serve as the query layer over an open-format lakehouse without rewriting source-of-truth data.

Primary use cases

Real-time analytics dashboards backed by S3 storage, log analytics with S3 archival, hybrid hot/cold query patterns, LLM observability stores (Langfuse), bidirectional read/write against open table formats.

Recent developments

Latest signals

Latest release: 26.6.1 (current stable, June 2026); 26.3.x is the active LTS line. ClickHouse ships frequent calendar-versioned releases with LTS designations twice a year. Per ClickHouse releases.
Vector Search GA + 9,000× faster JSON than PostgreSQL JSONB. Per ClickHouse's 2025 roundup, the v25.8 release brought vector search with binary quantization to general availability — ClickHouse joins the analytic-database-with-vector-search shape that Snowflake and Databricks reached earlier, but at OSS-engine speed. The real-time analytics database guide for 2026 reports native JSON throughput 9,000× faster than PostgreSQL JSONB on JSONBench — a real workload pattern for telemetry, event-store, and LLM-trace ingestion (the Langfuse acquisition is downstream of this number).
Automatic Global Join Reordering — TPC-H SF100 wins by ~1,450×. Per the same engineering guide, v25.09's Automatic Global Join Reordering posted a ~1,450× speedup on TPC-H SF100 vs the prior planner. v25.10 added runtime bloom filters for an additional 2.1× speedup on selective joins. The cumulative effect: ClickHouse closes the "complex JOIN performance" gap that historically pushed teams toward Snowflake or Databricks for multi-fact-table analytics.
v26.4 lands JSON skip indexes + NATURAL JOIN + parameterized Web UI queries (April 30, 2026). Per the Changelog 2026, v26.4 ships MergeTree skip index support for JSON columns (the missing piece for using native JSON as a queryable column type at scale), NATURAL JOIN syntax for terser SQL, commit_order projection index, and parameterized queries in the Web UI. chDB — the embedded ClickHouse runtime — picked up the v25.8 kernel for a reported 61× performance improvement, keeping the in-process analytical-database story competitive with DuckDB.
v26.5 (May 21, 2026) — text index GA + quantized-vector (QBit) GA + cluster-distributed vector search. Two search primitives graduated to GA in one release: the full-text (inverted) index and the QBit data type — quantized, bit-packed vector storage for approximate-nearest-neighbor that trades a controlled recall hit for large memory savings on billion-vector sets. v26.5 also lets vector search distribute across cluster replicas, so ANN scales horizontally rather than being pinned to one node. This is the query-engine convergence in miniature: an OLAP engine absorbing full-text + vector on the same Parquet/Arrow-on-S3 substrate that Doris and DuckDB are also racing to own. Per ClickHouse release 26.5 (Changelog).
Open House 2026 (May 27) — ClickHouse goes agent-native: Claude-powered Agents plus a JSON-emitting CLI. ClickHouse crossed $250M ARR / 4,000 customers and launched ClickHouse Agents into public beta — a fully managed agentic-analytics service on ClickHouse Cloud, powered by Claude, with a no-code agent builder, sandboxed code interpreter, memory, multi-agent workflows, and native MCP connectivity (built on the LibreChat platform it acquired in November 2025). Alongside it, clickhousectl (beta, April 9, 2026) makes the database operable through a single deterministic, JSON-emitting CLI and ships an agent-skills installer that pushes official ClickHouse skills into 15+ coding agents (Claude, Codex, Cursor, Windsurf). The stated thesis: a database that can't be driven end-to-end by a JSON-emitting CLI risks becoming invisible to the agentic development loop. Per ClickHouse — Open House 2026 Day 1, ClickHouse — $250M ARR + Claude-powered Agents, and Futurum — ClickHouse Builds a CLI to Make its Databases Agent-Native.