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