Fast Open-Source OLAP DBMS - ClickHouse

The real-time
data warehouse for
analytics
observability
ML & GenAI
business intelligence
financial services
fraud & cybersecurity
gaming
analytics
observability
ML & GenAI
business intelligence
financial services
fraud & cybersecurity
gaming

ClickHouse is Trusted by

Build real-time data products that scale

Sony, Lyft, Cisco, GitLab, Twilio and many more choose ClickHouse Cloud for its scale, efficiency, and ease of use.
Filter by

“ClickHouse helps us efficiently and reliably analyze logs across trillions of Internet requests to identify malicious traffic and provide customers with rich analytics.” Read blog

1.5T
Page views analyzed / mo
2.5B
Visitors analyzed / mo
11M
Rows ingested / sec

“We needed something to slice and dice real-time data, like rides and driver hours across cities and regions where Lyft runs. Using ClickHouse resulted into a lot of performance benefits for us with huge cost savings for the org.” Read blog

10M+
Rows ingested daily
20TB
Data read daily
Huge
Cost savings

“In the post-evaluation of each database against our criteria (with metrics ranging from query performance to cost), ClickHouse emerged as the unrivalled frontrunner. It excelled across the board, even astonishingly so in certain domains, and proved more cost-efficient.” Read blog

100B+
Sessions analyzed / year
10x
Improved query speed
2-3x
Better storage efficiency

Why ClickHouse?

ClickHouse is the fastest and most resource efficient real-time data warehouse and open-source database.

Blazing fast

Ultimate query performance that your mission-critical and time-sensitive applications can depend on.

Developer friendly

Built to ensure that even the most sophisticated data analysis can be done intuitively, using simple SQL.

Cost effective

Best-in-class compression ratios that reduce storage and accelerate performance.
Get started in a few minutes with a free cloud trial ->

Seamlessly integrate with your stack

Choose from our growing ecosystem of integrations for data ingestion, visualization, language clients, and more.
Stack integration graph
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.

Join the 100k+ developers using ClickHouse today

Twitter imageSlack image
Telegram imageMeetup image
1.3k+Contributors
36k+PRs
37.8k+Stars
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.