Query billions of rows in milliseconds

ClickHouse is the fastest and most resource efficient open-source database for real-time apps and analytics.

SELECT toStartOfMonth(upload_date) AS month, sum(view_count) AS `Youtube Views`, bar(sum(has_subtitles) / count(), 0.55, 0.7, 100) AS `% Subtitles` FROM youtube WHERE (month >= '2020-08-01') AND (month <= '2021-08-01') GROUP BY month ORDER BY month ASC


13 rows in set. Elapsed: 0.823 sec Processed 1.07 billion rows, 11.75 GB (1.30 billion rows/s., 14.27 GB/s.)

Trusted by developers that work with data at scale
Don't take our word for it. Read our user stories
Moving over to ClickHouse we were basically able to cut that (Redshift) bill in half.

"Moving over to ClickHouse we were basically able to cut that (Redshift) bill in half."

Brooke McKim
Co-founder and CTO, Vantage

There is that feeling of new tech where everything just feels like it's going right.

"There is that feeling of new tech where everything just feels like it's going right."

Harlow Ward
Co-founder and CTO, Clearbit

We wanted something not only just simple to use, but also simple to manage.

"We wanted something not only just simple to use, but also simple to manage."

Jason Wang
Software Engineer, Statsig

ClickHouse has been great for us. It has solved all the use cases we have thrown at it

"ClickHouse has been great for us. It has solved all the use cases we have thrown at it"

Ritesh Varyani
Senior Software Engineer, Lyft

Speed Icon

Speed up queries from any data source

ClickHouse supports all the data sources you need to power your apps and use cases that require exceptional performance.
Fast Icon

Why is ClickHouse so fast?

Column-oriented databases are better suited to OLAP scenarios. They are at least 100x faster in processing most queries. ClickHouse uses all available system resources to their full potential to process each analytical query as fast as possible.
Row-oriented databases
In row-oriented databases, data is stored in rows, with all the values related to a row physically stored next to each other.
Column-oriented databases
In column-oriented databases, like ClickHouse, data is stored in columns, with values from the same columns stored together.
Deploy Icon

Deploy your way

Unlike traditional closed-source OLAP databases, ClickHouse runs on every environment, whether it’s on your machine or in the cloud.
ClickHouse Local
ClickHouse Local
Run fast queries on local files (CSV, TSV, Parquet, and more) without a server.
Open-source ClickHouse
Open-source ClickHouse
Spin up a database server with open-source ClickHouse. Always Free.
ClickHouse Cloud
ClickHouse Cloud
Available on AWS, GCP, and through their respective Marketplaces. Azure coming soon.

Join the 100k+ developers using ClickHouse today

Twitter imageSlack image
Telegram imageMeetup image
1.3k+Contributors
36k+PRs
33.5k+Stars

What do developers say?

Image for Cloudflare’s HTTP analytics infrastructure
Cloudflare’s HTTP analytics infrastructure
Read about how Cloudflare uses ClickHouse to support 6M requests per second.
Image for GitLab’s APM datastore
GitLab’s APM datastore
Watch this YouTube video showing why GitLab chose ClickHouse over Timescale to power their APM infrastructure.
Image for Lyft's Real-time Analytics
Lyft's Real-time Analytics
Read about how ClickHouse has been great for Lyft. It has solved all the use cases that they have thrown at it.
FAQ Icon

FAQs

Wherever you need us, we’re there. We love to engage in thoughtful conversation with the ClickHouse community and are always on-hand to answer your questions.
Ask us anything

Start using ClickHouse in minutes

Install ClickHouse for MacOS, Linux, and FreeBSD.

curl https://clickhouse.com/ | sh

Or install for Windows, Docker or see other install options.

Watch this getting started video to learn more about ClickHouse.

© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.