ClickHouse

Health v2 · maintenance only

Adoption not part of the score

50464 stars · 9122 forks observed · 2026-10-18

What it is AI-extracted, prompt v1, taxonomy v1, 2026-09-21, confidence 0.97

ClickHouse is an open-source column‑oriented OLAP database management system designed for real‑time analytics on massive datasets. It provides fast inserts and millisecond query responses at petabyte scale.

Use cases

• run real‑time dashboards over billions of rows
• store and query logs, metrics, and traces for observability
• perform fast data warehousing and ad‑hoc analytics
• enable vector search for machine‑learning and GenAI workloads
• process streaming data pipelines with low latency

When to choose

• you need sub‑second query latency on large analytical workloads
• your data is column‑oriented and you require high‑throughput inserts
• you want an open‑source alternative to commercial OLAP databases
• you plan to run on Linux/macOS/Windows or containerized environments

When to avoid

• you require strong transactional (OLTP) guarantees or row‑level locking
• your workload is primarily key‑value lookups with low latency requirements
• you need built‑in support for complex joins across many small tables

Facets

application · maturity active

database vector-database search-engine databases big-data analytics web-development windows cloud column-oriented olap mpp real-time-analytics sql high-performance linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="ClickHouse/ClickHouse")