ClickHouse

We're heading to @aiDotEngineer NYC, Oct 12-14 🗽 Find us at booth 9, plus: 🛠️ Mon 2:20 PM ET: Hands-on Langfuse workshop: The AI engineering loop end to end 🎤 Wed 2:55 PM ET: Building Deployment Gates for AI Agents in Financial Services Details 👇 buff.ly/qTp89bd

Here’s what’s new in ClickHouse Managed Postgres: clickhouse.com/blog/managed...

Congrats to Huntress Labs for reaching $250 million in ARR. clickhouse.com/blog/how-hun...

ClickHouse Managed Postgres uses WAL-aware backpressure to prevent a WAL backlog from filling the disk and triggering a PANIC. clickhouse.com/blog/wal-bac... Client writes slow while the archiver drains at full speed. When the backlog clears, the cap lifts automatically.

How do you know an MCP server actually makes SRE agents better? 🎯 clickhouse.com/blog/benchma...

We rebuilt ClickHouse Cloud's autoscaling orchestration with controller-runtime and a ClickHouse-powered signals table, to support reactive, near real-time scaling recommendations. How it works: clickhouse.com/blog/making-...

Welcome to ClickHouse, @andypavlo.bsky.social 👋 clickhouse.com/blog/andy-pa...

Alexey Milovidov brought 110 database systems online in one playground. Go play 👉 clickhouse.com/blog/clickbe...

clickhousectl v0.4.0 is out. Update now with: clickhousectl update

ClickHouse is your observability store, but what do you put on top to work with the data?

What does a coding agent need to build real infrastructure?

@clickhouse/rowbinary is a Node.js reader and writer for ClickHouse's RowBinary format that doubles as an Agent Skill.

ClickHouse now embeds its documentation so you don't need to leave the client to get help. clickhou.se/4y3UQrb

Can you render ray tracing inside your database? If you use ClickHouse, you can! This video was rendered entirely inside ClickHouse. clickhou.se/4v9Ljfx

ClickHouse is known for its developer experience; but how do we extend that into the agentic era? Al Brown shares what we've been learning as we start to design for agents as a primary user. clickhou.se/3Rb9pZ8

Tsvetan spent 6 months hunting real bugs with AI in the loop, and wrote an honest account of what that actually takes. Will Mythos arrive and take the human out of the loop? clickhou.se/4ahA6lu

What 10 years of building in the open has produced: - 200+ integrations - Supporting open standards: OpenTelemetry, MCP, Iceberg, Delta Lake - dbt, Airflow, Grafana, Fivetran, PeerDB, and hundreds more - ClickStack, Langfuse, LibreChat building on top of ClickHouse clickhou.se/4ebNji0

10 years of ClickHouse open source. 🎉 2,600+ contributors. ~239k commits. Hundreds of millions of downloads. To everyone who built this with us: thank you. The journey's only just begun. clickhou.se/4vRpPVe

How do you monitor an SLA on a user-facing dashboard query? Tag queries with log_comment='frontend-dashboard'. Track p99 in system.query_log. When it breaches: concurrency problem → add replicas. Data growth → bigger replicas. clickhousectl lets an agent drive the whole loop. clickhou.se/4e7atF6

clickhousectl v0.2.0 is out, bringing support for Postgres and ClickPipes. Your agents can now scaffold a full transactional + analytical stack locally, iterate against it, and push to Cloud when it's ready for prod. clickhou.se/4wLzu16

New guide up: getting started with clickhousectl. A full walkthrough from zero to a working ClickHouse project: clickhou.se/3Qd8ff0

Introducing clickhousectl: the official CLI for ClickHouse. Now in beta. You can use the CLI for local development and operating ClickHouse Cloud: manage versions, run local servers, and control your cloud services from the same interface. clickhou.se/41qoA2h

Your revenue metric is defined in a dashboard query, a chat prompt, an API endpoint, and an MCP tool. Are they all calculating the same thing? clickhou.se/3NClncu

