The fastest open-source analytical database.

ClickHouse is a column-oriented database that enables its users to generate powerful analytics, using SQL queries, in real-time.
Blazing fast

Blazing fast

Processes analytical queries faster than traditional row and column oriented systems.

Linearly scalable

Linearly scalable

Scales efficiently with hardware resources horizontally and vertically to petabyte scale.

Highly reliable

Highly reliable

Supports asyncronous replication and can be deployed across multiple datacenters.

Flexible architecture

Flexible architecture

Supports shared-nothing clusters as well as separation of storage and compute.

Feature-rich

Feature-rich

The most complete analytical database with support for joins, federated queries, and more.

Easy to use

Easy to use

Simplifies writing queries with a user-friendly SQL dialect, optimized for common analytical use cases.

ClickHouse efficiency

Hardware efficient

ClickHouse processes analytical queries 100-1000x faster than traditional row-oriented systems with the same available I/O throughput and CPU capacity. Columnar storage format allows fitting more hot data in RAM, which leads to shorter response times.

Vectorization

Maximizes CPU efficiency

Vectorized query execution leverages SIMD processor instructions and runtime code generation. Processing data in columns increases CPU cache line hit rate.

Locality

Optimizes disk access

ClickHouse minimizes the number of seeks for range queries to increase efficiency of using disk drives and maintain locality of reference for continually stored data.

Throughput

Minimizes data transfers

ClickHouse enables companies to manage their data and create reports without using specialized networks that are aimed at high-performance computing.

From your laptop to petabyte scale

ClickHouse is linearly scalable
ClickHouse scales well both vertically and horizontally. It is easily adaptable to perform on your laptop, small virtual machine, a single server, or a cluster with hundreds or thousands of nodes.

There are many ClickHouse clusters consisting of multiple hundreds of nodes, while the largest known ClickHouse cluster is well over a thousand nodes. There are installations of ClickHouse with more multiple trillion rows or hundreds of terabytes of data per single node.
ClickHouse at scale

ClickHouse at scale

ClickHouse is used in a variety of industries for a broad set of use cases on top of both customer-facing and internally-facing workloads.
Icon

Web and app analytics

Icon

E-commerce and finance

Icon

Time series

Icon

Advertising networks and RTB

Icon

Information security

Icon

Business intelligence

Icon

Telecommunications

Icon

Monitoring and telemetry

Icon

Online games

Icon

Internet of Things (IoT)

Icon

Observability

Icon

User behavior analytics

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.