ClickHouse

ClickHouse: Real-Time Column-Oriented Analytics Database

ClickHouse is an open-source, column-oriented database management system for generating analytical reports in real time. It is suited to analytics workloads, from local evaluation to querying a small cluster.

Stars
50.7k
Forks
9.2k
Stars, last 30 days
+502
Last commit
today
Contributors
100+

Our take

Activeregular commits and releases

Health score

76/100

How it is scored
Activity
90
Community
89
Issues
71
Pull requests
54

+502 stars in the last 30 days

  • Releases more often than 93% of the projects we track
  • Merges more pull requests than 87% of the projects we track
  • More contributors than 78% of the projects we track

ClickHouse is an actively maintained analytics database with frequent releases and contributions, making it a credible choice for teams whose needs match its real-time, column-oriented focus.

Good fit if

  • Your primary need is analytical reporting with real-time queries.
  • You want to evaluate the database locally or follow the documented small-cluster tutorial.
  • You prefer a hosted option from the project’s maintainers, or are prepared to operate the database yourself.

Look elsewhere if

  • Your workload is not primarily analytical and does not benefit from a column-oriented database.
  • You need a database setup that avoids the operational work of running a cluster and do not want to use ClickHouse Cloud.
All health signals
Last commit2026-10-30 (today)
Commits, last 90 days100+
Releases, last 12 months100+ (latest v26.10.2.103-stable, 2026-10-24)
Contributors100+ (top contributor: 28% of commits)
Issues closed, last 90 days8+ (typically closed in 1 day)
Pull requests merged, last 90 days81 (typically merged in 2 days)
Project age10 years

Checked on 2026-10-31 with the GitHub API.

Project history

Daily GitHub snapshots since Oct 7, 2026. History covers stars and forks; health signals are not tracked historically.

Selected snapshot

Stars

50,980

Forks

9,279

Change since Nov 17, 2026: +14 stars·+7 forks

Overview

ClickHouse is an open-source, column-oriented database management system for generating analytical reports in real time. It targets teams that need to query data for analytics rather than use a general-purpose database as their only store. The project supports Linux, macOS, and FreeBSD.

You can install it directly or use ClickHouse Cloud, the hosted service built by the project’s maintainers. The documentation includes a tutorial for setting up and querying a small cluster.

Key Features

  • Column-oriented database management system focused on analytical reporting.
  • Designed to generate reports in real time.
  • Can be installed on Linux, macOS, and FreeBSD.
  • Offers ClickHouse Cloud as a hosted option.
  • Documentation tutorial walks through setting up and querying a small cluster.
  • Provides documentation, a user community on Slack and Telegram, and release presentations.

Use Cases

  • Data teams generating analytical reports from data that needs to be queried in real time.
  • Engineers evaluating an analytics database locally before deciding whether to deploy a cluster.
  • Teams that want a managed analytics database and prefer ClickHouse Cloud over operating it themselves.
  • Developers learning how to set up and query a small database cluster using the project’s tutorial.

What you need

Detected in the repository

  • Python (from pyproject.toml)
  • A test suite and automated checks on GitHub Actions

License in plain words

Apache-2.0permissive

  • Commercial use: yes
  • Modify and redistribute: yes
  • You must keep: the license, the NOTICE file and a note of your changes
  • Share your changes: no
  • Includes an explicit patent grant from the contributors:

A summary, not legal advice: the LICENSE file is what applies.

Getting Started

On Linux, macOS, or FreeBSD, run:

curl https://clickhouse.com/ | sh

See the README and documentation for setup and usage details.

Alternatives

  • starrocks: StarRocks is a SQL query engine for warehouses and data lakes, while ClickHouse is a column-oriented database for real-time analytics.
ProjectLanguageLicenseStarsStatus
ClickHouseC++Apache-2.050.7kActive
starrocksJavaApache-2.012.3kActive

Considerations

The repository is active, with regular commits and releases, and contributions are not concentrated in a single contributor. Its large ongoing development surface means teams should assess changes and compatibility against their own deployment needs. The README points to ClickHouse Cloud as an alternative to operating the database, but self-hosted use requires teams to handle their own deployment and cluster setup.

Found this useful?

Share it with someone who would like ClickHouse.

Comparisons