# ClickHouse

> ClickHouse is a fast open-source column-oriented OLAP database for real-time analytics, capable of processing billions of rows with millisecond query performance at petabyte scale.

ClickHouse is the leading open-source column-oriented database management system designed for real-time analytical processing (OLAP). It delivers millisecond query performance on billions of rows, making it ideal for real-time analytics, observability, data warehousing, and machine learning workloads. Available as a fully managed cloud service (ClickHouse Cloud) on AWS, GCP, and Azure, or as a self-hosted open-source deployment, ClickHouse offers unmatched flexibility and performance. Its columnar storage architecture, vectorized query execution, and best-in-class compression ratios make it significantly faster and more cost-effective than traditional data warehouses.

- **Column-oriented storage** — *Data is stored by column rather than row, enabling at least 100x faster analytical queries compared to row-oriented databases.*
- **Real-time analytics** — *Analyze billions of rows in real time with millisecond results, powering instant dashboards and mission-critical applications.*
- **ClickHouse Cloud** — *Get started with a fully managed service on AWS, GCP, or Azure; sign up for a 30-day free trial and scale compute and storage independently.*
- **Open-source distribution** — *Download and self-host ClickHouse on macOS, Linux, FreeBSD, Windows, or Docker for free with no licensing costs.*
- **ClickStack observability** — *Store and query logs, metrics, and traces at scale using the open-source observability stack powered by ClickHouse.*
- **100+ integrations** — *Connect to popular BI tools, data pipelines, language clients (Python, Java, Go, Node.js), and databases like Postgres, MySQL, Snowflake, and S3.*
- **Agentic Data Stack** — *Build AI-powered applications with blazing-fast vector search, instant aggregations, and scalable training pipelines.*
- **ClickPipes** — *Ingest data from external sources directly into ClickHouse Cloud with a managed data pipeline service.*
- **chDB** — *Run ClickHouse as an in-process SQL engine with a Pandas-compatible API, ideal for local analytics without a server.*
- **Bring Your Own Cloud (BYOC)** — *Deploy a fully managed ClickHouse service within your own AWS, GCP, or Azure VPC for strict data residency requirements.*

## Features
- Column-oriented OLAP database
- Real-time analytics with millisecond queries
- Petabyte-scale data processing
- Vectorized query execution
- Best-in-class data compression
- Fully managed cloud service (ClickHouse Cloud)
- Self-hosted open-source deployment
- ClickStack observability (logs, metrics, traces)
- Vector search for ML and GenAI
- ClickPipes managed data ingestion
- chDB in-process SQL engine
- Bring Your Own Cloud (BYOC)
- 100+ integrations
- Automatic vertical and horizontal scaling
- Multi-cloud support (AWS, GCP, Azure)
- SQL interface
- HIPAA and PCI compliance (Enterprise)
- SAML SSO (Enterprise)
- Transparent data encryption / CMEK (Enterprise)
- Compute-compute separation (Scale+)

## Integrations
AWS, Google Cloud Platform, Microsoft Azure, Snowflake, BigQuery, Amazon Redshift, PostgreSQL, MySQL, Amazon S3, Python, Java, Go, Node.js, Kafka, Spark, dbt, Grafana, Superset, Tableau, Metabase, LangChain, Langfuse

## Platforms
WEB, API, CLI, LINUX, MACOS, WINDOWS

## Pricing
Freemium — Free tier available with paid upgrades

## Links
- Website: https://clickhouse.com
- Documentation: https://clickhouse.com/docs
- Repository: https://github.com/ClickHouse/ClickHouse
- EveryDev.ai: https://www.everydev.ai/tools/clickhouse