ClickHouse

Health v2 · maintenance only

Adoption not part of the score

49470 stars · 8860 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

ClickHouse is an open-source, column-oriented database management system designed for real-time analytical queries over large datasets. It is written in C++ and supports distributed, self-hosted, and cloud deployments with SQL access and official client drivers for multiple languages.

Use cases

• run fast analytical SQL queries over billions of rows
• build real-time dashboards and reporting on event data
• store and query application logs and metrics at scale
• power user-facing analytics with sub-second query latency
• analyze clickstream and time-series data
• self-host a columnar OLAP data warehouse

When to choose

• you need high-performance OLAP analytics on large volumes of data
• you want real-time reporting and dashboards over streaming events
• you need a self-hosted or cloud-native columnar database with SQL support
• your workload is read-heavy, append-mostly analytical queries

When to avoid

• you need frequent row-level updates or deletes on transactional data
• you need a general-purpose OLTP database for transactional workloads
• your dataset is small and a traditional relational database suffices
• you require strict multi-row ACID transactions

Facets

application · maturity stable

database search-engine analytics databases big-data analytics windows cross-platform self-hosted cloud olap column-oriented dbms mpp distributed real-time-analytics sql-database lakehouse sql data-engineering real-time linux macos docker kubernetes

Member repositories

For agents

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