ClickHouse Blog

Explore ClickHouse AI Functions for classification, generation, translation, embeddings, semantic search, and cost controls—all directly from SQL.

WalShadow replicates Postgres data directly from physical WAL into ClickHouse, delivering around 200 ms latency and 289,000 rows per second in benchmarks.

ClickHouse joins the Data agent in ChatGPT Work, connecting ClickHouse Cloud to natural-language queries, reports, and interactive dashboards.

ClickHouse On-Demand Compute lets you scale individual queries with additional workers, run intensive workloads without disrupting production, and use compute when you need it.

ClickHouse 26.8 LTS introduces background queries, pipelined SQL, new text tokenizers, expanded data lake integrations, and faster Parquet, aggregation, and join queries.

Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.

ClickHouse Managed Postgres is expanding to Google Cloud, bringing NVMe-backed storage, native CDC into ClickHouse, and a unified query layer via pg_clickhouse to GCP private preview customers.

ClickHouse Cloud delivered 412× better performance per dollar than Snowflake in CostBench. We trace the gap from fresh data arriving to fast answers coming back.

The chdb Postgres extension brings fast imports and exports across cloud storage platforms and data formats, powered by the embedded ClickHouse engine.

CostBench puts cloud data warehouses under continuous load. Across the complete path from fresh data to fast answers, ClickHouse Cloud delivers 412–1,996× better performance per dollar.

Google's MCP Toolbox for Databases embeds agent text into vectors on insert and search, then lets ClickHouse rank the results - no embedding service to build or maintain. Here's how to set it up, and what it looks like end to end.

Learn how to build a streaming HTTP API directly in ClickHouse 26.8 with named handlers, typed parameters, pagination, framing formats, and access control.

Learn how ClickHouse 26.8’s pipelined SQL syntax lets you build multi-stage queries as a readable sequence of transformations.

ClickHouse Managed Postgres now supports scheduled upgrade windows, giving Scale and Enterprise users more control over when routine platform maintenance occurs.

Replicate MySQL and MariaDB data into ClickHouse Cloud with the generally available MySQL CDC connector, featuring faster parallel snapshots, safer production defaults, improved observability, and infrastructure-as-code support.

Three teams share why they migrated production Postgres workloads from Neon to ClickHouse Managed Postgres and how ClickPipes helped them cut over in hours.

Security is the largest and fastest growing data workload in the enterprise, and today, ClickHouse has acquired RunReveal.

We took 201 real analytics questions from our production data warehouse, benchmarked 28 models on correctness, cost, and speed, and released an open harness so you can run the same test on your own.

PostgreSQL 19 adds four system views that make lock contention, recovery state, autovacuum priorities, and dynamic shared memory allocations easier to inspect.

Uken Games replaced Datadog with an open-source observability stack built on ClickHouse, cutting costs by 87% while storing every trace on a single node.