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.
At a Glance
About ClickHouse
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.
Community Discussions
Be the first to start a conversation about ClickHouse
Share your experience with ClickHouse, ask questions, or help others learn from your insights.
Pricing
Open Source
Forever-free self-hosted open-source distribution of ClickHouse. Run on your own infrastructure.
- Full ClickHouse OLAP database
- Runs on Linux, macOS, Windows, FreeBSD, Docker
- SQL interface
- 100+ integrations
- Community support
30-Day Free Trial
30-day free trial of ClickHouse Cloud with access to all tiers.
- Access to ClickHouse Cloud
- Available on AWS, GCP, Azure
- No credit card required to start
Basic
Great for testing out new ideas or starter projects. Limited storage and memory.
- Up to 1 TB storage
- 8-12 GiB total memory
- Backups every 24h, retained for 1 day
- 1 availability zone
- Expert support with 1 business day response time
- SSO using Google or Microsoft Social login
- Multi-factor authentication (MFA)
- Storage: $25.30 per 1TB/mo
- Compute: $0.2181 per unit/hr
Scale
For working with production environments, data at scale, or professional use cases.
- Everything in Basic, plus:
- Unlimited storage
- Configurable memory
- Compute-compute separation
- Configurable backups
- 2+ availability zones
- Expert support with 1 hour response time 24x7 for Severity 1 issues
- S3 role-based access
- Private networking
- Automatic vertical scaling
- Manual horizontal scaling
- Storage: $25.30 per 1TB/mo
- Compute: $0.2985 per unit/hr
Enterprise
For production environments, very large data at scale, or enterprise use cases.
- Everything in Scale, plus:
- SAML Single sign-on authentication (SSO)
- Private regions
- Manual vertical scaling for custom profiles
- Export backups to your own cloud account
- Enterprise support with 30 min response time for Severity 1 issues
- Named Lead Support Engineer
- Transparent data encryption / CMEK
- Scheduled upgrades
- Consultative migrations guides
- HIPAA and PCI compliance
- Storage: $25.30 per 1TB/mo
- Compute: $0.3903 per unit/hr
Bring Your Own Cloud (BYOC)
Fully managed ClickHouse service deployed in your own AWS, GCP, or Azure VPC for strict data residency requirements.
- Deployed in your own VPC
- Available on AWS, GCP, Azure
- Strict data residency and compliance
- Fully managed by ClickHouse
Capabilities
Key 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
Demo Video
