LibreAI / Self-Hosted / ClickHouse
// selfhosted · ClickHouse/ClickHouse

ClickHouse

ClickHouse is an open-source self-hosted project by ClickHouse (ClickHouse/ClickHouse on GitHub). It has 50,222 GitHub stars and 9,052 forks, is released under the Apache-2.0 license, and was last updated on GitHub on 3 October 2026.

ClickHouse® is a real-time analytics database management system

★ 50.2k stars⑂ 9.1k forksApache-2.0updated 2026-10
▦ visual — this project's README ships no embeddable screenshot,
so here's a placeholder. The guide below is complete regardless.
// project facts

Project facts

GitHub stars
50,222
Forks
9,052
License
Apache-2.0
Last updated on GitHub
3 October 2026
Category
Self-Hosted
Listing
Full install guide
Official site
Official site
// how it works

How it works

  1. Pick a service to reclaim

    Files, mail, passwords, media — start with one.

  2. Deploy it

    Docker Compose one-liners are the standard install.

  3. Point a domain at it

    Reverse proxy + free TLS certificates take minutes.

  4. Back it up

    Automated backups to a second disk or offsite.

// features

Why people love it

One-time cost

A mini-PC beats endless subscriptions.

Own your data

No scanning, no ads, no training on your files.

Family friendly

Share with the household, not the cloud.

Backups built in

Snapshots and export keep you safe.

Community hardened

Years of production use by thousands of homelabs.

Offline resilient

Works on your LAN even when the internet dies.

Advertisement
// run it

Run it yourself

  1. Step 1 — Clone the repo

    Download the source and move into the project folder.

    git clone https://github.com/ClickHouse/ClickHouse.git
    cd ClickHouse
  2. Step 2 — Check the README

    Every project documents its own setup; start with install requirements.

    cat README.md | head -60
  3. Step 3 — Run it

    Follow the project's launch command — Docker, pip, npm, or a binary release.

    # see README for the exact launch command
// use cases

What you can build

  • Replace Google Drive with private file sync.
  • Self-host passwords for the family.
  • Run your own media and photo cloud.
  • Host mail, calendars, and kanban.
Advertisement
// faq

Questions, answered

Who maintains ClickHouse?

It is an open-source project at ClickHouse/ClickHouse with 9,052 forks. Check the repo's contributors and recent commits to see how active maintenance is.

Is ClickHouse free for commercial use?

Apache 2.0 licensed — commercial use allowed with attribution.

Can non-technical family use it?

Yes — the apps look and feel like the SaaS versions.

What about backups?

Non-negotiable: automate offsite backups from day one.

Is it secure?

Keep it updated, use strong passwords, and expose only what you need.

// keep exploring

Similar tools

Self-Hosted

langfuse

🪢 Open source agent evals & observability: Trace, evaluate, and improve LLM applications with one open platform.

★ 35.3k starsUnknown
View guide →
Self-Hosted

streama

Self hosted streaming media server. https://docs.streama-project.com/

★ 9.8k starsMIT
View guide →
Self-Hosted

lesspass

:key: stateless open source password manager

★ 6.1k starsGPL-3.0
View guide →
Self-Hosted

Paperless-ngx

Paperless-ngx — the community document management system: scan, index and archive every paper document, GPL-3.0

★ 47.1k starsGPL-3.0
View guide →
Self-Hosted

financial-management

Self-hosted family asset tracking with real returns and AI checkups.

★ 358 starsApache-2.0
View guide →
Self-Hosted

marketingdashboard

A one-screen real-time market research cockpit for stocks and more.

★ 341 starsMIT
View guide →
// alternatives

Alternatives in Self-Hosted

The most-starred other Self-Hosted projects in the LibreAI catalogue — the realistic shortlist if ClickHouse is not the right fit.

  • awesome-selfhosted★ 323.7k

    A list of Free Software network services and web applications which can be hosted on your own servers

  • Uptime Kuma★ 92.6k

    Uptime Kuma — a fancy self-hosted monitoring tool: uptime checks for sites and services every 20 seconds, with a beautiful status page and 90+ alert channels

  • Home Assistant★ 91.6k

    Home Assistant — open-source home automation that puts local control and privacy first: thousands of integrations, automations and dashboards on your own hardware

  • Vaultwarden★ 69.2k

    Vaultwarden — an unofficial Bitwarden-compatible server in Rust: the full password-manager experience, including premium features, on a tiny self-hosted footprint

  • Pi-hole★ 61.3k

    Pi-hole — a black hole for internet advertisements: network-wide ad and tracker blocking at the DNS level, for every device in the house, from one small box

// more in selfhosted

More in Self-Hosted

Nearby Self-Hosted projects in the catalogue, closest in stars to ClickHouse — keep exploring the shelf either side of it.

  • appwrite★ 57.6k

    Appwrite® - complete cloud infrastructure for your web, mobile and AI apps. Including Auth, Databases, Storage, Functions, Messaging, Hosting, Realtime and more

  • Paperless-ngx★ 47.1k

    Paperless-ngx — the community document management system: scan, index and archive every paper document, GPL-3.0

  • Jellyfin★ 58.2k

    Jellyfin — the free software media system: stream your own movies, shows, music and books to any screen, with no accounts, no tracking and no premium tier

  • puter★ 43.6k

    🌐 The Internet Computer! Free, Open-Source, and Self-Hostable.

  • Gitea★ 58.5k

    Gitea — Git with a cup of tea: a painless, all-in-one self-hosted Git service with code review, package registry and CI/CD, in a single lightweight Go binary

  • umami★ 39.1k

    Umami is a privacy-first analytics platform. Traffic, campaigns, behavior, conversions, and revenue in one place — no cookies, no surveillance, self-hosted o…

Get ClickHouse

Free and open — grab the source, star the repo, and start creating.