# 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 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.
- [House Party](https://clickhouse.com/houseparty/google-next): Ready to trade dashboards for dance floors? Join us in Vegas during Google Cloud Next for House Party with The Chainsmokers 2026. Step away from the tech talk, grab a drink, and get ready for a night of music, energy, and unforgettable vibes.
- [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.
- [Data Warehousing with ClickHouse](https://clickhouse.com/learn/data-warehousing): Design, build, and optimize modern data warehouses using ClickHouse.
- [ML and GenAI | ClickHouse Training](https://clickhouse.com/learn/machine-learning-and-data-science): Use ClickHouse to prepare data, feed models, and support GenAI workflows at scale.
- [ClickStack: The high-performance observability stack](https://clickhouse.com/learn/observability): Ingest logs, metrics, and traces to monitor systems and power observability dashboards.
- [Real-time analytics with ClickHouse](https://clickhouse.com/learn/real-time-analytics): Learn how to power real-time dashboards, alerts, and event-driven apps with ClickHouse.
- [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)
- [The open platform for AI on real-time data](https://clickhouse.com/pt/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.
- [chDB - fast, reliable, and scalable in-process database](https://clickhouse.com/pt/chdb): Experience the power of ClickHouse, in-process. With unparalleled performance, reliability, and scalability for any data-intensive application.
- [The fastest open-source analytical database](https://clickhouse.com/pt/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.
- [Open source observability for OpenTelemetry at scale](https://clickhouse.com/pt/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/pt/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.
- [ClickPipes](https://clickhouse.com/pt/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/pt/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/pt/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/pt/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.
- [Contact us](https://clickhouse.com/pt/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/pt/company/news): Read the latest news and press releases from ClickHouse, including company updates and external media coverage.
- [Who we are](https://clickhouse.com/pt/company/our-story): Find out about our leadership, history, and the culture we’re building, a little at a time.
- [Our demo applications](https://clickhouse.com/pt/demos): Discover demos powered by ClickHouse
- [Pricing](https://clickhouse.com/pt/pricing): Options for every user, organization, and use case. Explore ClickHouse Cloud pricing plans and find the right fit for your workload.
- [Data warehousing with ClickHouse](https://clickhouse.com/pt/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/pt/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/pt/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/pt/use-cases): Unlock faster queries and the ability to handle greater concurrency. No matter how much data you're working with.
- [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

- [Measuring real-time performance per dollar under continuous load: CostBench’s first end-to-end results](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): Three teams share why they migrated production Postgres workloads from Neon to ClickHouse Managed Postgres and how ClickPipes helped them cut over in hours.
- [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.
- [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 28 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.
- [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.
- [How Mercado Libre rebuilt its observability platform on ClickHouse Cloud with 50x 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 50x speedup) with up to 89% compression while ingesting 400 million spans per minute.
- [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.
- [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.
- [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.
- [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.
- [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.
- [ClickHouse expands strategic collaboration with Google Cloud, bringing deeper integration, cloud flexibility, and next-generation performance](https://clickhouse.com/blog/clickhouse-expands-strategic-collaboration-with-google-cloud): ClickHouse, a leader in real-time analytics, data warehousing, observability, and AI/ML, today at Google Next 26 announced a significant expansion of its strategic collaboration with Google Cloud.
- [Terraform & OpenAPI for ClickPipes is now Generally Available](https://clickhouse.com/blog/terraform-ga): Provision and manage ClickPipes resources “as code” using Terraform and OpenAPI, now with full connector coverage and improved usability
- [otel.fyi - OTel Collector docs made simple](https://clickhouse.com/blog/otel-fyi): otel.fyi is a search-first site for OpenTelemetry Collector docs, making it easy to quickly find and understand configuration for receivers, processors, exporters, and extensions without digging through scattered documentation.
- [“A generational leap”: How Trio unified payment analytics and cut storage by 88% with ClickHouse Cloud](https://clickhouse.com/blog/trio): Brazilian fintech Trio cut storage by 88% and achieved a "generational leap" in speed by building a unified payment analytics platform on ClickHouse Cloud, handling 243M+ payments and 1B+ daily events with a sliding window approach for late and duplicate
- [April 2026 newsletter](https://clickhouse.com/blog/202604-newsletter): Welcome to the April 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [Getting started with clickhousectl: the ClickHouse CLI for local and cloud](https://clickhouse.com/blog/getting-started-clickhousectl): A hands-on guide to clickhousectl, the ClickHouse CLI. Install it, scaffold a project, manage local servers, connect to ClickHouse Cloud, and set up CI/CD — all from your terminal.
- [Our vision for the ClickHouse Grafana plugin](https://clickhouse.com/blog/grafana-plugin-vision): We see ClickHouse and Grafana as a key part of the observability experience. Here's our vision for making the plugin more powerful and easier to use.
- [Index-based pruning in ClickHouse](https://clickhouse.com/blog/index-based-pruning): Learn how ClickHouse uses primary indexes, lightweight projections, and skip indexes to prune data before reading it. Demonstrated on a 243 million row UK property sales dataset.
- [What's new in ClickStack - March 2026](https://clickhouse.com/blog/whats-new-in-clickstack-march-2026): ClickStack’s March release introduces smarter Event Deltas, AI-powered notebooks, and full SQL chart flexibility, making investigation faster and dashboards more powerful.
- [Agentic coding with ClickHouse. One person, one data stack, one full-stack application](https://clickhouse.com/blog/agentic-coding-app): A Solutions Architect’s experience building a retail analytics platform with AI agents, real-time dashboards, and full observability on the ClickHouse data platform
- [Mintlify boosts NPS 30% and saves 60% with real-time analytics on ClickHouse Cloud](https://clickhouse.com/blog/mintlify): Mintlify replaced PostHog with ClickHouse Cloud, cutting dashboard load times from tens of seconds to under a second, eliminating rate limit errors, and achieving a 30% NPS improvement at 60% lower cost.
- [Introducing clickhousectl: the CLI for ClickHouse local and cloud (beta)](https://clickhouse.com/blog/introducing-clickhousectl-official-cli-for-clickhouse-local-and-cloud): clickhousectl is the official CLI for ClickHouse. It manages local installations, runs local servers, and operates ClickHouse Cloud. It's designed to work for humans and AI agents alike.
- [ClickHouse at FOSDEM 2026](https://clickhouse.com/blog/clickhouse-at-fosdem-2026): FOSDEM 2026 took place on 31 January and 1 February in Brussels, and it was a great weekend for the ClickHouse community, both inside the conference rooms and out.
- [The three villains to agentic observability: retention, sampling and rollups](https://clickhouse.com/blog/three-villains-agentic-observability): Retention limits, sampling, and metric roll-ups aren't observability best practices - they're workarounds for storage systems that can't handle full-fidelity data, and they're becoming a hard blocker for AI-driven workflows.
- [How Eisan made POS analytics faster, cheaper, and more reliable with ClickHouse Cloud](https://clickhouse.com/blog/eisan): Rill uses ClickHouse to power real-time operational BI for 100B+ daily events, enabling instant exploration and conversational analytics directly against live datasets through a declarative, BI-as-code workflow.
- [ClickHouse Release 26.3](https://clickhouse.com/blog/clickhouse-release-26-03): ClickHouse 26.3 is here! In this release, async inserts are turned on by default, we've got more JOIN reordering, materialized CTES have arrived, and more!
- [How Respan is scaling LLM observability with ClickHouse Cloud](https://clickhouse.com/blog/respan-ai-llm-observability): Respan AI uses ClickHouse Cloud to power high-throughput LLM observability across 50 million daily events. After outgrowing Postgres at 50-100 writes per second, the team migrated ingestion and analytics to ClickHouse Cloud. Incremental materialized views
- [PostgresBench: A Reproducible Benchmark for Postgres Services](https://clickhouse.com/blog/postgresbench): Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
- [Rill and ClickHouse: real-time operational BI for a metered world](https://clickhouse.com/blog/rill): Rill uses ClickHouse to power real-time operational BI for 100B+ daily events, enabling instant exploration and conversational analytics directly against live datasets through a declarative, BI-as-code workflow.
- [Announcing Role Based Access Control in ClickStack](https://clickhouse.com/blog/role-based-access-control-clickstack): ClickStack now supports Role-Based Access Control, giving teams precise control over who can access dashboards, searches, and notebooks. With flexible roles, fine-grained permissions, and seamless ClickHouse Cloud integration.
- [Agentic coding at ClickHouse](https://clickhouse.com/blog/agentic-coding): How to remain competitive in the AI era of software engineering
- [We taught ClickStack to read your logs like a detective novel](https://clickhouse.com/blog/clickstack-read-logs-detective-novel): ClickStack gets a literary upgrade with "AI Summarize", transforming raw logs into vivid, story-driven narratives that finally explain what's really happening in your systems.
- [ClickHouse BYOC on Google Cloud now Generally Available](https://clickhouse.com/blog/byoc-gcp-ga): Run ClickHouse in your own Google Cloud account : with full data sovereignty, zero-trust networking, and a managed control plane.
- [How Padlet uses ClickHouse Cloud to power real-time classroom analytics](https://clickhouse.com/blog/padlet): Padlet uses ClickHouse Cloud to deliver real-time classroom analytics at scale, supporting billions of events per month with sub-second queries and no dedicated data team.
- [How we’re building a data platform for a new user: agents](https://clickhouse.com/blog/building-a-data-platform-for-agents): Agents need real-time ingestion, fast aggregation, flexible handling of semi-structured events, low-latency concurrency, and economics that still work at massive scale. ClickHouse already has this foundation
- [Top 10 best practices tips for ClickHouse](https://clickhouse.com/blog/10-best-practice-tips): Ten best practices for getting the most out of ClickHouse, from primary key design and data types to materialized views, ReplacingMergeTree, and join optimization — illustrated with benchmarks on a 150M row dataset.
- [More Visibility, Less Guesswork: ClickHouse Cloud's New Monitoring Capabilities](https://clickhouse.com/blog/clickhouse-cloud-new-monitoring-capabilities): ClickHouse Cloud's new monitoring capabilities give platform administrators deeper visibility into their deployments, with a unified Overview page, infrastructure scaling insights, and automatic email and Slack notifications for common issues.
- [ClickHouse is data lake ready](https://clickhouse.com/blog/clickhouse-is-data-lake-ready): ClickHouse now supports direct querying of Iceberg and Delta Lake formats across major cloud catalogs without requiring data migration.
- [Intelligent security at ClickHouse speed: How Cogent Security built an AI-native vulnerability management platform](https://clickhouse.com/blog/cogent-security): "The key thing that ClickHouse unlocks for AI is speed. Everything we do needs to be done at machine speed to counter AI-enabled attackers.” Karan Gugle, Founding Engineer
- [Building high-performance full-text search for object storage](https://clickhouse.com/blog/clickhouse-full-text-search-object-storage): High-performance full-text search, even on object storage. This deep dive from the ClickHouse engineers explains the new text index design and how it keeps queries fast at scale.
- [Smarter Auto-Scaling for ClickHouse: The Two-Window Approach](https://clickhouse.com/blog/smarter-auto-scaling): How ClickHouse Cloud's two-window recommender and target-tracking CPU algorithm cut scale-down latency from 30 hours to 3 hours while eliminating oscillations and reducing infrastructure costs.
- [Structured Logging in .NET with Serilog and ClickHouse](https://clickhouse.com/blog/serilog): Learn how to send structured .NET logs directly to ClickHouse using Serilog — with full schema control, full-text search, and SQL queries over your log data.
- [Querying DateTimes in ClickHouse](https://clickhouse.com/blog/querying-datetimes): How to query datetime columns in ClickHouse - from hourly bucketing to rush hour analysis with real taxi data.
- [March 2026 newsletter](https://clickhouse.com/blog/202603-newsletter): Welcome to the March 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
- [How ClickStack makes ClickHouse faster for observability](https://clickhouse.com/blog/clickstack-faster-observability): ClickHouse is fast by design, but raw database speed isn't enough. This post explores how ClickStack tightly integrates with ClickHouse to generate optimized queries — from progressive time window pagination and chunked charts to automatic use of materi
- [Introducing AI observability notebooks for Managed ClickStack in Private Preview](https://clickhouse.com/blog/clickstack-ai-notebooks): AI-native observability notebooks for Managed ClickStack let engineers investigate logs, metrics, and traces with AI as a collaborator — keeping humans in control at every step.
- [How Socialpruf built a faster, more reliable data stack by replacing Neon with Postgres managed by ClickHouse](https://clickhouse.com/blog/socialpruf): Socialpruf migrated from Neon to Postgres managed by ClickHouse, eliminating network transfer costs and achieving up to 5x faster query performance while powering real-time social analytics dashboards that aggregate millions of rows in milliseconds.
- [AI is redrawing the database market](https://clickhouse.com/blog/ai-redrawing-database-market): AI is reshaping database market requirements across real-time analytics, data warehousing, and observability — and ClickHouse is uniquely positioned to meet them.
- [Designing the new async-native ClickHouse Python client](https://clickhouse.com/blog/python-async-native-client): clickhouse-connect v0.12.0 ships a ground-up async-native Python client using the half-sync/half-async pattern, delivering 1.16x better throughput and dramatically more stable tail latency under high concurrency.
- [ClickHouse Release 26.2](https://clickhouse.com/blog/clickhouse-release-26-02): ClickHouse 26.2 is here! In this post, text-index and QBit data type become production-ready.
- [Unordered mode for GCS ClickPipes is now available](https://clickhouse.com/blog/clickpipes-gcs-unordered-mode): You can now ingest data from Google Cloud Storage into ClickHouse Cloud in any order for event-driven, blazing-fast analytics.
- [AI doesn’t always generate perfect ClickHouse schemas (yet)](https://clickhouse.com/blog/ai-generated-clickhouse-schemas-mistakes-and-advice): This post walks through the common pitfalls we see when AI generates ClickHouse schemas, drawn from real conversations with our Solutions Architecture team and patterns across dozens of customer engagements.
- [5 ways to parse Dates and DateTimes in ClickHouse](https://clickhouse.com/blog/parsing-dates-datetimes): 5 Ways to Parse Dates and DateTimes in ClickHouse
- [What's new in ClickStack. February '26.](https://clickhouse.com/blog/whats-new-in-clickstack-february-2026): Februarys' ClickStack update brings major improvements to both Cloud and open source, including new query workflows, enhanced metrics exploration, performance optimizations, and expanded alerting options.
- [Announcing chDB 4: write Pandas, run ClickHouse, now on Hex](https://clickhouse.com/blog/chdb.4-0-pandas-hex): Today, we're launching chDB 4 together with HexEX, where it is available along with the new Pandas-like DataStore API as a native integration
- [GitTrends: A Google Trends style view of the GitHub ecosystem](https://clickhouse.com/blog/gittrends): Search and uncover technology trends across 10 billion GitHub events in real time.
- [Announcing General Availability of ClickHouse Full-text Search](https://clickhouse.com/blog/full-text-search-ga-release): Full-text Search is now GA in ClickHouse
- [How Critical Manufacturing uses ClickHouse to bring real-time intelligence to the factory floor](https://clickhouse.com/blog/criticial-manufacturing): “ClickHouse was the perfect fit for what we were doing. It just worked.” Ricardo Magalhaes, Lead Software Engineer
- [What Replo learned optimizing 100+ billion events in ClickHouse](https://clickhouse.com/blog/replo): Replo uses ClickHouse to analyze 100+ billion events in real time, keeping analytics dashboards fast and responsive for 4,000+ Shopify merchants.

## 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

- [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)
- [Python](https://clickhouse.com/integrations/python)
- [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)
- [Node.js](https://clickhouse.com/integrations/nodejs)
- [Go](https://clickhouse.com/integrations/go)
- [C#](https://clickhouse.com/integrations/csharp)
- [Java](https://clickhouse.com/integrations/java)
- [Prequel](https://clickhouse.com/integrations/prequel)

## Optional

### Resources

- [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 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 managed Postgres for analytics in 2026: Top services compared for OLAP workloads](https://clickhouse.com/resources/engineering/managed-postgres-analytics-2026)
- [Best Amazon Redshift alternatives (2026) for real-time analytics: cost, tuning, and latency](https://clickhouse.com/resources/engineering/redshift-alternatives-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)
- [What is tail latency? Why p99 spikes when averages look fine](https://clickhouse.com/resources/engineering/tail-latency)
- [SLOs, SLIs, and SLAs: definitions, differences, and worked examples](https://clickhouse.com/resources/engineering/slo-sli-sla)
- [RUM vs synthetic monitoring: which do you need?](https://clickhouse.com/resources/engineering/rum-vs-synthetic-monitoring)
- [What is root cause analysis? Methods, process, and limits](https://clickhouse.com/resources/engineering/root-cause-analysis)
- [RED method vs USE method: which should you use?](https://clickhouse.com/resources/engineering/red-use-methods)
- [Percentiles vs averages: why your latency dashboard lies](https://clickhouse.com/resources/engineering/percentiles-vs-averages)
- [OpenTelemetry's profiles signal enters public alpha](https://clickhouse.com/resources/engineering/otel-news-profiles-signal)
- [OpenTelemetry semantic conventions explained](https://clickhouse.com/resources/engineering/opentelemetry-semantic-conventions)
- [OpenTelemetry histograms explained: buckets, exponential histograms, and percentiles](https://clickhouse.com/resources/engineering/opentelemetry-histograms)
- [Observability vs visibility: the terms teams conflate](https://clickhouse.com/resources/engineering/observability-vs-visibility)
- [Observability vs monitoring: what''s actually different](https://clickhouse.com/resources/engineering/observability-vs-monitoring)
- [Observability architecture: how the pieces fit together](https://clickhouse.com/resources/engineering/observability-architecture)
- [What is MTTR? MTTD, MTBF, and the incident metrics that matter](https://clickhouse.com/resources/engineering/mttr-mttd)
- [LLM inference latency: TTFT, tokens per second, and what to measure](https://clickhouse.com/resources/engineering/llm-inference-latency)
- [LLM guardrails: what they are and how to run them in production](https://clickhouse.com/resources/engineering/llm-guardrails)
- [The incident response process: from alert to postmortem](https://clickhouse.com/resources/engineering/incident-response-process)
- [What are the four golden signals of monitoring?](https://clickhouse.com/resources/engineering/golden-signals)

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

### Videos

- [ClickHouse now supports years 0000–9999](https://clickhouse.com/videos/years-0000-9999)
- [ClickHouse v26.8 Release Webinar](https://clickhouse.com/videos/clickhouse-release-26-08)
- [20VC and Aaron Katz: AI Margins Need to Improve | Revenue Concentration Should be a Concern](https://clickhouse.com/videos/20vc-aaron-katz-ai-margins-need-to-improve)
- [Data Architecture Blueprints featuring Zappi](https://clickhouse.com/videos/202608-AMER-Webinar-Data-Architecture-Zappi)
- [Scaling observability at Nine with ClickHouse](https://clickhouse.com/videos/open-house-sydney-nine-observability)
- [Seeing the invisible: making Xero's network observable with ClickHouse](https://clickhouse.com/videos/open-house-sydney-xero-observability)
- [How Canva built an agentic support experience using Langfuse observability](https://clickhouse.com/videos/open-house-sydney-canva-langfuse)
- [Buildkite and ClickHouse: A story of a trillion tests](https://clickhouse.com/videos/open-house-sydney-buildkite-real-time-analytics)
- [Neara and ClickStack: An observability journey](https://clickhouse.com/videos/open-house-sydney-neara-clickstack)
- [Measuring the True Cost of Real-Time Analytics](https://clickhouse.com/videos/202608-EMEA-Webinar-Costbench)
- [ClickHouse Delhi/Gurgaon Meetup - Zykrr](https://clickhouse.com/videos/meetupdeljul1802)
- [ClickHouse Delhi/Gurgaon Meetup - T9L](https://clickhouse.com/videos/meetupdeljul1801)
- [ClickHouse Bangalore Meetup - Velocity](https://clickhouse.com/videos/meetupblrapr1804)
- [ClickHouse Bangalore Meetup - Linkrunner](https://clickhouse.com/videos/meetupblrapr1803)
- [ClickHouse Bangalore Meetup - Agentic Coding at ClickHouse](https://clickhouse.com/videos/meetupblrapr1802)
- [ClickHouse Bangalore Meetup - CTO Q&A with Alexey Milovidov](https://clickhouse.com/videos/meetupblrapr1801)
- [Circle Sessions: Aaron Katz, Co-Founder + CEO at ClickHouse](https://clickhouse.com/videos/circle-sessions-aaron-katz)
- [ClickHouse Meetup Toronto: Alexei Zenin](https://clickhouse.com/videos/meetuptorjun0201)
- [ClickStack in Practice: A Demo of ClickHouse-Powered Observability](https://clickhouse.com/videos/202608-ClickStack-Webinar)
- [Clickhouse Meetups SF Flagright](https://clickhouse.com/videos/meetupsf_july02)
- [Clickhouse Meetups New York Converge](https://clickhouse.com/videos/meetupnyjuly08)
- [Clickhouse Meetups SF PromptQL](https://clickhouse.com/videos/meetupsf_july01)
- [Build Better LLM Apps with Langfuse](https://clickhouse.com/videos/Build-Better-LLM-Apps)
- [How to build a unified data stack with Postgres and ClickHouse](https://clickhouse.com/videos/202607-AMER-Webinar-Postgres-ClickHouse)
- [Analytics at Ada: Journey to ClickHouse](https://clickhouse.com/videos/toronto-meetupSep2)
- [ClickHouse v26.7 Release Webinar](https://clickhouse.com/videos/clickhouse-release-26-07)
- [Zoox's migration from ClickHouse open source to BYOC](https://clickhouse.com/videos/openhouse-zoox)
- [Vector embeddings in ClickHouse with Ollama and OpenAI](https://clickhouse.com/videos/vector-embeddings-ollama-openai)
- [Building real-time applications with ClickHouse Materialized Views](https://clickhouse.com/videos/building-real-time-applications-with-clickhouse-materialized-views)
- [Open House 2025: ClickHouse for AI/ML: An overview](https://clickhouse.com/videos/clickhouse-for-ai-ml-an-overview)

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

### Legal

- [ClickHouse Information Security Addendum](https://clickhouse.com/legal/agreements/security-addendum)
- [ClickHouse Microsoft Fabric Workload Attestation](https://clickhouse.com/legal/clickhouse-microsoft-fabric-workload-attestation)
- [ClickHouse for Microsoft Fabric Addendum](https://clickhouse.com/legal/clickhouse-for-fabric-addendum)
- [Langfuse Cloud Sub-Processors and Affiliates](https://clickhouse.com/legal/agreements/langfuse-subprocessors)
- [ClickHouse Cloud and ClickHouse BYOC Sub-Processors and Affiliates](https://clickhouse.com/legal/agreements/clickhouse-subprocessors)
- [Modern Slavery & Human Trafficking Statement](https://clickhouse.com/legal/modern-slavery-human-trafficking-statement)
- [ClickHouse Acceptable Use Policy](https://clickhouse.com/legal/agreements/acceptable-use-policy)
- [ClickHouse Self-Managed Addendum](https://clickhouse.com/legal/clickhouse-self-managed-addendum)
- [ClickHouse Cloud Startup Program Agreement](https://clickhouse.com/legal/agreements/cloud-startup-program)
- [How To Find Langfuse Org ID](https://clickhouse.com/legal/how-to-find-langfuseorgid)
- [ClickHouse Support Services Policy](https://clickhouse.com/legal/support-services-policy)
- [General Terms and Conditions](https://clickhouse.com/legal/clickhouse-general-terms-and-conditions)
- [Product Addenda](https://clickhouse.com/legal/product-addenda)
- [ClickHouse Customer Data Processing Addendum](https://clickhouse.com/legal/agreements/data-processing-addendum)
- [Langfuse Cloud Addendum](https://clickhouse.com/legal/langfuse-cloud-addendum)

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