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

ClickHouse

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

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.

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

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

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 →
Self-Hosted

vanblog

A self-hosted blogging system with Markdown editing, a full admin dashboard, analytics, image hosting, comments, and automatic HTTPS.

★ 3.6k starsGPL-3.0
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.

Get ClickHouse

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