LLMs are smart. Sometimes, too smart. They can reach for advanced features before you've even run a single query. We wrote up the most common mistakes we see when AI generates ClickHouse schemas, drawn from real patterns across dozens of customer engagements:

Bangalore, we’re back! 🚀 Join us for another exciting ClickHouse Bangalore User Group meetup as we dive into building scalable, real-time analytics in the cloud. 📍 Awfis Mantri Commerce, Bannerghatta Road 🗓️ 14th March 2026, 10:30 AM onwards Spots are limited —

The Agentic Data Stack is an open-source, composable architecture for agentic analytics. Runs on a laptop, scales to thousands of agents. Three layers, all open source:

Every database has its own mental model, and ClickHouse is no different. We wrote up 13 common mistakes we see when teams are getting started, and how to avoid them.

ClickHouse now has an official plugin on the Cursor Marketplace 🎉 The plugin packages the ClickHouse Agent Skills with 28 best-practice rules, and the ClickHouse MCP server for querying your database directly from the editor. clickhou.se/4sbByfJ

Agentic analytics has changed the warehouse contract. Amy Chen walks through how to set up ClickHouse Cloud for AI agents. clickhou.se/4kTxCxI

Our top priority building Postgres managed by ClickHouse is delivering an always-available, reliable, and operationally observable managed Postgres offering. Here's what we've shipped so far:

We benchmarked three ways to migrate a 1TB table from Postgres to Postgres. Postgres managed by ClickHouse launched in January, and the most common question is: how can I migrate my large, existing Postgres without downtime?

pg_clickhouse is the fastest PostgreSQL extension on ClickBench. We built pg_clickhouse to let you query ClickHouse directly from Postgres. Rather than shoehorn analytics into Postgres, pg_clickhouse pushes down full query execution to ClickHouse. clickhou.se/4qM2v8u

Postgres + ClickHouse is becoming the default architecture for applications that need both transactional and analytical workloads. With Postgres managed by ClickHouse, the two run side by side from day one. But migrating existing analytical workloads off Postgres isn't trivial. clickhou.se/4alI7pT

We're open sourcing pg_stat_ch, a PostgreSQL extension that turns every query execution into a structured event and streams it to ClickHouse. Kaushik Iska walks through how it works under the hood: clickhou.se/4rQ8VEG 🐘 It's Postgres Week at ClickHouse 🐘 Today through Feb 20th

Say hello to clickhouse.build - the open source, agentic CLI that helps you add ClickHouse to your existing Postgres-backed TypeScript application. clickhou.se/4pgZSvB

Can you 4x OTel thoughput with Rust? Meet Rotel: pushing 460K spans/sec/core (vs 130k) How? By diving deep into Rust's threading model, resolving allocator lock contention, and reengineering JSON serialization with RowBinary encoding to stream data efficiently into ClickHouse.

Shout out to Todd Stoffel for this independent analytics benchmark 👏 While we love seeing ClickHouse top the charts, benchmarks always leave us with one thought: could we be even faster? clickhou.se/4oEQktn

58x faster and 3,300x less memory 🤯 ClickHouse v25.8 makes analytics over complex JSON better than ever. Pavel explains how the new JSON type serialisation formats work 👇

The ClickHouse JSON type was already fast, but v25.8 made it 58x faster and use 3,300x less memory. The problem: JSON docs with 10,000+ unique paths killed performance. The solution → clickhou.se/48iNcPb 200k rows, 10k paths: ⚡ 3.63s → 0.063s 💾 12.53 GiB → 3.89 MiB

🚀 What's New in ClickStack – Sept '25 clickhou.se/4gOrZ1H This release brings: • Import/export dashboards • Custom OTel Collector config • Custom aggregations (full CH power 💪) • Time-window chunking + delta() functions

When ProcessOut needed a faster, leaner way to power billions of payment transactions, they turned to ClickHouse Cloud ⚡️ Read how switching from Elasticsearch to ClickHouse cut costs by two-thirds and shrunk latency from minutes to seconds 👇