Self-host clickhouse
v26.3.65.10-ltsColumn-oriented OLAP database for real-time analytics
- Stars
- 50 959
- Ports
- 8123 (HTTP interface), 9000 (Native TCP client protocol)
clickhouse/clickhouse-serverWhat 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
hyperdxSelf-hosted, open-source observability platform unifying logs, metrics, traces and session replays on any ClickHouse cluster, with ingestion through OpenTelemetry.Comparehyperdx with clickhouse
chmonitorchmonitor is a self-hosted, open-source operational advisor for ClickHouse that reads system tables for real-time monitoring and AI-driven schema recommendations.Comparechmonitor with clickhouse
OpenAnalyticsOpen-source, cookieless web analytics with realtime dashboards, funnels and revenue attribution, self-hosted via Docker Compose on Postgres and ClickHouse.CompareOpenAnalytics with clickhouse
databendSelf-hosted, open-source data warehouse in Rust for large-scale analytics plus vector and full-text search, with Python UDF sandboxes and git-like data branching.Comparedatabend with clickhouse
timeplusSelf-hosted, open-source streaming SQL engine for real-time analytics and AI — a lightweight alternative to ksqlDB and Flink powered by ClickHouse.Comparetimeplus with clickhouse
DruidSelf-hosted open-source OLAP database delivering millisecond analytics on high-cardinality event data, with SQL, JDBC, a web console and native Kafka/Kinesis ingestion.CompareDruid with clickhouse
PeerDBSelf-hosted, open-source (AGPL-3.0) ETL tool streaming Postgres to ClickHouse and other warehouses via CDC, with a web UI and a Postgres-compatible SQL interface.ComparePeerDB with clickhouse
Apache DruidApache Druid: a high performance real-time analytics database.CompareApache Druid with clickhouse
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
curl https://clickhouse.com/ | sh
Or skip the install: try ClickHouse Cloud for free and start querying in minutes.
- 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.
More in Database Management
CloudBeaverOpen-source, self-hosted web front end for your databases: SQL and data editors, multi-user administration, LDAP and proxy login, shipped as a Docker image.
cloudberryOne advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database.
cogneeCognee is the open-source AI memory platform for agents. Give your AI agents persistent long-term memory with small models for free
CouchDBSeamless multi-primary syncing database with an intuitive HTTP/JSON API, designed for reliability
d9d9 is a self-hosted, open-source headless CMS forked from Directus 9 with GPLv3 licensing, REST/GraphQL APIs, a no-code Data Studio, and multi-database support.
DatabasusSelf-hosted open-source backup tool for PostgreSQL (also MySQL, MariaDB and MongoDB) with point-in-time recovery, restore verification, encrypted archives and S3 storage.
DBackupSelf-hosted open-source backup for 10 databases and files. Supports S3, Google Drive, SFTP with AES-256-GCM encryption, incremental backups, GFS retention, OIDC SSO, 2FA.
DbGateSelf-hosted, open-source (GPL-3.0) database client for engines like MySQL, Postgres, SQL Server, Mongo and Redis, shipped as desktop apps or a Docker/NPM web UI.
dbhubDBHub is a minimal, token-efficient MCP server connecting AI assistants to PostgreSQL, MySQL, SQL Server, Oracle, MariaDB, and SQLite with built-in guardrails.
docker-borg-mysql-backupSelf-hosted Docker container backing up MySQL/PostgreSQL and files to Borg repos with cron scheduling, encryption, pruning, and error notifications.
DocumentDBSelf-hosted, open-source MongoDB-compatible document database built on PostgreSQL with native BSON, vector search, and SCRAM authentication.
drawdbSelf-hosted, open-source tool for drawing database schemas as ER diagrams; it imports DDL, exports DBML plus SQL in seven dialects, and needs no account.
0 comments