selfhost.directory

The index of self-hostable projects — ranked, categorized and served with live updates.
Own your data and stop giving it to big tech.

clickhouse logo

Self-host clickhouse

v26.3.65.10-lts

Column-oriented OLAP database for real-time analytics

ReleaseOpen SourceApache-2.0
Updated1 hour ago
LanguageC++
Setup difficultyAdvanced
Stars
50 959
Ports
8123 (HTTP interface), 9000 (Native TCP client protocol)
Docker
clickhouse/clickhouse-server

What is clickhouse?

ClickHouse is a column-oriented database built for online analytical processing (OLAP). It runs SQL queries over massive datasets and returns results in real time. You can run it yourself via Docker, native Linux packages, or a one-line install script on Linux, macOS, and FreeBSD. The server listens on HTTP port 8123 and a native TCP port 9000. It connects to external systems like Kafka, PostgreSQL, MySQL, MongoDB, BigQuery, and cloud object storage through ClickPipes, and ships official client libraries for JavaScript, Python, Go, Java, C#, Rust, C++, and C.

clickhouse alternatives

Should you self-host clickhouse?

clickhouse scores 87/100 on selfhost.directory (how scoring works) and ranks #2 of 41 in Database Management. It has 50 959 GitHub stars, +579 in the last 30 days.

It shipped 187 stable releases in the past year. The latest, v26.3.65.10-lts, came out on 16 November 2026.

Setup is advanced: plan for several services and some ongoing maintenance. An official Docker image is available. It is Apache-2.0-licensed and written mostly in C++.

Its closest alternative on selfhost.directory is supabase (90/100, 115 031 stars). It scores higher overall, so compare the two before you pick. See clickhouse vs supabase side by side.

clickhouse README

Website Apache 2.0 License

The ClickHouse company logo.
ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real-time.

How To Install (Linux, macOS, FreeBSD)

curl https://clickhouse.com/ | sh

Or skip the install: try ClickHouse Cloud for free and start querying in minutes.

Useful Links

  • Official website has a quick high-level overview of ClickHouse on the main page.
  • ClickHouse Cloud ClickHouse as a service, built by the creators and maintainers.
  • Tutorial shows how to set up and query a small ClickHouse cluster.
  • Documentation provides more in-depth information.
  • YouTube channel has a lot of content about ClickHouse in video format.
  • Slack and Telegram allow chatting with ClickHouse users in real-time.
  • Blog contains various ClickHouse-related articles, as well as announcements and reports about events.
  • X and LinkedIn for short news.
  • Code Browser (github.dev) with syntax highlighting, powered by github.dev.
  • Contact us to discuss your use case with a ClickHouse expert.

clickhouse releases & version history

@ Every self-hosted release, weekly

One Monday email with the week's stable releases across the directory.

More in Database Management

Rate this project

Click to rate — no account needed.

0 comments

Posting as guest
Loading comments…