# ClickHouse (/docs/proai/components/clickhouse)



Component Category [#component-category]

OLAP

Component Description [#component-description]

ClickHouse is the analytical database used in ProAI for high-performance querying and OLAP-style workloads. It is a column-oriented engine designed for fast aggregation, low-latency analytics, and large-scale dataset exploration.

Why It Is Used [#why-it-is-used]

It provides the analytical storage layer for querying large datasets efficiently and supports reporting and BI workloads that sit beyond the CoreAI application layer. Its design is well suited for real-time analytics, dashboarding, and large-volume query patterns where traditional transactional databases are not the right fit.

Learn More [#learn-more]

* [ClickHouse Documentation](https://clickhouse.com/docs/en)
* [ClickHouse on GitHub](https://github.com/ClickHouse/ClickHouse)

Interacts With [#interacts-with]

* `Superset` as the main BI consumer in the current ProAI architecture
* `Airbyte` as an ingestion path into analytical datasets
* Selected wider platform services that also use ClickHouse-backed analytical storage
* Runtime storage, delivery, and operational services that support the cluster deployment