# ClickHouse

> ClickHouse is a fast open-source column-oriented database management system (DBMS) optimized for real-time analytical queries using SQL. It powers large-scale data analytics, supports ClickHouse Cloud as a managed service, and integrates with BI tools, data pipelines, and modern data stacks.

## Get started for free

To start using ClickHouse Cloud, sign up here: https://console.clickhouse.cloud/signUp

A free trial is available with $300 in credits over 30 days.

To install ClickHouse locally (MacOS, Linux, FreeBSD):
curl https://clickhouse.com/ | sh

## Pricing

Full pricing in Markdown, incl. plans and per-region compute/storage rates: https://clickhouse.com/pricing.md

## Pages

- [Private Preview access to PromQL support in ClickHouse](https://clickhouse.com/cloud/promql-support-waitlist)
- [Private preview access to ClickHouse On-Demand Compute](https://clickhouse.com/cloud/on-demand-compute-waitlist)
- [Private preview access to AI Functions & Inference Services](https://clickhouse.com/cloud/ai-functions-and-inference-services-waitlist)
- [Private preview access to ClickStack Cloud](https://clickhouse.com/cloud/clickstack-cloud-waitlist)
- [Click-a-thon Terms & Conditions](https://clickhouse.com/clickathon/terms-and-conditions)
- [Interested in the Grafana Plugin for ClickHouse?](https://clickhouse.com/clickhouse/graphana-plugin-interest)
- [Private preview access to AI Notebooks in ClickStack](https://clickhouse.com/cloud/ai-notebooks-in-clickstack-waitlist)
- [ClickHouse legal center](https://clickhouse.com/legal): A list of legal resources for ClickHouse and ClickHouse Cloud.
- [ClickHouse Supported Platforms](https://clickhouse.com/support/platforms)
- [ClickHouse Code of Conduct - Events](https://clickhouse.com/events-code-of-conduct)
- [The open platform for AI on real-time data](https://clickhouse.com/ai): From chat to agents to MCP and beyond, ClickHouse Platform for AI is the open, end-to-end stack that brings AI to your data, enabling agentic analytics in real time, at any scale.
- [The first open benchmark for data warehouse cost-performance](https://clickhouse.com/benchmarks/costbench): Compare the true cost-performance of modern data warehouses. CostBench measures end-to-end ingest, preparation, and query performance across ClickHouse, Snowflake, Databricks, BigQuery, and Redshift using an open, reproducible methodology.
- [Fast at scale. Efficient by design.Second to none in cost and performance.](https://clickhouse.com/benchmarks): Explore verified ClickHouse benchmarks across performance, scalability, and cloud cost. See how ClickHouse compares to other data platforms at real-world scale.
- [Migrate fromBigQuery to ClickHouse](https://clickhouse.com/campaigns/bigquery-to-clickhouse-on-aws): BigQuery handles ad-hoc queries and smaller data volumes effectively, but scaling turns cost and performance management into a significant challenge.
- [chDB - fast, reliable, and scalable in-process database](https://clickhouse.com/chdb): Experience the power of ClickHouse, in-process. With unparalleled performance, reliability, and scalability for any data-intensive application.
- [Click-a-Thon by ClickHouse](https://clickhouse.com/clickathon/india2026): 24 hours. 30 teams. One real problem worth shipping on the fastest database in the game.
- [The evolution of ClickHouse to an analytics platform for all workloads](https://clickhouse.com/clickhouse/feature-journey): Five distinct stories of ClickHouse evolution: joins, data lakes, indexes, lifecycle, and data types & formats.
- [ClickHouse Keeper](https://clickhouse.com/clickhouse/keeper): ClickHouse Keeper solves the well-known drawbacks of ZooKeeper and makes many additional improvements. Join us in building the future of distributed consensus.
- [ClickHouse Café at Snowflake Summit and Databricks Data & AI Summit](https://clickhouse.com/clickhouse-cafe): Visiting Snowflake Summit or Databricks Data + AI Summit in San Francisco? Stop by the ClickHouse Café near Moscone Center for coffee, workspace, happy hour, and one-on-one conversations with ClickHouse engineers.
- [Accelerate your data lake with ClickHouse](https://clickhouse.com/clickhouse-for-data-lakes): Accelerate your data lake with ClickHouse. Query open formats in place, enable real-time analytics, federate across catalogs, and power AI workloads with low latency and high concurrency—without lock-in.
- [Unlock real-time analytics on Databricks](https://clickhouse.com/clickhouse-for-databricks): Make real-time analytics on Databricks faster and more cost-efficient. Move data effortlessly from Databricks to ClickHouse with one line of SQL.
- [The fastest open-source analytical database](https://clickhouse.com/clickhouse): Get real-time insights with ClickHouse, the high-performance data analytics platform. Reap the benefits of streamlined data analysis and try for free today.
- [Observability built for agents, not just dashboards](https://clickhouse.com/clickstack/ai-sre-observability): ClickStack is observability built for agents and humans. Real-time analytical power, full-fidelity telemetry, and semantic investigation tools on ClickHouse.
- [Open source observability for OpenTelemetry at scale](https://clickhouse.com/clickstack): ClickStack is a high-performance observability stack powered by ClickHouse. Unify logs, metrics, and traces with 10-100x cost savings. Get started today!
- [Bring Your Own Cloud available on AWS, GCP, and Azure](https://clickhouse.com/cloud/bring-your-own-cloud): Request access for Bring Your Own Cloud. A fully managed ClickHouse service, deployed in your own AWS, GCP or Azure account.
- [Azure Blob Storage ClickPipe is now Generally Available](https://clickhouse.com/cloud/clickpipes/azure-blob-storage-connector): Seamlessly load files from Azure Blob Storage into ClickHouse Cloud. Get blazing fast analytics without the complexity or cost of external ETL tools.
- [BigQuery connector in ClickPipes is now in Private Preview](https://clickhouse.com/cloud/clickpipes/bigquery-connector): Replicate your BigQuery data to ClickHouse Cloud in just a few clicks for blazing fast analytics.
- [MongoDB CDC connector is now in Public Beta](https://clickhouse.com/cloud/clickpipes/mongodb-cdc-connector): Replicate your MongoDB data to ClickHouse Cloud in just a few clicks for blazing fast analytics.
- [MySQL CDC connector is now in Public Beta](https://clickhouse.com/cloud/clickpipes/mysql-cdc-connector): Replicate your MySQL data to ClickHouse Cloud in just a few clicks for blazing fast analytics.
- [Postgres CDC connector is now Generally Available](https://clickhouse.com/cloud/clickpipes/postgres-cdc-connector): Replicate your Postgres data to ClickHouse Cloud in just a few clicks for blazing fast analytics.
- [ClickPipes](https://clickhouse.com/cloud/clickpipes): ClickPipes is an integration engine that makes ingesting massive volumes of data from a diverse set of sources as simple as clicking a few buttons. Our robust and scalable architecture empowers you to handle the most demanding workloads, with guaranteed high throughput and low latency at scale.
- [Observability for OpenTelemetry at scale](https://clickhouse.com/cloud/clickstack): Lightning-fast queries and powerful aggregations across logs, metrics, traces and session replays, even on the highest-cardinality OpenTelemetry data powered by ClickHouse Cloud for unlimited retention at low-cost.
- [Postgres managed by ClickHouse](https://clickhouse.com/cloud/postgres): Postgres managed by ClickHouse is a native Postgres service integrated with ClickHouse. Build on a Unified Data Stack with Postgres for transactions and ClickHouse for analytics, with no operational overhead.
- [Fast. Efficient. Effortless.](https://clickhouse.com/cloud): ClickHouse Cloud: the fastest, most cost-efficient way to build real-time analytics, observability, and AI-powered data applications. Fully managed, with sub-second query performance at any scale.
- [Welcome to the ClickHouse Community](https://clickhouse.com/community): Learn, contribute, connect, and help shape the fastest OLAP database in the world.
- [Become part of our team](https://clickhouse.com/company/careers): If you are looking for a place to build something new, be an agent of change, and have an opportunity to have a significant impact on the company’s success, this is the place for you.
- [Contact us](https://clickhouse.com/company/contact): Contact the ClickHouse team today for support with all your real-time analytics and data management needs. We would love to hear from you.
- [Press releases](https://clickhouse.com/company/news): Read the latest news and press releases from ClickHouse, including company updates and external media coverage.
- [Who we are](https://clickhouse.com/company/our-story): Find out about our leadership, history, and the culture we’re building, a little at a time.
- [Get a demo of ClickHouse Cloud](https://clickhouse.com/company/request-demo): Tell us about your use case and get a tailored demo of ClickHouse Cloud for your business.
- [Unlock $10,000 in ClickHouse Cloud credits](https://clickhouse.com/deals/ycombinator): YC 2025 founders can apply for $10,000 in ClickHouse Cloud credits, expert training, and promotion opportunities. Build and scale analytics faster with the fastest columnar database.
- [The ClickHouse Query Challenge](https://clickhouse.com/demos/capture-the-flag-query-challenge): Booth challenge
- [Explore Github with ClickHouse-powered real-time analytics](https://clickhouse.com/demos/explore-github-with-clickhouse-powered-real-time-analytics): Run live SQL queries on 10B+ GitHub events and explore real-time analytics in action. Track repo trends, analyze developer activity, and see how ClickHouse delivers blazing-fast insights with high-speed ingestion and efficient query execution.
- [Our demo applications](https://clickhouse.com/demos): Discover demos powered by ClickHouse
- [Meet ClickHouse at Google Cloud Next](https://clickhouse.com/google-cloud-next/2026)
- [ClickHouse Government](https://clickhouse.com/government): Deploy ClickHouse Government self-managed on AWS for government networks (FedRAMP, IL2-6). Get ATO documentation & FIPS 140-3 support.
- [ClickHouse for Automotive](https://clickhouse.com/industries/automotive): Power automotive analytics with ClickHouse—track vehicle performance, monitor factory data, and ingest telemetry at scale. Real-time dashboards, crash insights, and predictive maintenance, all without lag.
- [ClickHouse for Cybersecurity](https://clickhouse.com/industries/cybersecurity): Power real-time cybersecurity analytics with ClickHouse. The fastest open-source database for high-throughput data ingest, scalable querying, and low-latency insights.
- [Energy, accelerated in real-time with ClickHouse](https://clickhouse.com/industries/energy): Harness ClickHouse for energy data at scale. Ingest millions of rows per second, enable predictive maintenance, optimize grids, and deliver real-time insights with the fastest open-source database.
- [ClickHouse for financial services](https://clickhouse.com/industries/financial-services): Power real-time analytics for banking, payments, capital markets, fraud detection, and digital assets. ClickHouse delivers sub-second queries, AI-ready analytics, and petabyte-scale performance at lower cost.
- [The database for gaming analytics and telemetry](https://clickhouse.com/industries/gaming): ClickHouse is the database for Gaming Analytics and Telemetry
- [ClickHouse for Retail](https://clickhouse.com/industries/retail): Explore how ClickHouse enables instant insights for retail businesses. From high-speed dashboards to customer journey tracking, ClickHouse powers real-time analytics for inventory, ads, and store performance at scale.
- [Built for real-time analytics. Trusted across industries.](https://clickhouse.com/industries): ClickHouse powers real-time analytics for gaming, retail, energy, cybersecurity, and more. Ingest millions of rows per second and deliver instant insights at any scale.
- [ClickHouse Certified Developer Exam](https://clickhouse.com/learn/certification): Elevate your career to industry-leading heights by passing our official ClickHouse Certification exam.
- [ClickHouse training](https://clickhouse.com/learn): Master the art of data analysis with ClickHouse. Our seamless, easy to use database management platform can help you to unlock powerful insights. Try for free.
- [ClickHouse Cloud on AWS](https://clickhouse.com/partners/aws): Run ClickHouse, the leading database for AI, as a fully managed service on AWS.
- [ClickHouse Cloud on Azure](https://clickhouse.com/partners/azure): Run ClickHouse, the leading database for AI, as a fully managed service on Azure.
- [Apply to join House Mates](https://clickhouse.com/partners/become-partner): Apply to join the ClickHouse House Mates Partner Program. Get deal registration, training, sales enablement, sandbox environments, and exclusive partner community access.
- [ClickHouse Cloud on Google Cloud](https://clickhouse.com/partners/gcp): Run ClickHouse, the leading database for AI, as a fully managed service on Google Cloud.
- [Welcome to House Mates](https://clickhouse.com/partners): Join House Mates, the ClickHouse Partner Community. Sell, integrate, and grow with the leading database for AI. Open to Cloud, Consulting, Technology, Reseller, and By ClickHouse partners.
- [Pricing](https://clickhouse.com/pricing): Options for every user, organization, and use case. Explore ClickHouse Cloud pricing plans and find the right fit for your workload.
- [The real-time data warehouse](https://clickhouse.com/real-time-data-warehouse): Optimized to power data-intensive apps that run on real-time and historical data. Purpose-built for fast, reliable, and cost-effective querying at any scale.
- [Resource hub](https://clickhouse.com/resources)
- [Sitemap](https://clickhouse.com/sitemap)
- [Unlock $5000 in ClickHouse Cloud credits](https://clickhouse.com/startup-offer): Founders can apply for $5000 in ClickHouse Cloud credits, expert training, and promotion opportunities. Build and scale analytics faster with the fastest columnar database.
- [Support Program](https://clickhouse.com/support/program): Trusted support services for your organization
- [Data warehousing with ClickHouse](https://clickhouse.com/use-cases/data-warehousing): Say goodbye to loading spinners and lengthy report wait times. For Business Intelligence, ClickHouse unlocks faster queries at a fraction of the cost.
- [Machine learning and GenAI](https://clickhouse.com/use-cases/machine-learning-and-data-science): The ultimate real-time database to power Machine Learning workloads. With ClickHouse, it's easier than ever to unleash GenAI on your analytics data.
- [Real-time analytics with ClickHouse](https://clickhouse.com/use-cases/real-time-analytics): Learn about Real-time Analytics and how companies are using ClickHouse for their real-time analytics applications.
- [Use Cases](https://clickhouse.com/use-cases): Unlock faster queries and the ability to handle greater concurrency. No matter how much data you're working with.
- [Fast Open-Source OLAP DBMS](https://clickhouse.com/): ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries
- [The real-time database for AI conference](https://clickhouse.com/openhouse/amsterdam-2026)
- [Free database and AI conferenceBangalore India](https://clickhouse.com/openhouse/bangalore-2025)
- [The real-time database for AI conference](https://clickhouse.com/openhouse/bangalore-2026)
- [The real-time database for AI conference](https://clickhouse.com/openhouse/london-2026)
- [The real-time platform for AI conferenceMelbourne Australia](https://clickhouse.com/openhouse/melbourne-2026)
- [The real-time database for AI conference](https://clickhouse.com/openhouse/munich-2026)
- [Free database and AI conferenceNew York City](https://clickhouse.com/openhouse/nyc-2025)
- [The real-time database for AI conference](https://clickhouse.com/openhouse/nyc-2026)
- [The real-time database for AI conference Open House SF](https://clickhouse.com/openhouse/san-francisco)
- [Free database and AI conferenceSydney Australia](https://clickhouse.com/openhouse/sydney-2025)
- [The real-time platform for AI conferenceSydney Australia](https://clickhouse.com/openhouse/sydney-2026)
- [ClickHouse Blog](https://clickhouse.com/blog): Learn about the latest ClickHouse tips, tricks and company announcements.
- [Events](https://clickhouse.com/company/events): Get all of the latest ClickHouse events, trainings, and webinars.
- [ClickHouse Integrations](https://clickhouse.com/integrations): ClickHouse offers over 100 integrations across categories like language clients, data ingestion, SQL clients, and data visualization.
- [Find a Partner](https://clickhouse.com/partners/find-partner): Find a ClickHouse House Mates partner to help you build, migrate and scale.
- [User Stories](https://clickhouse.com/user-stories): Discover how users find success with ClickHouse as their ultra-fast solution for generating analytics.
- [ClickHouse Videos](https://clickhouse.com/videos): Customer testimonials, how-to tutorials and Meetup recordings.

## Blog

- [The Agentic Analytics Benchmark, round two: GPT-6, Claude Opus 5.5, Claude Sonnet 5.5](https://clickhouse.com/blog/agentic-analytics-benchmark-round-two): We added GPT-6 Astra, Luna and Sol, Claude Opus 5.5 and Claude Sonnet 5.5 to the Agentic Analytics Benchmark: all five land mid-board within a point of each other, and Sonnet 5.5 brings the biggest change in turns, cost and truncated runs.
- [Postgres wait events, now in Query Insights](https://clickhouse.com/blog/postgres-wait-events-query-insights): Query Insights for ClickHouse Managed Postgres now shows what active sessions are waiting on, with wait event breakdowns, blocked-session and lock-wait charts, and the same metrics in Prometheus.
- [Introducing the (blazing fast!) native TCP client for .NET](https://clickhouse.com/blog/introducing-the-blazing-fast-native-tcp-client-for-net): ClickHouse’s new native TCP client for .NET brings faster reads and inserts with fewer allocations, columnar APIs, POCO support, and a path to migrate from HTTP.
- [OLTP is expensive, you can ClickHouse it.](https://clickhouse.com/blog/oltp-is-expensive-you-can-clickhouse-it): Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
- [October 2026 newsletter](https://clickhouse.com/blog/202610-newsletter): Welcome to the October 2026 ClickHouse newsletter, featuring CostBench results against BigQuery and Databricks, ClickHouse 26.9, executable UDFs on ClickHouse Cloud, and the latest community news and events.
- [Scaling ClickStack alerting with built-in anomaly detection](https://clickhouse.com/blog/scaling-clickstack-alerting-anomaly-detection): Managed ClickStack now flags unusual values on the charts you already use with built-in z-score anomaly detection, and a faster, sharded scheduler lets teams bring tens of thousands of alerts over from tools like Grafana.
- [How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management](https://clickhouse.com/blog/ridgeline-iceberg-clickhouse-cloud): Ridgeline rebuilt its performance analytics on ClickHouse Cloud, querying decades of Iceberg history alongside recent data so it can serve investment managers 10x larger than before and more than double the customers live on its platform.
- [Why Redshift Serverless can’t match ClickHouse Cloud for real-time analytics](https://clickhouse.com/blog/clickhouse-vs-redshift-serverless-real-time-performance-per-dollar): ClickHouse Cloud delivered 1,996× better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
- [Postgres at Open House NYC](https://clickhouse.com/blog/postgres-at-open-house-nyc): At Open House NYC, we showed how ClickHouse Managed Postgres and ClickHouse work as one stack, with a live WalShadow demo replicating Postgres into ClickHouse in under a second, plus the same-week Google Cloud and chdb extension launches.
- [Chasing that 32 ms tail latency in ClickHouse](https://clickhouse.com/blog/chasing-32ms-tail-latency-clickhouse): A customer saw an extra ~32 ms on simple SELECT queries after idle periods. We traced it to unbatched Native protocol metadata packets overflowing a reset TCP congestion window, reproduced it with network namespaces, and fixed it by batching them.
- [How iSAM Funds built an options research platform for a 10,000x data problem with ClickHouse Cloud](https://clickhouse.com/blog/isam-market-data-research-platform): iSAM Funds uses ClickHouse Cloud to research full options history, achieving 35–50x compression and 100x faster single-core ingestion while simplifying its data pipelines.
- [How we migrated Clera’s 500 GB production database to ClickHouse Managed Postgres overnight](https://clickhouse.com/blog/clera-migrates-to-clickhouse-managed-postgres): Clera migrated its 500 GB production database and 500+ tables to ClickHouse Managed Postgres overnight, cutting CPU usage from 100% to 10–20%.
- [Introducing JWT authentication in ClickHouse Cloud](https://clickhouse.com/blog/introducing-jwt-authentication-in-clickhouse-cloud): Connect to ClickHouse Cloud with short-lived tokens from your identity provider instead of database passwords.
- [Why BigQuery can’t match ClickHouse Cloud for real-time analytics](https://clickhouse.com/blog/clickhouse-vs-bigquery-real-time-performance-per-dollar): ClickHouse Cloud delivered 438× better performance per dollar than BigQuery in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
- [🗽 Postgres Summit US 2026 retrospective](https://clickhouse.com/blog/postgres-summit-us-2026): Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
- [Why Databricks can’t match ClickHouse Cloud for real-time analytics](https://clickhouse.com/blog/clickhouse-vs-databricks-real-time-performance-per-dollar): ClickHouse Cloud delivered 752× better performance per dollar than Databricks in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
- [Executable UDFs are now generally available on ClickHouse Cloud](https://clickhouse.com/blog/executable-udfs-generally-available-on-clickhouse-cloud): Executable UDFs are now generally available on ClickHouse Cloud across AWS, GCP, and Azure, with native runtimes, network access, observability, and API and Terraform support.
- [What is direct I/O, and why does ClickHouse Managed Postgres use it for backups?](https://clickhouse.com/blog/direct-io-managed-postgres-backups): ClickHouse Managed Postgres uses direct I/O and stripe-sized reads to keep backups fast while protecting the page cache and query latency.
- [How LinkedIn extended ClickHouse from distributed tracing to metric discovery and analytics](https://clickhouse.com/blog/linkedin-observability-at-scale): LinkedIn expanded its ClickHouse observability stack from distributed tracing to metric discovery and analytics, consolidating 13B+ metrics into one index serving 150k+ queries per minute.
- [Introducing SCIM Provisioning in ClickHouse Cloud](https://clickhouse.com/blog/introducing-scim-provisioning-in-clickhouse-cloud): ClickHouse Cloud now supports SCIM 2.0, so your identity provider can create, update, and deprovision organization members and sync group membership to ClickHouse roles automatically.
- [pg_clickhouse & chdb updates: Encoding, nesting, and types](https://clickhouse.com/blog/pg_clickhouse-chdb): The latest pg_clickhouse and chdb extension releases improve character encoding, interval handling, nested data, JSON, and type mappings between ClickHouse and Postgres.
- [Memory safety for Postgres extensions in C/C++](https://clickhouse.com/blog/memory-safety-postgres-extensions-c-cpp): How ClickHouse’s Postgres extensions handle the memory safety challenges of combining C and C++, from clean language boundaries to isolated helper processes.
- [ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview](https://clickhouse.com/blog/clickhouse-for-microsoft-fabric): ClickHouse Workload for Microsoft Fabric brings sub-second analytics to OneLake data through a native Fabric workload, with dedicated ClickHouse Cloud compute for agents, dashboards, and applications.
- [ClickHouse now writes Apache Iceberg tables to Microsoft OneLake](https://clickhouse.com/blog/clickhouse-now-writes-to-microsoft-onelake): ClickHouse today announced the ability to write directly to Microsoft OneLake, the unified data lake service within Microsoft Fabric.
- [ClickHouse expands collaboration with Microsoft, bringing Fabric integration, deeper OneLake interoperability, and enterprise deployment flexibility](https://clickhouse.com/blog/clickhouse-expands-collaboration-with-microsoft): ClickHouse expands its Microsoft collaboration with a native Fabric workload, OneLake read and write capabilities, and ClickHouse BYOC availability in the Microsoft Marketplace.
- [Can your Postgres survive a bad query?](https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query): How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
- [chDB Durable Layer for agent memory](https://clickhouse.com/blog/chdb-durable-layer-for-agent-memory): The chDB Durable Layer keeps agent memory fast to query locally while making its analytical state recoverable across laptops, CI jobs, and short-lived sandboxes.
- [ClickHouse release 26.9](https://clickhouse.com/blog/clickhouse-release-26-09): ClickHouse 26.9 introduces conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for DISTINCT, time-limited tokens, and faster min/max/count queries.
- [ClickHouse appoints Mike Scarpelli, former Snowflake and ServiceNow CFO, to Board of Directors](https://clickhouse.com/blog/clickhouse-appoints-mike-scarpelli-to-board-of-directors): ClickHouse, a leader in real-time analytics, data warehousing, observability, and AI/ML, today announced the appointment of Michael Scarpelli to its Board of Directors
- [How Fountain rebuilt its data plane on ClickHouse Cloud to power Cue, the Frontline Superintelligence](https://clickhouse.com/blog/fountain-agentic-ai-for-high-volume-hiring): Fountain cut analytics latency from three hours to under two minutes and costs by 66% by rebuilding Cue’s data plane on ClickPipes and ClickHouse Cloud.
- [Postgres on NVMe: performance and the convergence of transactions and analytics](https://clickhouse.com/blog/postgres-on-nvme): See how local NVMe transforms Postgres transaction performance—and why ClickHouse remains essential for fast analytics as workloads scale.
- [Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026](https://clickhouse.com/blog/postgres-week-in-the-netherlands-pgday-lowlands-percona-live-2026): Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.
- [September 2026 newsletter](https://clickhouse.com/blog/202609-newsletter): Welcome to the September 2026 ClickHouse newsletter, featuring ClickHouse 26.8, PromQL, On-Demand Compute, CostBench results, and the latest community news and events.
- [The official ClickHouse provider for Apache Airflow is now available](https://clickhouse.com/blog/clickhouse-airflow-provider): The official ClickHouse provider for Apache Airflow simplifies data workflows with standard SQL operators, bulk inserts, and shared setup across self-managed Airflow and Astronomer.
- [ClickHouse is now available on the dbt platform](https://clickhouse.com/blog/clickhouse-is-now-available-on-the-dbt-platform): The ClickHouse adapter for dbt v2 is in public beta, powered by dbt’s Rust engine. ClickHouse also joins the dbt platform in private beta, supporting open-source ClickHouse and ClickHouse Cloud.
- [What's new in ClickStack - Aug ’26](https://clickhouse.com/blog/whats-new-in-clickstack-august-2026): The August ClickStack update brings dashboard variables, chart formulas, PromQL support, a metrics browser, LLM observability, and improvements to alerting and tracing.
- [Introducing ClickHouse's new TimeSeries Engine: Your drop-In Prometheus replacement](https://clickhouse.com/blog/introducing-promql): ClickHouse PromQL support lets you store Prometheus metrics in ClickHouse Cloud, query them using familiar PromQL, and bring metrics together with your logs and traces without rewriting queries in SQL.
- [Replica-aware routing public beta](https://clickhouse.com/blog/replica-aware-routing-public-beta): Temporary tables and named sessions live on a single ClickHouse replica, so a follow-up query routed elsewhere can't see them. Replica-aware routing pins your requests to the same replica over HTTP or the native protocol — and here's how we built it.
- [AI Functions in ClickHouse: Upgrade your SQL to the AI age](https://clickhouse.com/blog/ai-functions-in-clickhouse): Explore ClickHouse AI Functions for classification, generation, translation, embeddings, semantic search, and cost controls—all directly from SQL.
- [Introducing WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL](https://clickhouse.com/blog/introducing-walshadow): WalShadow replicates Postgres data directly from physical WAL into ClickHouse, delivering around 200 ms latency and 289,000 rows per second in benchmarks.
- [ClickHouse is a launch partner for the Data agent in ChatGPT Work](https://clickhouse.com/blog/chatgpt-data-plugin): ClickHouse joins the Data agent in ChatGPT Work, connecting ClickHouse Cloud to natural-language queries, reports, and interactive dashboards.
- [Announcing On-Demand Compute: Instant compute for your most intensive workloads](https://clickhouse.com/blog/on-demand-compute): 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.
- [Why Snowflake can’t match ClickHouse Cloud for real-time analytics](https://clickhouse.com/blog/clickhouse-vs-snowflake-real-time-performance-per-dollar): 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.
- [Loading Parquet data into MySQL with ClickHouse](https://clickhouse.com/blog/parquet-to-mysql-with-clickhouse): Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.
- [ClickHouse release 26.8](https://clickhouse.com/blog/clickhouse-release-26-08): ClickHouse 26.8 LTS introduces background queries, pipelined SQL, new text tokenizers, expanded data lake integrations, and faster Parquet, aggregation, and join queries.
- [Announcing ClickHouse Managed Postgres on Google Cloud](https://clickhouse.com/blog/postgres-managed-by-clickhouse-gcp-private-preview): 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.
- [Introducing chdb Postgres extension: High-performance imports from cloud storage](https://clickhouse.com/blog/introducing-chdb-postgres): The chdb Postgres extension brings fast imports and exports across cloud storage platforms and data formats, powered by the embedded ClickHouse engine.
- [CostBench: Putting real-time analytics to the test](https://clickhouse.com/blog/costbench-real-time-performance-per-dollar): 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.
- [How MCP Toolbox turns agent text into ClickHouse vectors](https://clickhouse.com/blog/mcp-toolbox-clickhouse-vectors): 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.
- [ClickHouse as a streaming HTTP API](https://clickhouse.com/blog/clickhouse-streaming-http-api): Learn how to build a streaming HTTP API directly in ClickHouse 26.8 with named handlers, typed parameters, pagination, framing formats, and access control.
- [Pipelined SQL in ClickHouse 26.8](https://clickhouse.com/blog/pipelined-sql-26.8): Learn how ClickHouse 26.8’s pipelined SQL syntax lets you build multi-stage queries as a readable sequence of transformations.
- [Build a real-time market data app with ClickHouse and Massive](https://clickhouse.com/blog/build-a-real-time-market-data-app-with-clickhouse-and-polygonio): Learn how to build a real-time financial analytics application with Massive and ClickHouse that scales to thousands of events per second.
- [Introducing Scheduled Upgrades in ClickHouse Managed Postgres](https://clickhouse.com/blog/introducing-scheduled-upgrades-in-clickhouse-managed-postgres): ClickHouse Managed Postgres now supports scheduled upgrade windows, giving Scale and Enterprise users more control over when routine platform maintenance occurs.
- [MySQL CDC connector for ClickPipes is now Generally Available](https://clickhouse.com/blog/mysql-cdc-connector-for-clickpipes-is-now-generally-available): 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.
- [From Neon Postgres to ClickHouse Managed Postgres](https://clickhouse.com/blog/neon-to-clickhouse-managed-postgres): Four teams share why they migrated production Postgres workloads from Neon to ClickHouse Managed Postgres, using ClickPipes or their own migration tooling.
- [The Agentic Analytics Benchmark: Measuring model accuracy and efficiency in analytical agents](https://clickhouse.com/blog/agentic-analytics-benchmark-data-agent-mnist): We took 201 real analytics questions from our production data warehouse, benchmarked 29 models on correctness, cost, and speed, and released an open harness so you can run the same test on your own.
- [How Uken Games reduces observability costs by 87% with ClickHouse](https://clickhouse.com/blog/uken-games-clickhouse-observability-stack): 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.
- [ClickHouse welcomes RunReveal](https://clickhouse.com/blog/clickhouse-welcomes-runreveal): Security is the largest and fastest growing data workload in the enterprise, and today, ClickHouse has acquired RunReveal.
- [New system views in PostgreSQL 19](https://clickhouse.com/blog/postgres-19-new-system-views): PostgreSQL 19 adds four system views that make lock contention, recovery state, autovacuum priorities, and dynamic shared memory allocations easier to inspect.
- [A new getting started experience for ClickHouse Managed Postgres](https://clickhouse.com/blog/clickhouse-managed-postgres-onboarding): See how a four-step onboarding flow helps users move from provisioning ClickHouse Managed Postgres to querying operational data and running real-time analytics with ClickHouse.
- [So, is ClickHouse winning the observability wars?](https://clickhouse.com/blog/is-clickhouse-winning-the-observability-wars): After claims that ClickHouse is “winning the observability wars” sparked debate, we reflect on why it has become a leading storage and query engine, where it still falls short, and why winning the database layer isn’t the same as winning observability.
- [A universal interface: How QuintoAndar made ClickHouse plug-and-play with managed Postgres](https://clickhouse.com/blog/quintoandar-managed-postgres): QuintoAndar unified ~900 million monthly events in ClickHouse Cloud and used ClickHouse Managed Postgres to make that data accessible to Hightouch and any Postgres-compatible tool.
- [What's new in the ClickHouse .NET Driver: the road from 1.0 to 1.3](https://clickhouse.com/blog/whats-new-clickhouse-net-driver-10-to-13): Discover how ClickHouse .NET Driver 1.1–1.3 adds type-safe POCO workflows, extensible serialization, broader type support, performance improvements, and official ecosystem integrations.
- [How Suprema Gaming made its data platform agent-ready with ClickHouse Cloud](https://clickhouse.com/blog/suprema-gaming-agent-ready-platform): Suprema Gaming migrated its analytics platform from Snowflake to ClickHouse Cloud to power a company-wide shift toward agentic operations.
- [Read your writes: WAIT FOR in PostgreSQL 19](https://clickhouse.com/blog/postgresql-19-wait-for-read-your-writes): PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.
- [ClickGap: Autonomous QA for ClickHouse](https://clickhouse.com/blog/clickgap-autonomous-qa-for-clickhouse): ClickGap reviews merged ClickHouse changes, executes reproducers, rejects false positives, and attributes regressions to specific commits.
- [Ensuring reliable OpenTelemetry ingestion at scale](https://clickhouse.com/blog/reliable-opentelemetry-ingestion-at-scale): How ClickHouse Cloud collects 50m events per second through OpenTelemetry
- [What else runs on your Postgres server, and how do we stop it from taking the database down?](https://clickhouse.com/blog/protect-postgres-from-supporting-processes): ClickHouse Managed Postgres uses runtime budgets, cgroup limits, and disk-full session exemptions to keep supporting services from compromising database availability.
- [August 2026 newsletter](https://clickhouse.com/blog/202608-newsletter): Welcome to the August 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [POSETTE Talk Recap - Postgres Isn't Slow. Your Storage Is](https://clickhouse.com/blog/posette-talk-recap-postgres-isnt-slow-your-storage-is): A recap of Sai Srirampur's POSETTE 2026 talk on storage performance in Postgres, with a local NVMe vs. EBS benchmark and the production setup behind it.
- [Shopify powers observability for global-scale commerce with ClickHouse](https://clickhouse.com/blog/shopify-observability-at-global-scale): Shopify unified global-scale observability on ClickHouse, achieving up to 30x faster queries while ingesting 100 million events per second at peak.
- [How Sony LIV uses ClickHouse Cloud to deliver live streaming analytics at billion-row scale](https://clickhouse.com/blog/sony-liv-real-time-analytics): Sony LIV consolidated fragmented batch, Elasticsearch, and BigQuery workloads on ClickHouse Cloud, delivering sub-second analytics across billions of daily streaming events.
- [What's New with Monitoring in PostgreSQL 19](https://clickhouse.com/blog/postgres-19-monitoring-whats-new): What's New with Monitoring in PostgreSQL 19
- [Announcing support for ClickStack in the ClickHouse Terraform provider](https://clickhouse.com/blog/clickstack-terraform-provider): The ClickHouse Terraform provider now manages ClickStack dashboards, alerts, sources, and webhooks, putting observability config in version control.
- [What’s new in the ClickHouse Grafana plugin](https://clickhouse.com/blog/clickhouse-grafana-plugin-4-20): ClickHouse Grafana plugin 4.20 brings compact query mode, click-to-filter log investigation, guided variable and annotation editors, and OpenTelemetry dashboards
- [ClickStack and Hud bring runtime intelligence to AI-powered development](https://clickhouse.com/blog/clickstack-hud-runtime-intelligence): 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.
- [How iFood built its agentic security platform on ClickHouse Cloud](https://clickhouse.com/blog/ifood-agentic-security-platform): 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.
- [What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates](https://clickhouse.com/blog/pg_clickhouse-whats-new-july-2026): Discover what's new in pg_clickhouse v0.10.0: 16 of 22 TPC-H queries now push down in full, plus a rebuilt C driver and broader aggregate support.
- [bitdrift brings ClickHouse-powered mobile observability to ClickStack](https://clickhouse.com/blog/bitdrift-clickhouse-mobile-observability-for-clickstack): bitdrift joins ClickHouse’s House Mates program with a mobile observability integration, bringing mobile-native telemetry, tracing, and debugging to ClickStack.
- [Whats new in ClickStack - June + July](https://clickhouse.com/blog/whats-new-in-clickstack-june-2026): 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.
- [How Musinsa scaled its audience engine with ClickHouse Cloud and reduced TCO by 71.4%](https://clickhouse.com/blog/musinsa-customer-data-platform): Musinsa migrated its audience engine from self-hosted ClickHouse to ClickHouse Cloud, cutting storage costs by 86.5% and total cost of ownership by up to 71.4% while simplifying real-time ingestion with ClickPipes.
- [What's new in ClickHouse Managed Postgres: Customer notifications, better observability, faster backups, extensions, and more](https://clickhouse.com/blog/managed-postgres-notifications-observability-backups): Explore the latest ClickHouse Managed Postgres updates, including proactive notifications, richer observability, faster backups, and expanded extension support.
- [ClickHouse Release 26.7](https://clickhouse.com/blog/clickhouse-release-26-07): 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!
- [How Physical Intelligence unified its robotics data stack with Postgres managed by ClickHouse](https://clickhouse.com/blog/physical-intelligence-rds-to-clickhouse-managed-postgres): Physical Intelligence runs both its OLAP and OLTP workloads on ClickHouse managed Postgres and ClickHouse Cloud
- [What is WAL backpressure, and why does ClickHouse Managed Postgres need it?](https://clickhouse.com/blog/wal-backpressure-clickhouse-managed-postgres): How ClickHouse Managed Postgres uses WAL-aware backpressure to slow client writes, protect disk space, and let the archiver recover.
- [Fixed cadence to seconds: making ClickHouse Cloud autoscaling more reactive](https://clickhouse.com/blog/making-clickhouse-cloud-autoscaling-more-reactive): 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.
- [How Mercado Libre rebuilt its observability platform on ClickHouse Cloud with 75x faster trace queries](https://clickhouse.com/blog/mercado-libre-observability-on-clickhouse-cloud): How Mercado Libre rebuilt its observability platform on ClickHouse Cloud, cutting trace query times from over five minutes to about four seconds (a 75x speedup) with up to 89% compression while ingesting 400 million spans per minute.
- [ClickHouse launches ClickHouse Labs with Andy Pavlo as VP of Database Research](https://clickhouse.com/blog/andy-pavlo-founding-clickhouse-labs): Renowned database researcher will lead a new group dedicated to advancing foundational database technology and sharing its work openly with the broader community.
- [Andy Pavlo joins ClickHouse to establish ClickHouse Labs](https://clickhouse.com/blog/andy-pavlo-joins-clickhouse): I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
- [I created a playground for 110 database systems](https://clickhouse.com/blog/clickbench-playground): 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
- [What's new in clickhousectl v0.4.0](https://clickhouse.com/blog/clickhousectl-v0-4-0): clickhousectl v0.4.0 adds horizontal autoscaling for Cloud services, ClickPipe schema discovery, finer control over ClickPipe ingestion, and opt-out anonymous usage telemetry.
- [ClickHouse joins the Open Secure AI Alliance](https://clickhouse.com/blog/open-secure-ai-alliance): ClickHouse is joining the Open Secure AI Alliance alongside NVIDIA and other industry leaders to help build open tools that keep AI agents secure.
- [Choosing Between ClickStack and Grafana for ClickHouse Observability](https://clickhouse.com/blog/choosing-between-clickstack-and-grafana-for-clickhouse-observability): Using ClickHouse for observability and wondering which interface best fits your workflows? We explore ClickStack, Grafana, and when it makes sense to use both.
- [Benchmarking NVMe-backed Managed Postgres: PlanetScale and ClickHouse](https://clickhouse.com/blog/benchmarking-nvme-managed-postgres-planetscale-vs-clickhouse): We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.
- [How Jump Trading uses ClickHouse with Iceberg for analytics](https://clickhouse.com/blog/jump-trading-uses-clickhouse-with-iceberg): Jump Trading captures petabyte-scale financial trading logs on a self-managed ClickHouse platform, where zero data loss and low latency are critical requirements.
- [Instrumenting my espresso machine with OpenTelemetry](https://clickhouse.com/blog/espresso-machine-observability-with-otel): 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,
- [How Fetch built its flexible agentic analytics tool on ClickHouse Cloud](https://clickhouse.com/blog/fetch-agentic-analytics): Fetch built FAST, a conversational BI agent on ClickHouse Cloud, so non-technical teams can query 150 billion rows a day in plain language and get answers in minutes instead of days.
- [Why strict memory overcommit matters for Postgres](https://clickhouse.com/blog/strict-memory-overcommit-for-postgres): 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.
- [ClickHouse docs relaunch](https://clickhouse.com/blog/clickhouse-docs-on-mintlify): 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 achieves AWS Small and Medium Business Competency](https://clickhouse.com/blog/achieves-aws-smb-competency): 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.
- [Agentic infrastructure with clickhousectl: a distributed ClickStack across three continents](https://clickhouse.com/blog/agentic-infrastructure-clickhousectl-distributed-clickstack): 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.
- [How we build and evaluate our MCP server for SRE agents](https://clickhouse.com/blog/benchmarking-the-clickstack-mcp-server-with-hdx-evals): 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
- [Migrate Datadog telemetry with the OpenTelemetry Collector](https://clickhouse.com/blog/datadog-receiver-opentelemetry-collector): 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.
- [PostgresBench: Measuring the impact of High Availability on Managed Postgres performance](https://clickhouse.com/blog/postgresbench-ha): 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
- [ClickHouse announced as Principal Partner and Front of Shirt Sponsor of Fulham Football Club](https://clickhouse.com/blog/clickhouse-announced-principal-partner-sponsor-fulham-fc): Fulham Football Club is proud to announce ClickHouse, a global technology company specialising in real-time analytics, data infrastructure and AI applications, as its newest Principal Partner and Front of Shirt Sponsor of the Men’s First Team.
- [July 2026 newsletter](https://clickhouse.com/blog/202607-newsletter): Welcome to the July 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [Why Trainy migrated from Amazon RDS Postgres to ClickHouse Managed Postgres](https://clickhouse.com/blog/trainy-postgres-managed-by-clickhouse): Trainy moved Pluto's metadata layer from Amazon RDS to ClickHouse Managed Postgres, cutting costs and making page loads up to 3x faster while unifying OLAP and OLTP under one vendor.
- [Replacing the HDB: ClickHouse for historical ticker data](https://clickhouse.com/blog/historical-ticker-data): A hands-on walkthrough of loading billions of Binance tick records into ClickHouse, showing how columnar storage and codecs compress trade and quote data 19x, and how standard SQL handles VWAP, OHLC candles, and as-of joins at millisecond granularity.
- [How Bullet uses ClickHouse Cloud to give DeFi's fastest exchange real-time analytics](https://clickhouse.com/blog/bullet-real-time-analytics): Switching from Databricks to ClickHouse Cloud cut Bullet's query latency 10,000x and eliminated an entire serving layer, giving DeFi's fastest exchange real-time analytics at comparable cost.
- [@clickhouse/rowbinary: when your library is also a parser compiler](https://clickhouse.com/blog/clickhouse-rowbinary-library-parser-compiler): 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 Agent Skill: point a coding agent at the bundled `SKILL.md`
- [How we configure huge pages in ClickHouse Managed Postgres](https://clickhouse.com/blog/huge-pages-clickhouse-managed-postgres): How ClickHouse Managed Postgres reserves, enforces, and sizes huge pages so shared_buffers avoids the per-connection page-table tax that eats RAM and stalls reads on 4KB pages.
- [How Insider One uses ClickHouse Cloud to power real-time customer engagement at scale](https://clickhouse.com/blog/insiderone-customer-data-platform): Insider One cut query latency by up to 75% and eliminated operational overhead by moving its Unified Customer Database from self-managed ClickHouse to ClickHouse Cloud.
- [ClickHouse on Docker Hardened Images](https://clickhouse.com/blog/docker-hardened-images): ClickHouse is now available as a Docker Hardened Image: a minimal, security-hardened build that passes enterprise vulnerability scans by shipping only what the database needs to run, with no change to how ClickHouse behaves.
- [One Driver, One Format, Every Language: ADBC](https://clickhouse.com/blog/introducing-the-clickhouse-adbc-driver): ClickHouse now has an official ADBC driver, giving Ruby, R, C, and every other ADBC-aware tool zero-conversion, Arrow-native access to ClickHouse without a dedicated client for each language.
- [How Trigger.dev is using ClickHouse to scale observability for long-running AI workflows](https://clickhouse.com/blog/trigger-dev-scaling-observability): Trigger.dev migrated from Postgres to ClickHouse to scale observability for its serverless AI workflow platform, delivering ~200 ms P95 query performance and a dramatically smaller telemetry storage footprint.
- [Introducing pg_re2, fast, RE2-powered regular expressions in Postgres](https://clickhouse.com/blog/introducing-pg_re2-regex-in-postgres): Introducing pg_re2, a Postgres extension that brings ClickHouse's fast RE2-powered regular expressions to Postgres, with benchmarks and pg_clickhouse pushdown integration.
- [AI needs the best-of-breed data stack: Postgres and ClickHouse](https://clickhouse.com/blog/ai-best-of-breed-data-stack): AI applications are driving explosive data growth and collapsing the line between transactional and analytical workloads, making the best-of-breed combination of Postgres and ClickHouse — increasingly tied together through CDC, native querying, and observ
- [chDB as the Agent's Local Data Engine](https://clickhouse.com/blog/chdb-agents-local-data-engine): chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.
- [98% faster queries, 50% lower cloud costs: Verihubs’ journey from Postgres to ClickHouse](https://clickhouse.com/blog/verihubs-data-warehouse): Verihubs rebuilt its Postgres data warehouse on ClickHouse with real-time Kafka streaming, cutting query times by up to 98% and cloud costs by up to 50%.
- [Introducing AI dashboard and workflow generation in ClickStack](https://clickhouse.com/blog/clickstack-ai-dashboard-generation): ClickStack can now generate full dashboards and linked investigative workflows from a single prompt, using an AI Notebook and the same MCP tools available to external agents like Claude, Cursor, and Codex.
- [ClickHouse Release 26.6](https://clickhouse.com/blog/clickhouse-release-26-06): ClickHouse 26.6 is here! In this release, we have hypothetical skip indexes, cascading refreshable materialized views, experimental support for continuous queries, and more!
- [How we made ClickStack 5x faster for ClickHouse observability](https://clickhouse.com/blog/making-clickstack-5x-faster-clickhouse-observability): Learn how the ClickStack team used a benchmark-driven process — combining primary key redesign, text indexes, alias columns, and materialized views — to reduce observability query latency by more than 5× ahead of general availability.
- [ClickHouse Agents is now available for Managed Postgres](https://clickhouse.com/blog/clickhouse-agents-managed-postgres): ClickHouse Agents now connects directly to Managed Postgres, so you can query your operational data in plain English, combine it with ClickHouse in a single request, and get agent-guided help monitoring, tuning, and migrating your databases.
- [How we scale PgBouncer in ClickHouse Managed Postgres](https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres): PgBouncer is single-threaded, so a single process caps out at one CPU core no matter the box size. See how ClickHouse Managed Postgres runs a peered fleet of PgBouncer processes with so_reuseport to scale pooling across every core — with benchmarks showin
- [How Artemis Security runs 69x faster detection queries with ClickHouse Cloud](https://clickhouse.com/blog/artemis-security-real-time-threat-detection): Artemis Security cut detection query times 69x and investigative lookups up to 60x using ClickHouse query coalescing, materialized extraction, and AI-powered debugging with Claude.
- [A Quadrillion Rows across three Clouds: scaling LogHouse](https://clickhouse.com/blog/a-quadrillion-rows-across-the-three-cloud-scaling-loghouse): We scaled our internal logging platform from 19 PiB to 431 PiB and 1.59 quadrillion rows. Here’s how we rearchitected LogHouse to handle 80 GiB/s of writes while keeping queries fast and the underlying complexity invisible.
- [Clever ingests 200x more logs at the same cost with ClickHouse Cloud](https://clickhouse.com/blog/clever-observability-at-scale): Clever replaced Datadog with ClickHouse Cloud and went from indexing 10% of their logs to 100%, gaining 200x more searchable log volume and 60 days of retention at no additional cost.
- [How Jua delivers the world’s most accurate physics simulations 3x faster with ClickHouse Cloud](https://clickhouse.com/blog/jua-physics-foundation-model): Jua replaced a file-based forecast pipeline with ClickHouse Cloud, cutting data delivery time from one hour to 20 minutes and historical query times from hours to seconds — giving energy traders a faster edge.
- [Agents hate friction: early thoughts on building for agents](https://clickhouse.com/blog/agents-hate-friction): 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?
- [Benchmarks and Obscurantism: A “red” line that should not be crossed](https://clickhouse.com/blog/databricks-reyden-benchmark-transparency-clickhouse): Benchmarks only matter when they can be inspected, challenged, and reproduced. Here’s what we found when we tested Databricks’ ClickHouse claim.
- [How I hunt for vulnerabilities with AI](https://clickhouse.com/blog/how-i-hunt-for-vulnerabilities-with-ai): 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 codebase, generate hypotheses, and speed up validation.
- [ClickHouse achieves AWS Cloud Operations Competency](https://clickhouse.com/blog/achieves-aws-cloudops-competency): ClickHouse has achieved the AWS Cloud Operations Competency in Monitoring and Observability. Teams like Modal, Exabeam, and Langfuse run full-fidelity logs, metrics, and traces on ClickHouse, querying them in real time without sampling or runaway cost.
- [Announcing Silk: a silky smooth fiber runtime for ClickHouse](https://clickhouse.com/blog/silk): Silk is a new open-source C++ fiber runtime built for ClickHouse, combining a NUMA-aware work-stealing scheduler, io_uring I/O, and zero heap allocation in the steady state to deliver nanosecond-level fiber yields and dramatically lower tail latency for h
- [ClickHouse is now a native connection in Notion Custom Agents](https://clickhouse.com/blog/notion-custom-agents): ClickHouse is now a native connection in Notion Custom Agents. Connect with OAuth and let agents run read-only queries on your data without leaving Notion.
- [Why we rewrote WAL-G for Postgres backups in Rust: Meet WAL-RUS](https://clickhouse.com/blog/walrus-postgres-backups-in-rust): How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.
- [How Vibe.co handles billions of ad impressions with ClickHouse Cloud](https://clickhouse.com/blog/vibe-adtech-analytics): How Vibe.co scaled from 100 GB to 2 TB of Connected TV ad impression data without rearchitecting anything, by migrating from Postgres to ClickHouse Cloud.
- [Announcing the Managed ClickStack MCP Server](https://clickhouse.com/blog/announcing-managed-clickstack-mcp-server): Announcing the Managed ClickStack MCP Server: purpose-built observability tools, full-fidelity telemetry, and dedicated compute for AI-driven investigations at scale.
- [How Visa went from multi-day reporting to conversational analytics agents with ClickHouse Cloud and LibreChat](https://clickhouse.com/blog/visa-conversational-agents): Visa paired LibreChat with ClickHouse Cloud to build conversational BI agents on Authorize.net payments data, cutting multi-day reports to sub-second queries and reclaiming 8-10 hours per user each week.
- [What's New in pg_clickhouse v0.3.2: Postgres 19, TLS, Regex, and Memory](https://clickhouse.com/blog/pg_clickhouse-whats-new-june-2026): The latest pg_clickhouse releases bring JSONB, date/time, and array function pushdown, plus HTTP result set streaming for lower memory usage.
- [The end-to-end cost-performance of real-time analytics: Snowflake vs. ClickHouse Cloud](https://clickhouse.com/blog/real-time-analytics-cost-performance-snowflake-vs-clickhouse): Real-time analytics is more than fast queries. CostBench compares Snowflake and ClickHouse Cloud across the full path: continuous ingest, query-ready data maintenance, freshness, query latency, and cost.
- [What's new in ClickStack - May 2026](https://clickhouse.com/blog/whats-new-in-clickstack-may-2026): We’ve shipped dashboard actions, custom number palettes, flexible event patterns, a built-in RUM experience, major trace view improvements, expanded MCP capabilities, scoped dashboard filters, and much more in ClickStack this May.
- [The future of observability won’t be one proprietary AI agent. It will be thousands built by teams.](https://clickhouse.com/blog/the-future-of-observability-not-one-proprietary-ai-agent-thousands-by-teams): We don’t think observability will be dominated by a single AI agent. The future belongs to teams building agents around their own systems, workflows, and operational knowledge.
- [How Spyne simplified their CDC pipeline with ClickPipes and ClickHouse Cloud](https://clickhouse.com/blog/spyne-clickpipes-cdc-pipeline): Spyne cut table onboarding from 1.5+ hours to minutes and eliminated schema drift by migrating their CDC pipeline from a self-managed Debezium/Kafka stack to ClickPipes and ClickHouse Cloud.
- [Ten years of open source: a stained-glass view](https://clickhouse.com/blog/ten-years-of-open-source-a-stained-glass-view): ClickHouse has been open source for ten years. At Open House San Francisco, we explored this in greater detail in the day 2 keynote. We've all heard open source described as a cathedral and a bazaar, a big tent, etc. We tried a different analogy: staine
- [Beyond the warehouse: How METRO Markets built a do-it-all data platform on ClickHouse Cloud](https://clickhouse.com/blog/metro-markets-data-warehouse): How METRO Markets replaced a failing Hadoop-based stack with ClickHouse Cloud to build a single platform now powering data warehousing, real-time seller analytics, credit risk modeling, observability, and AI across the whole company.
- [Why everyone is talking about real-time analytics (a note from “the yellow company”)](https://clickhouse.com/blog/why-everyone-is-talking-about-real-analytics-yellow-company): For years, real-time analytics was treated as a niche requirement. We believed otherwise. So why is everyone talking about it now?
- [Appcues delivers personalized customer engagement with ClickHouse Cloud](https://clickhouse.com/blog/appcues-customer-engagement-analytics): Appcues cut P95 query times 90%, ingestion latency 99%, and analytics spend 23% by migrating from Snowflake and Airflow to ClickHouse Cloud for real-time segmentation across 1.31 PB of data.
- [What's new in Postgres Managed by ClickHouse: RBAC, Terraform, ClickPipes, extensions, and more](https://clickhouse.com/blog/postgres-managed-by-clickhouse-rbac-terraform-clickpipes-extensions): Postgres managed by ClickHouse's first major update since public beta, covering fine-grained access control, a redesigned console, Terraform support, MCP integration, Stripe provisioning, migrations, billing, and capacity reservations — all shipped in und
- [June 2026 newsletter](https://clickhouse.com/blog/202606-newsletter): Welcome to the June 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [GCP Pub/Sub connector for ClickPipes is now in Private Preview](https://clickhouse.com/blog/clickpipes-gcp-pub-sub-preview): Stream data from Pub/Sub in a few clicks for blazing-fast analytics over GCP infrastructure logs, application events, and operational signals. No routing through GCS or Dataflow required.
- [The open ecosystem around ClickHouse](https://clickhouse.com/blog/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.
- [92x faster queries: How Open Electricity uses ClickHouse to track Australia’s energy transition in real time](https://clickhouse.com/blog/openelectricity-australia-energy-transition): Open Electricity migrated ~1 billion rows of Australian energy data from Postgres and TimescaleDB to ClickHouse, achieving 92x faster queries on a fraction of the hardware.
- [What a difference 10 years of open source makes](https://clickhouse.com/blog/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.
- [Cisco Talos empowers threat researchers while reducing TCO by 75% with ClickHouse Cloud](https://clickhouse.com/blog/cisco): Cisco Talos runs a threat intelligence reputation service on ClickHouse Cloud, classifying file hashes so researchers can make fast, accurate security decisions.
- [Ten years of ClickHouse in open source](https://clickhouse.com/blog/open-source-10): ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.
- [ClickHouse achieves AWS Retail Competency](https://clickhouse.com/blog/achieves-aws-retail-competency): ClickHouse has achieved the AWS Retail Competency, joining a select group of AWS Partners recognized for deep expertise in helping retailers turn live operational data into real-time decisions.
- [Introducing Postgres to Postgres ClickPipes in ClickHouse Cloud](https://clickhouse.com/blog/clickpipes-postgres-to-postgres): Postgres to Postgres ClickPipes brings fully managed, low-downtime Postgres migrations to ClickHouse Cloud.
- [Building ClickCannon - a tool for benchmarking ClickHouse](https://clickhouse.com/blog/building-clickcannon-a-tool-for-benchmark-clickhouse): What started as an internal sizing tool for ClickStack became ClickCannon: an open-source framework for stress-testing ClickHouse with realistic data and user workloads.
- [Datadog and ClickHouse partner to bring full-fidelity data to modern observability](https://clickhouse.com/blog/datadog-and-clickhouse-partnership): ClickHouse and Datadog are partnering to combine full-fidelity log retention at scale with the powerful search and investigation experience engineers rely on every day.
- [Agents can now provision ClickHouse and Postgres on ClickHouse Cloud](https://clickhouse.com/blog/stripe-projects): One command in the Stripe CLI provisions a ClickHouse or Postgres service on ClickHouse Cloud and hands working credentials straight to your agent, with no UI or manual setup.
- [ClickHouse Agents: Claude-powered agentic analytics, now in public beta](https://clickhouse.com/blog/clickhouse-agents-beta): text
- [How QRT powers real-time research and risk management at petabyte scale](https://clickhouse.com/blog/qrt): How QRT, a cloud-native quantitative investment manager, uses ClickHouse Cloud and ClickStack to power firm-wide research, real-time risk and P&L, and observability at petabyte scale.
- [What's new in clickhousectl v0.3.0](https://clickhouse.com/blog/clickhousectl-v0-3-0): clickhousectl v0.3.0 brings a raft of improvements for the agentic experience, more ways to install, OAuth support for Query Endpoints, and custom configs.
- [ClickHouse appoints new leader for Asia Pacific and expands global go-to-market leadership team](https://clickhouse.com/blog/clickhouse-appoints-apac-leader-and-expands-global-gtm-leadership): ClickHouse, a leader in real-time analytics, data warehousing, observability, and AI/ML, today announced an expansion of its global go-to-market (GTM) leadership team, including the appointment of Ed Lenta as Vice President, Asia Pacific and Japan (APJ).
- [Monitor SLAs and scale ClickHouse Cloud with clickhousectl and agents](https://clickhouse.com/blog/monitor-and-scale-clickhouse-cloud-with-clickhousectl): Tag queries to track per-workload SLAs, then use clickhousectl to investigate breaches and scale ClickHouse Cloud, with an agent to remediate.
- [What to look for when selecting a real-time analytical database](https://clickhouse.com/blog/selecting-a-real-time-analytical-database): Most databases can query fast. Far fewer can query data that arrived seconds ago. Learn what real-time analytics really requires.
- [Click-a-thon 2026: 24 hours, Bengaluru, and the fastest analytical database on the planet](https://clickhouse.com/blog/click-a-thon-2026): ClickHouse's first in-person hackathon in India. August 1–2, Bengaluru. Four tracks, ₹10,00,000 prize pool, 24 hours to ship something real. Applications close June 25.
- [Logging, Metrics, and Distributed Tracing in .NET with OpenTelemetry and ClickStack](https://clickhouse.com/blog/logging-metrics-distributed-tracing-dotnet-otel-clickstack): A walkthrough of adding OpenTelemetry instrumentation to two ASP.NET services — an Order API and a Payment Service — and shipping traces, logs, and metrics to ClickStack, with auto-correlated signals and cross-service trace waterfalls out of the box.
- [How ClickHouse became fast at joins](https://clickhouse.com/blog/clickhouse-fast-joins): Over two years of focused join engineering, ClickHouse became 26× faster on the TPC-H SF100 join-heavy workload. Here’s how parallel hash joins, runtime filters, lazy column replication, and smarter join planning got us there.
- [Building a .NET API Gateway with ClickHouse and Aspire](https://clickhouse.com/blog/dotnet-api-gateway-aspire): A walkthrough of building a .NET API gateway with YARP and Aspire that logs every proxied request to ClickHouse for aggregate analytics, with a materialized view keeping dashboard queries fast as traffic grows.
- [TPC-H for less than a cent: ClickHouse Cloud vs. Snowflake, Databricks, BigQuery, and Redshift](https://clickhouse.com/blog/tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift): ClickHouse Cloud takes on Snowflake, Databricks, BigQuery, and Redshift on TPC-H, ranking first on SF100 cost-performance and running SF10 for less than one cent.
- [ClickHouse Release 26.5](https://clickhouse.com/blog/clickhouse-release-26-05): ClickHouse 26.5 is here! In this release, we have a record number of performance optimizations, a new `filesystem` table function for querying your local file system with SQL, and more!
- [Executable UDFs are now in public beta on ClickHouse Cloud](https://clickhouse.com/blog/executable-udfs-clickhouse-cloud-beta): Today we're excited to announce that executable UDFs are now available in public beta on ClickHouse Cloud. You can write a function in Python, upload it as a zip to your cluster, and call it from SQL like any built-in. ClickHouse manages a pool of long-li
- [Open House 2026 Day 2: 10 years of open source and what the ecosystem is building next](https://clickhouse.com/blog/open-house-2026-day-2): A Day 2 recap of Open House 2026 covering ClickHouse's 10 years of open source, the House Mates partner program launch, and ecosystem announcements from Fivetran, Sigma, dbt, Notion, Replit, and Google Cloud.
- [Open House observability announcements: MCP server, AI Notebooks, and ClickStack Cloud](https://clickhouse.com/blog/observability-mcp-server-ai-notebooks): At Open House 2026, we announced ClickStack Cloud in private preview, AI Notebooks in beta, and the ClickStack MCP server: three updates that make observability on ClickHouse faster to get started with, easier to investigate in, and more composable with y
- [Thank you for building with us](https://clickhouse.com/blog/thank-you-for-building-with-us): Today we welcome over 500 data engineers to our annual user conference in San Francisco and announce some exciting product launches and company milestones.
- [ClickHouse tops $250M ARR and 4,000 customers, launches Claude-powered agents at Open House 2026](https://clickhouse.com/blog/clickhouse-tops-250m-arr-and-4000-customers): ClickHouse today opened Open House 2026, its second annual user conference, with a set of announcements that mark one of the company's most active quarters since founding.
- [5 countries, 12 days, one ClickHouse: inside Alexey's APJ AI Tour](https://clickhouse.com/blog/alexey-apj-ai-tour): 5 Countries, 12 Days, One ClickHouse: Inside Alexey's APJ AI tour
- [Introducing ClickStack Cloud: Serverless observability powered by ClickHouse](https://clickhouse.com/blog/clickstack-cloud-private-preview): Introducing ClickStack Cloud: a fully managed, serverless observability platform built on ClickHouse where you send OpenTelemetry data to a managed endpoint and immediately explore logs, metrics, and traces without operating any infrastructure.
- [Introducing CostBench: an open benchmark for data warehouse cost-performance](https://clickhouse.com/blog/costbench-data-warehouse-cost-performance): Introducing CostBench, an open benchmark that turns cloud data warehouse runtime and billing models into comparable performance-per-dollar results.
- [Introducing House Mates: the ClickHouse partner community and program](https://clickhouse.com/blog/introducing-house-mates): We are launching House Mates, a partner community and program bringing together 60+ ISV, consulting, and channel partners to help customers build, scale, and buy ClickHouse solutions with confidence.
- [Introducing multi-stage distributed query execution in ClickHouse Cloud](https://clickhouse.com/blog/multi-stage-distributed-query-execution-clickhouse-cloud): ClickHouse Cloud introduces multi-stage distributed query execution, a new foundation for scaling single queries across many nodes and accelerating large joins and high-cardinality aggregations.
- [Open House 2026 Day 1: Real-time data without lock-in and what teams can build next](https://clickhouse.com/blog/open-house-2026-day-1): A full recap of Day 1 at Open House 2026, covering every major announcement across ClickHouse Cloud, Postgres, distributed queries, ClickPipes, ClickHouse Agents, Langfuse V4, ClickStack, and the House Mates partner program.
- [Postgres managed by ClickHouse is now in beta](https://clickhouse.com/blog/postgres-managed-by-clickhouse-beta): Postgres managed by ClickHouse is now in public beta - a fully managed, NVMe-backed Postgres service with native CDC into ClickHouse and a unified query layer via pg_clickhouse.
- [Native random sampling in ClickHouse](https://clickhouse.com/blog/native-random-sampling): Learn how to use ClickHouse's SAMPLE BY clause to run fast, approximate queries on large datasets with minimal accuracy trade-off.
- [Integrating the Rust Delta Kernel into ClickHouse](https://clickhouse.com/blog/integrating-rust-delta-kernel): How we integrated the Rust Delta Kernel to replace our native Delta Lake implementation, reducing maintenance overhead while unlocking writes, schema evolution, time travel, and partition pruning.
- [May 2026 newsletter](https://clickhouse.com/blog/202605-newsletter): Welcome to the May 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [clickhousectl v0.2.0: Postgres, ClickPipes and more](https://clickhouse.com/blog/clickhousectl-v0-2-0-postgres-clickpipes-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.
- [What's new in ClickStack - April 2026](https://clickhouse.com/blog/whats-new-in-clickstack-april-2026): ClickStack’s April release
- [How ChatFeatured migrated from PlanetScale Postgres to Postgres Managed by ClickHouse to power AI brand discovery](https://clickhouse.com/blog/chatfeatured): How ChatFeatured cut analytics query times from 2.5 minutes to under a second by migrating from PlanetScale Postgres to Postgres managed by ClickHouse — in just 30 minutes.
- [ClickHouse vs Prometheus for High Cardinality, Part 2: Cardinality in ClickHouse](https://clickhouse.com/blog/clickhouse-vs-promethous-high-cardinality-part-2-cardinality-in-clickhouse): In this blog, we explore why high cardinality behaves fundamentally differently in column-oriented databases like ClickHouse, and why the costs appear in very different places than in traditional series-based systems like Prometheus.
- [How the D. E. Shaw group powers high-cardinality observability at scale with ClickHouse](https://clickhouse.com/blog/deshaw): How the D. E. Shaw group replaced its previous observability platform with ClickHouse to handle high-cardinality metrics at scale, achieving 7x better query performance and enabling multi-year capacity planning across millions of compute workloads.
- [ClickHouse vs Prometheus for High Cardinality, Part 1: Understanding the Problem](https://clickhouse.com/blog/clickhouse-vs-promethous-high-cardinality-p1-understanding-the-problem): Why does high cardinality break Prometheus but not ClickHouse? In Part 1, we explore the architectural tradeoffs of Prometheus and other series-based systems, showing how cardinality impacts memory, ingestion, querying, and operational stability at scale.
- [Postgres FDW: Pushdown is a negotiation](https://clickhouse.com/blog/postgres-fdw-pushdown-negotiation): A deep dive into how pg_clickhouse's Foreign Data Wrapper decides what SQL to push down to ClickHouse versus execute locally in Postgres .
- [ClickStack SQL Charting and Alerting](https://clickhouse.com/blog/clickstack-sql-charting-and-alerting): Learn how ClickStack’s new SQL-powered charting and alerting unlock anomaly detection, rolling baselines, and advanced observability workflows directly on top of ClickHouse, without relying on external tooling.
- [ClickHouse Cloud: Fast, Updatable Lookups with the Join Table Engine](https://clickhouse.com/blog/join-table-engine): Learn how ClickHouse Cloud's Join table engine enables fast, updatable in-memory lookups for dimensional modeling — with automatic upserts, deduplication, and data compaction powered by ReplacingMergeTree under the hood.
- [Powering self-driving vehicle analytics at Avride with ClickHouse Cloud](https://clickhouse.com/blog/avride): Avride replaced Apache Iceberg with ClickHouse Cloud, cutting index lookup latency from 20 seconds to under 100ms and ingestion from hours to seconds.
- [ClickHouse Release 26.4](https://clickhouse.com/blog/clickhouse-release-26-04): ClickHouse 26.4 is here! In this release, more features become SQL compatible, COUNT DISTINCT gets faster, EXPLAIN gets even prettier, and more
- [Introducing Postgres Query Insights in ClickHouse Cloud](https://clickhouse.com/blog/postgres-query-insights-clickhouse-cloud): Query Insights is now in preview for ClickHouse Cloud Managed Postgres: every query pattern your database runs, ranked by impact, with the diagnostic picture of why each one is slow.
- [Agentic analytics starts with query-ready data: the write-side cost of Snowflake vs. ClickHouse](https://clickhouse.com/blog/write-side-cost-performance-snowflake-clickhouse): Agentic analytics makes query-readiness a write-side cost problem. This post compares Snowflake and ClickHouse under continuous ingest, showing how ClickHouse obtains query-ready data at 22× lower cost and delivers 31× better write-side cost-performance.
- [Stop guessing in production: Full fidelity tracing at scale with ClickHouse and Odigos](https://clickhouse.com/blog/odigos-full-fidelity-tracing): How ClickStack and Odigos eliminate observability gaps with zero-code eBPF instrumentation and full-fidelity distributed tracing at scale.
- [Gala supercharges analytics performance with ClickHouse on AWS](https://clickhouse.com/blog/gala): Learn how Gala migrated to the ClickHouse to improve analytics performance and cut costs
- [Goodbye limitations, hello data: How Qonto is rethinking observability with ClickHouse Cloud](https://clickhouse.com/blog/qonto): How Qonto uses ClickHouse Cloud to power observability at scale — replacing sampling and hour-capped queries with two-week query windows, 99.84% compression on high-cardinality data, and an AI incident companion built on the ClickHouse MCP server.
- [Comparing ClickHouse versions with clickhousectl](https://clickhouse.com/blog/clickhousectl-compare-versions): We use clickhousectl to spin up multiple ClickHouse versions side by side and benchmark two recent performance improvements.
- [ClickHouse at Google Cloud Next '26](https://clickhouse.com/blog/google-next-2026-recap): Google Cloud Next is one of the biggest moments in the cloud calendar, and this year ClickHouse made a splash. Not just with a booth, house party and some swag, but a wave of product launches, integrations, and a deepening partnership with Google Cloud.
- [What's New in pg_clickhouse - JSONB Support, SQL value functions, Streaming, and more](https://clickhouse.com/blog/pg_clickhouse-whats-new-april-2026): The latest pg_clickhouse releases bring JSONB, date/time, and array function pushdown, plus HTTP result set streaming for lower memory usage.
- [Do you still need Elasticsearch for log analytics? ClickHouse says no.](https://clickhouse.com/blog/elasticsearch-log-analytics-clickhouse): ClickHouse now brings full-text search and large-scale analytics together in one engine, making it a powerful alternative to Elasticsearch for log analytics. This benchmark shows why.
- [ClickHouse integrates with Lakehouse Runtime Catalog](https://clickhouse.com/blog/google-lakehouse-runtime): We're excited to announce a new integration between ClickHouse and Google's Lakehouse Runtime CatalogCatalog
- [ClickHouse Cloud on Google Cloud Now Powered by Google Axion Processors: 30–55% Faster Queries, ~15% Fewer Compute Credits](https://clickhouse.com/blog/google-axion): We are migrating our Google Cloud fleet to Axion C4A instances. The results: 30–55% faster ClickBench queries and \~15% fewer compute credits across production workloads.
- [Using the ClickHouse MCP server with Google Antigravity](https://clickhouse.com/blog/google-antigravity): Learn how to connect the ClickHouse MCP server to Google Antigravity to query and visualize your data using natural language.
- [Index sharding in ClickHouse Cloud: Petabyte-scale data needs petabyte-scale indexing](https://clickhouse.com/blog/index-sharding-clickhouse-cloud-petabyte-scale-indexing): 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.

## Comparisons

- [ClickHouse and Redshift](https://clickhouse.com/comparison/redshift)
- [ClickHouse vs Snowflake](https://clickhouse.com/comparison/snowflake)
- [ClickHouse and PostgreSQL](https://clickhouse.com/comparison/postgresql)
- [ClickHouse and BigQuery](https://clickhouse.com/comparison/bigquery)
- [ClickStack vs Datadog](https://clickhouse.com/comparison/datadog-for-observability)
- [Migrating from DoubleCloud to ClickHouse](https://clickhouse.com/comparison/doublecloud)
- [ClickStack vs Elastic Observability](https://clickhouse.com/comparison/elastic-for-observability)
- [Migrating from Imply to ClickHouse](https://clickhouse.com/comparison/imply)
- [ClickStack vs OpenSearch](https://clickhouse.com/comparison/opensearch-for-observability)
- [Migrating from \[Rockset\] to ClickHouse](https://clickhouse.com/comparison/rockset)
- [ClickStack vs Splunk](https://clickhouse.com/comparison/splunk-for-observability)

## Integrations

- [C# / .NET](https://clickhouse.com/integrations/csharp)
- [Python](https://clickhouse.com/integrations/python)
- [Java](https://clickhouse.com/integrations/java)
- [Node.js](https://clickhouse.com/integrations/nodejs)
- [Go](https://clickhouse.com/integrations/go)
- [Airbyte](https://clickhouse.com/integrations/airbyte)
- [Amazon S3](https://clickhouse.com/integrations/amazon_s3)
- [Apache Airflow](https://clickhouse.com/integrations/apache_airflow)
- [CloudQuery](https://clickhouse.com/integrations/cloudquery)
- [Confluent Cloud](https://clickhouse.com/integrations/confluent)
- [Google Cloud Storage (GCS)](https://clickhouse.com/integrations/gcs)
- [Kafka](https://clickhouse.com/integrations/kafka)
- [MySQL](https://clickhouse.com/integrations/mysql)
- [PostgreSQL](https://clickhouse.com/integrations/postgres)
- [Streamkap](https://clickhouse.com/integrations/streamkap)
- [Deepnote](https://clickhouse.com/integrations/deepnote)
- [Grafana](https://clickhouse.com/integrations/grafana)
- [Metabase](https://clickhouse.com/integrations/metabase)
- [Splunk](https://clickhouse.com/integrations/splunk)
- [Superset](https://clickhouse.com/integrations/superset)
- [Tableau](https://clickhouse.com/integrations/tableau)
- [ClickHouse Client](https://clickhouse.com/integrations/clickhouse_client)
- [DataGrip](https://clickhouse.com/integrations/datagrip)
- [DBeaver](https://clickhouse.com/integrations/dbeaver)
- [dbt](https://clickhouse.com/integrations/dbt)
- [Microsoft Azure Data Factory](https://clickhouse.com/integrations/azure-data-factory)
- [Microsoft Azure Synapse](https://clickhouse.com/integrations/azure-synapse)
- [C](https://clickhouse.com/integrations/c-client)
- [Hex](https://clickhouse.com/integrations/hex)
- [pg_clickhouse](https://clickhouse.com/integrations/pg-clickhouse)
- [Vector](https://clickhouse.com/integrations/vector)
- [Prequel](https://clickhouse.com/integrations/prequel)

## Optional

### Resources

- [What is OpenTelemetry (OTel)?](https://clickhouse.com/resources/engineering/opentelemetry-otel)
- [Avro vs Parquet](https://clickhouse.com/resources/engineering/avro-vs-parquet)
- [How to scale vector search in Postgres (pgvector) for RAG and AI agents: memory limits, filtering, and when to go hybrid](https://clickhouse.com/resources/engineering/scale-vector-search-postgres)
- [How to architect multi-tenant SaaS on Postgres](https://clickhouse.com/resources/engineering/multi-tenant-saas-postgres-architecture)
- [Best AlloyDB alternatives in 2026 for enterprise PostgreSQL workloads](https://clickhouse.com/resources/engineering/alloydb-alternatives)
- [The 5 best AWS RDS alternatives in 2026 (pricing, performance, and migration)](https://clickhouse.com/resources/engineering/aws-rds-alternatives)
- [6 Amazon Aurora alternatives for high-volume ingestion (2026 guide)](https://clickhouse.com/resources/engineering/aws-aurora-alternatives)
- [Managed Postgres providers for multitenant SaaS apps: a workload-based 2026 comparison](https://clickhouse.com/resources/engineering/managed-postgres-providers-multitenant-saas)
- [Best Postgres hosting providers for startups in 2026: 8 managed PostgreSQL options compared](https://clickhouse.com/resources/engineering/postgres-hosting-startups-2026)
- [Best Postgres hosting providers for AI agents in 2026](https://clickhouse.com/resources/engineering/postgres-hosting-ai-agents)
- [Snowflake alternatives in 2026: competitors compared by workload, cost, and latency](https://clickhouse.com/resources/engineering/snowflake-alternatives-2026-guide)
- [Best BigQuery alternatives in 2026 (cost, latency, and workload fit)](https://clickhouse.com/resources/engineering/bigquery-alternatives-2026)
- [Best Amazon Redshift alternatives (2026) for real-time analytics: cost, tuning, and latency](https://clickhouse.com/resources/engineering/redshift-alternatives-2026)
- [8 Neon alternatives for managed Postgres in 2026](https://clickhouse.com/resources/engineering/neon-alternatives-managed-postgres)
- [How to choose the right managed Postgres provider in 2026](https://clickhouse.com/resources/engineering/choose-managed-postgresql-provider)
- [8 Crunchy Bridge alternatives for managed PostgreSQL in 2026](https://clickhouse.com/resources/engineering/crunchy-bridge-alternatives)
- [10 Azure Database for PostgreSQL alternatives in 2026](https://clickhouse.com/resources/engineering/azure-postgresql-alternatives)
- [10 Heroku Postgres alternatives for production managed PostgreSQL in 2026](https://clickhouse.com/resources/engineering/heroku-postgres-alternatives)
- [Build a stock reservation API with Hono, Bun, and ClickHouse Managed Postgres](https://clickhouse.com/resources/engineering/build-stock-reservation-api-hono-bun-postgres)
- [Build a workshop booking API with FastAPI, SQLAlchemy, and Postgres](https://clickhouse.com/resources/engineering/build-workshop-booking-api-fastapi-sqlalchemy-postgres)
- [Build a feature request board with Next.js, Prisma, and Postgres](https://clickhouse.com/resources/engineering/build-feature-request-board-nextjs-prisma-postgres)
- [Build a SaaS link shortener with Postgres and ClickHouse](https://clickhouse.com/resources/engineering/build-saas-link-shortener-postgres-clickhouse)
- [ClickHouse vs PostgreSQL for Analytics: How to Choose (2026)](https://clickhouse.com/resources/engineering/clickhouse-vs-postgresql-analytics)
- [Self-hosted vs. managed PostgreSQL: when to switch](https://clickhouse.com/resources/engineering/self-hosted-vs-managed-postgresql)
- [Building report results and run history with ClickHouse Cloud](https://clickhouse.com/resources/engineering/building-report-results-and-run-history-with-clickhouse-cloud)
- [Best managed Postgres for analytics in 2026: Top services compared for OLAP workloads](https://clickhouse.com/resources/engineering/managed-postgres-analytics-2026)
- [What is synthetic monitoring?](https://clickhouse.com/resources/engineering/what-is-synthetic-monitoring)
- [What is SRE? Site reliability engineering explained](https://clickhouse.com/resources/engineering/what-is-sre)
- [What is shadow AI? The governance gap in AI adoption](https://clickhouse.com/resources/engineering/what-is-shadow-ai)
- [What is real user monitoring (RUM)?](https://clickhouse.com/resources/engineering/what-is-real-user-monitoring)
- [What is platform engineering?](https://clickhouse.com/resources/engineering/what-is-platform-engineering)
- [What is MELT? Metrics, events, logs, and traces explained](https://clickhouse.com/resources/engineering/what-is-melt)
- [What is log management? Lifecycle, retention, and tooling](https://clickhouse.com/resources/engineering/what-is-log-management)
- [What is log analytics? Querying logs at scale](https://clickhouse.com/resources/engineering/what-is-log-analytics)
- [What is log aggregation? Centralizing logs from every service](https://clickhouse.com/resources/engineering/what-is-log-aggregation)
- [What is eBPF? Kernel-level observability without code changes](https://clickhouse.com/resources/engineering/what-is-ebpf)
- [What is distributed tracing? Traces, spans, and context propagation](https://clickhouse.com/resources/engineering/what-is-distributed-tracing)
- [What is AIOps, and what does it actually deliver?](https://clickhouse.com/resources/engineering/what-is-aiops)
- [What is AI agent observability?](https://clickhouse.com/resources/engineering/what-is-ai-agent-observability)
- [The three pillars of observability - and where the model breaks](https://clickhouse.com/resources/engineering/three-pillars-of-observability)

_(178 more not listed — see /sitemap.xml)_

### Videos

- [Quick Start on ClickHouse: From Schema to Streaming Data](https://clickhouse.com/videos/quick-start-on-clickhouse)
- [Blacksmith + ClickHouse](https://clickhouse.com/videos/blacksmith)
- [Attentive + ClickHouse](https://clickhouse.com/videos/attentive)
- [RunReveal + ClickHouse](https://clickhouse.com/videos/runreveal)
- [Klaviyo + ClickHouse](https://clickhouse.com/videos/klaviyo)
- [Huntress + ClickHouse](https://clickhouse.com/videos/huntress)
- [Ramp + ClickHouse](https://clickhouse.com/videos/ramp)
- [Open House 2025: Data infrastructure for AI at scale](https://clickhouse.com/videos/data-infrastructure-for-ai-at-scale)
- [MCP for real-time anaytics panel discussion](https://clickhouse.com/videos/mcp-for-real-time-anaytics-panel-discussion)
- [Open House 2025: How is the AI Made? The Data Behind Language Models](https://clickhouse.com/videos/how-is-the-ai-made-the-data-behind-language-models)
- [Open House 2025: ClickHouse for AI/ML: An overview](https://clickhouse.com/videos/clickhouse-for-ai-ml-an-overview)
- [Open House 2025: ClickHouse's internal data warehouse](https://clickhouse.com/videos/clickhouse-internal-data-warehouse)
- [Batch and real-time analytics at Lyft: Powering decisions with ClickHouse](https://clickhouse.com/videos/lyft)
- [Open House 2025: Lakehouse with ClickHouse](https://clickhouse.com/videos/lakehouse-with-clickhouse)
- [Open House 2025: ClickHouse and JOINs](https://clickhouse.com/videos/clickhouse-and-joins)
- [Open House 2025: Evolutions in Data Warehousing](https://clickhouse.com/videos/evolutions-in-data-warehousing)
- [How ClickHouse helps Anthropic scale observability](https://clickhouse.com/videos/anthropic)
- [Open House 2025: LogHouse - How ClickHouse built our internal logging platform](https://clickhouse.com/videos/loghouse)
- [Tesla-scale metrics with ClickHouse](https://clickhouse.com/videos/tesla)
- [Open House 2025: ClickHouse observability - Introducing ClickStack](https://clickhouse.com/videos/clickstack)
- [ClickHouse at Exabeam: Scalable search for security analytics](https://clickhouse.com/videos/exabeam)
- [How Sierra.ai unifies observability & analytics with ClickHouse](https://clickhouse.com/videos/sierraai)
- [Open House 2025: ClickHouse core database innovations for real-time analytics](https://clickhouse.com/videos/clickhouse-core-database-innovations-for-real-time-analytics)
- [Open House 2025: Postgres and ClickHouse: the default data stack](https://clickhouse.com/videos/postgres-and-clickhouse-the-default-data-stack)
- [Open House 2025: ClickHouse for Real-Time Analytics](https://clickhouse.com/videos/clickhouse-for-real-time-analytics)
- [Weights & Biases + ClickHouse: Powering developer tools for AI](https://clickhouse.com/videos/weights-and-biases)
- [Open House SF 2025: Keynote](https://clickhouse.com/videos/openhouse-keynote-2025)
- [Canva Migrating Production Observability Workloads onto ClickHouse](https://clickhouse.com/videos/open-house-sydney-canva)
- [Sauce AI From Chaos to Clarity - Scaling Hybrid Vector Search](https://clickhouse.com/videos/open-house-sydney-sauce-ai)
- [Laravel discuss Nightwatch](https://clickhouse.com/videos/open-house-sydney-laravel)

_(611 more not listed — see /sitemap.xml)_

### Legal

- [General Terms and Conditions](https://clickhouse.com/legal/clickhouse-general-terms-and-conditions)
- [Legal Policy Updates](https://clickhouse.com/legal/legal-subscription)
- [Langfuse Cloud Sub-Processors and Affiliates](https://clickhouse.com/legal/agreements/langfuse-subprocessors)
- [ClickHouse Security Cloud Preview Addendum](https://clickhouse.com/legal/clickHouse-security-cloud-preview-addendum)
- [Product Addenda](https://clickhouse.com/legal/product-addenda)
- [ClickHouse Sub-Processors and Affiliates](https://clickhouse.com/legal/agreements/subprocessors)
- [ClickHouse Security Cloud Preview Sub-Processors and Affiliates](https://clickhouse.com/legal/agreements/security-cloud-preview-subprocessors-and-affiliates)
- [ClickHouse Security Cloud Preview Security Terms](https://clickhouse.com/legal/agreements/clickhouse-security-cloud-preview-security-addendum)
- [Vendor Data Processing Addendum](https://clickhouse.com/legal/procurement/vendor-data-processing-addendum)
- [Vendor Information Security Addendum](https://clickhouse.com/legal/procurement/pssubcontractor-security-addendum)
- [Vendor Legal Terms](https://clickhouse.com/legal/procurement)
- [ClickHouse Support Services Policy](https://clickhouse.com/legal/support-services-policy)
- [ClickHouse Cloud Service Level Agreement](https://clickhouse.com/legal/agreements/service-level-agreement)
- [ClickHouse Information Security Addendum](https://clickhouse.com/legal/agreements/security-addendum)
- [ClickHouse trademark policy](https://clickhouse.com/legal/trademark-policy)

_(24 more not listed — see /sitemap.xml)_