Sign in

ClickHouse

@clickhouse.com
866 followers 18 following 188 posts

ClickHouse is the fastest open-source OLAP database ⚡ Download: clickhouse.com GitHub: clickhou.se/GitHub Slack: clickhouse.com/slack

PostsRepliesMedia
ClickHouse @clickhouse.com · 06/08/2026
Here’s what’s new in ClickHouse Managed Postgres: clickhouse.com/blog/managed...
clickhouse.com
What's new in ClickHouse Managed Postgres: Customer notifications, better observability, faster backups, extensions, and more | ClickHouse
Explore the latest ClickHouse Managed Postgres updates, including proactive notifications, richer observability, faster backups, and expanded extension support.
040
ClickHouse @clickhouse.com · 05/08/2026
Congrats to Huntress Labs for reaching $250 million in ARR. clickhouse.com/blog/how-hun...
clickhouse.com
SIEM made simpler: How Huntress improved performance and slashed costs with ClickHouse | ClickHouse
By moving from Elasticsearch to ClickHouse Cloud, Huntress slashed monthly costs from $70K to $5K and scaled to handle up to 200,000 records per second.
000
ClickHouse @clickhouse.com · 05/08/2026
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.
clickhouse.com
What is WAL backpressure, and why does ClickHouse Managed Postgres need it? | ClickHouse
How ClickHouse Managed Postgres uses WAL-aware backpressure to slow client writes, protect disk space, and let the archiver recover.
111
ClickHouse @clickhouse.com · 04/08/2026
How do you know an MCP server actually makes SRE agents better? 🎯 clickhouse.com/blog/benchma...
clickhouse.com
How we build and evaluate our MCP server for SRE agents | ClickHouse
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…
020
ClickHouse @clickhouse.com · 04/08/2026
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-...
clickhouse.com
Fixed cadence to seconds: making ClickHouse Cloud autoscaling more reactive | ClickHouse
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…
000
ClickHouse @clickhouse.com · 03/08/2026
Welcome to ClickHouse, @andypavlo.bsky.social 👋 clickhouse.com/blog/andy-pa...
clickhouse.com
Andy Pavlo joins ClickHouse to establish ClickHouse Labs | ClickHouse
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
0264
ClickHouse @clickhouse.com · 03/08/2026
Alexey Milovidov brought 110 database systems online in one playground. Go play 👉 clickhouse.com/blog/clickbe...
clickhouse.com
I created a playground for 110 database systems | ClickHouse
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…
040
ClickHouse @clickhouse.com · 31/07/2026
clickhousectl v0.4.0 is out. Update now with: clickhousectl update
clickhou.se
What's new in clickhousectl v0.4.0 | ClickHouse
clickhousectl v0.4.0 adds horizontal autoscaling for Cloud services, ClickPipe schema discovery, finer control over ClickPipe ingestion, and opt-out anonymous usage telemetry.
010
ClickHouse @clickhouse.com · 30/07/2026
ClickHouse is your observability store, but what do you put on top to work with the data?
clickhou.se
Choosing Between ClickStack and Grafana for ClickHouse Observability | ClickHouse
Using ClickHouse for observability and wondering which interface best fits your workflows? We explore ClickStack, Grafana, and when it makes sense to use both.
000
ClickHouse @clickhouse.com · 22/07/2026
What does a coding agent need to build real infrastructure?
clickhou.se
Agentic infrastructure with clickhousectl: a distributed ClickStack across three continents | ClickHouse
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.
040
ClickHouse @clickhouse.com · 15/07/2026
@clickhouse/rowbinary is a Node.js reader and writer for ClickHouse's RowBinary format that doubles as an Agent Skill.
clickhou.se
@clickhouse/rowbinary: when your library is also a parser compiler | ClickHouse
We've released @clickhouse/rowbinary a Node.js reader and writer for ClickHouse's RowBinary formats. You can import it and call its generic parser like any other library. But it also ships as an…
010
ClickHouse @clickhouse.com · 07/07/2026
ClickHouse now embeds its documentation so you don't need to leave the client to get help. clickhou.se/4y3UQrb
040
ClickHouse @clickhouse.com · 30/06/2026
Can you render ray tracing inside your database? If you use ClickHouse, you can! This video was rendered entirely inside ClickHouse. clickhou.se/4v9Ljfx
030
ClickHouse @clickhouse.com · 30/06/2026
We're building Click-a-thon with some incredible companies. InMobi. Atlys. Sony LIV. These teams are bringing real-world engineering problems to the table, and 150+ developers will spend 24 hours building open-source solutions around them. That's what co-innovation looks like. 🧵 👇️
110
ClickHouse @clickhouse.com · 29/06/2026
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
clickhouse.com
Agents hate friction: early thoughts on building for agents | ClickHouse
We've had decades to learn what it means to design software and hardware for humans. How do we build experiences where the primary user may now be an LLM?
010
ClickHouse @clickhouse.com · 26/06/2026
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
clickhouse.com
How I hunt for vulnerabilities with AI | ClickHouse
I'm an experienced software engineer, but I'm not a seasoned bug bounty hunter. I used GitHub Copilot in combination with Claude Opus and Gemini models to search for vulnerabilities in the ClickHouse…
100
ClickHouse @clickhouse.com · 17/06/2026
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
clickhouse.com
The open ecosystem around ClickHouse
Around any good database sits the clients you import, the dashboards your team shares, the pipelines that feed it, the projects that build on top of it, and now the agents that query it.
020
ClickHouse @clickhouse.com · 16/06/2026
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
clickhouse.com
What a difference 10 years of open source makes
On June 15, 2016, ClickHouse went open source under the Apache 2.0 license. Ten years later, it's one of the most widely deployed analytical databases in the world.
011
ClickHouse @clickhouse.com · 05/06/2026
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
clickhouse.com
Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents
Tag queries to track per-workload SLAs, then use clickhousectl to investigate breaches and scale ClickHouse Cloud, with an agent to remediate.
010
ClickHouse @clickhouse.com · 04/06/2026
India's devs are building some of the most data-intensive systems on the planet. We want you in the room, building something real. What will you build? Click-a-thon 2026 is ClickHouse's first in-person hackathon in India. Bengaluru, August 1–2. Teams of 2 to 4. 24 hours. ₹10,00,000 prize pool. 🧵 👇️
110
ClickHouse @clickhouse.com · 02/06/2026
🚀 Build with the fastest database on the planet. Introducing Click-a-thon 2026 - ClickHouse's first in-person developer hackathon in India. 24 hours · ~120 developers · ~30 teams 📅 1–2 August 2026 · Bengaluru Pick your track: ➡️ Real-Time Analytics ➡️ Observability ➡️ Data Warehousing 🧵👇
110
ClickHouse @clickhouse.com · 29/05/2026
5 countries. 6 cities. 12 days. 1 ClickHouse 🌏 Last month, our CTO and the creator of ClickHouse, Alexey Milovidov, hit the road across APJ - Mumbai, Bengaluru, Singapore, Jakarta, Seoul, and Tokyo - meeting customers, keynoting Confluent's Data Streaming World Tour, hosting community meetups, 🧵 👇️
clickhouse.com
5 Countries, 12 Days, One ClickHouse: Inside Alexey's APJ AI Tour
5 Countries, 12 Days, One ClickHouse: Inside Alexey's APJ AI Tour
120
ClickHouse @clickhouse.com · 20/05/2026
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
clickhouse.com
clickhousectl v0.2.0: Postgres, ClickPipes and more
We're releasing clickhousectl v0.2.0. This release adds Postgres, ClickPipes, SQL over HTTP, a few agent-friendly output tweaks, and a standalone Rust client library for the ClickHouse Cloud API.
040
ClickHouse @clickhouse.com · 16/04/2026
New guide up: getting started with clickhousectl. A full walkthrough from zero to a working ClickHouse project: clickhou.se/3Qd8ff0
clickhouse.com
Getting started with clickhousectl: the ClickHouse CLI for local and cloud
A hands-on guide to clickhousectl, the ClickHouse CLI. Install it, scaffold a project, manage local servers, connect to ClickHouse Cloud, and set up CI/CD — all from your terminal.
020
ClickHouse @clickhouse.com · 09/04/2026
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
clickhouse.com
Introducing clickhousectl: the CLI for ClickHouse local and cloud (beta)
clickhousectl is the official CLI for ClickHouse. It manages local installations, runs local servers, and operates ClickHouse Cloud. It's designed to work for humans and AI agents alike.
030
ClickHouse @clickhouse.com · 13/03/2026
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
clickhouse.com
Define once, use everywhere: a metrics layer for ClickHouse with MooseStack
This post shows a lightweight metrics layer for ClickHouse using MooseStack, an open source developer agent harness for ClickHouse.
121
ClickHouse @clickhouse.com · 13/03/2026
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:
clickhou.se
AI doesn’t always generate perfect ClickHouse schemas (yet)
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…
001
ClickHouse @clickhouse.com · 09/03/2026
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 —
clickhou.se
ClickHouse Bangalore Meetup, Sat, Mar 14, 2026, 10:30 AM | Meetup
Join us in Bangalore for yet another exciting meetup. This event brings together engineers, architects, and data leaders to explore how modern teams are building scalable,
000
ClickHouse @clickhouse.com · 03/03/2026
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:
clickhou.se
010
ClickHouse @clickhouse.com · 27/02/2026
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.
clickhou.se
Getting started with ClickHouse? 13 mistakes and how to avoid them
In this post, we highlight the most common 13 mistakes we see our new users encounter, why they occur and the correct approach.
141
ClickHouse @clickhouse.com · 24/02/2026
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
cursor.com
Cursor - ClickHouse Plugin
Built to make you extraordinarily productive, Cursor is the best way to code with AI.
020
ClickHouse @clickhouse.com · 24/02/2026
Agentic analytics has changed the warehouse contract. Amy Chen walks through how to set up ClickHouse Cloud for AI agents. clickhou.se/4kTxCxI
clickhouse.com
How to set up ClickHouse for agentic analytics
Agentic analytics has changed the warehouse contract. Stakeholders are skipping dashboards and asking chatbots directly: “What was net revenue in EMEA last quarter?”
010
ClickHouse @clickhouse.com · 20/02/2026
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:
clickhou.se
Building an enterprise Postgres service in ClickHouse Cloud
We’ve been investing heavily in state-of-the-art features to ensure customers get an enterprise-grade Postgres experience.
020
ClickHouse @clickhouse.com · 19/02/2026
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?
clickhou.se
Making large Postgres migrations practical: 1TB in 2 hours with PeerDB
PeerDB's Postgres to Postgres migration features enable teams to migrate their existing Postgres databases quickly and with minimal downtime.
140
ClickHouse @clickhouse.com · 18/02/2026
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
clickhouse.com
pg_clickhouse is the fastest Postgres extension on ClickBench
The pg_clickhouse extension minimizes the effort required to run typical analytics queries in Postgres by delegating execution to ClickHouse.
041
ClickHouse @clickhouse.com · 17/02/2026
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
clickhouse.com
AI-powered migrations from Postgres to ClickHouse
AI can drastically accelerate migrating analytical workloads from Postgres to ClickHouse. To set your agents up for success, give them the right environment.
040
ClickHouse @clickhouse.com · 13/02/2026
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
clickhouse.com
pg_stat_ch: a PostgreSQL extension that exports every metric to ClickHouse
We’re open sourcing pg_stat_ch: a PostgreSQL extension that turns every query execution into a fixed-size ~4.6KB event and streams them into ClickHouse.
050
ClickHouse @clickhouse.com · 02/12/2025
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
020
ClickHouse @clickhouse.com · 25/11/2025
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.
clickhou.se
From OTel to Rotel: Petabyte-scale tracing with 4x greater throughput
Read how Streamfold’s Rotel pushes OpenTelemetry 4x faster into ClickHouse - benchmarking efficiency at scale and revealing the tools that make it happen
080
ClickHouse @clickhouse.com · 30/10/2025
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
030
ClickHouse @clickhouse.com · 13/10/2025
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 👇
clickhou.se
ClickHouse’s JSON data type gets even better
The latest changes to the JSON data type in v25.8 make ClickHouse the leader in analytics over JSON data.
061
ClickHouse @clickhouse.com · 09/10/2025
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
clickhou.se
ClickHouse’s JSON data type gets even better
The latest changes to the JSON data type in v25.8 make ClickHouse the leader in analytics over JSON data.
031
ClickHouse @clickhouse.com · 30/09/2025
🚀 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
clickhou.se
What's new in ClickStack. September '25.
Discover what’s new in ClickStack this month, including importing and exporting dashboards, custom aggregations, chunking time windows, and more!
000
ClickHouse @clickhouse.com · 30/09/2025
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 👇
clickhou.se
000
ClickHouse @clickhouse.com · 22/09/2025
How do you unify trillions of data points, reduce costs 40%, and eliminate downtime? Ask Changan Ford. Full story:
clickhou.se
How Changan Ford cut costs by 40% and powered precision marketing with ClickHouse Enterprise Edition
Changan Ford migrated their Customer Data Platform to ClickHouse Enterprise Edition, cut costs by 40%, eased the operational workload, and gave the team stability and confidence even during their…
120
ClickHouse @clickhouse.com · 19/09/2025
What do zombies, Bollywood, and romantasy have in common? Nataly Merezhuk will show how JSON, vector, and full-text search in ClickHouse can be used to map relationships across unstructured data at scale and answer your most imaginative questions! Don't miss this talk at PyConUK on Saturday!
010
ClickHouse @clickhouse.com · 19/09/2025
Final day of SREDay! Dale McDiarmid takes the stage at 15:00 to introduce ClickStack. Observability vendors built three separate engines because they didn't have a database that could handle logs, metrics, AND traces at scale. We do. And we open sourced the whole stack.
011
ClickHouse @clickhouse.com · 18/09/2025
One crypto exchange's actual Datadog bill: $65M/year 🤯 The observability industry has built tools that are more expensive than the systems they monitor. It's like paying more for your car's dashboard than the engine. How did this become normal?
clickhou.se
Breaking free from rising observability costs with open cost-efficient architectures
Discover how open, cost-efficient architectures can break the cycle of runaway observability costs and vendor lock-in
140
ClickHouse @clickhouse.com · 18/09/2025
Heading to SREDay today? Don't miss Rory Crispin at 15:00. Store everything, aggregate nothing. Hear about our journey to 100 PB and 500 trillion rows.
000
ClickHouse @clickhouse.com · 17/09/2025
100 petabytes. 500 trillion rows. That's our observability platform at ClickHouse. Thurs 18th 15:00: Rory Crispin on why "store everything, aggregate nothing" actually works Fri 19th 15:00: Dale McDiarmid on ClickStack and treating o11y as a data problem, not a search problem clickhou.se/48mvES6
sreday.com
SREday - London, UK - September 18-19, 2025
Conference on Site Reliability Engineering, Cloud and DevOps. Probably the most awesome SRE conference in London, UK!
050