Softwr
ClickHouse logo

ClickHouse

Fast open-source column-oriented database for real-time analytics

As of 17 November 2026, ClickHouse is free to use. ClickHouse is a column-oriented database management system for online analytical processing (OLAP). Softwr lists it under Databases. ClickHouse is made by ClickHouse Inc., launched in 2021, available on Linux, macOS, Windows.

Overview

What is ClickHouse?

ClickHouse is an open-source, column-oriented database for online analytical processing, where users run SQL queries to build analytical reports in near real time on non-aggregated data. Yandex first developed it, a team began testing in 2009 whether reports could be generated in real time from raw data that keeps arriving, and it went into production in 2012 to power Yandex.Metrica. It became open source in 2016 under the Apache License 2.0, and ClickHouse, Inc. was incorporated in San Francisco in September 2021 to commercialise it, with the hosted ClickHouse Cloud as its main product. Wikipedia names Uber, Comcast, eBay and Cisco as adopters and CERN's LHCb experiment as a user. ClickHouse Cloud has three plans. Basic is for testing and starter projects, with up to 1 TB of storage, 8 to 12 GiB of memory, a single availability zone and one day of backups. Scale adds unlimited storage, configurable memory, two or more availability zones, private networking and compute-compute separation, and Enterprise adds SAML SSO, private regions, CMEK, scheduled upgrades, a named support engineer and HIPAA and PCI compliance. Billing is usage based with compute, storage, backups and data transfer metered separately, and there is no monthly minimum. A trial gives $300 in credits over 30 days with no card. It is built for analytics, so it is not designed as a transactional database for frequent row updates.

What people use it for

  • Business intelligence
  • Data warehousing
  • Real-time analytics
  • Reporting
  • Machine learning

The honest half

Where does ClickHouse fall short?

The limits buyers hit most with ClickHouse: limited multi-row atomic transactions and expensive UPDATE/DELETE operations unsuitable for transactional systems; and requires upfront schema design discipline with MergeTree engine choices and sort/partition keys. Each is concrete and checkable: the half of a review a vendor will not write.

  • Limited multi-row atomic transactions and expensive UPDATE/DELETE operations unsuitable for transactional systems
  • Requires upfront schema design discipline with MergeTree engine choices and sort/partition keys
  • Experimental vector search support, not production-ready for vector operations
  • Different query syntax from standard SQL requiring migration planning
  • Limited JOIN capabilities compared to traditional relational databases
  • Migration complexity with 2-4 weeks estimated for data type mapping and query translation

Cross-shopped

What are the alternatives to ClickHouse?

The closest alternatives to ClickHouse are Apache Druid, Apache Pinot and Amazon Redshift. Each is a tool buyers genuinely weigh against it, with the reason why.

  • ClickHouse vs Apache Druid

    Apache Druid: OLAP data warehouse optimized for fast aggregations on large datasets, with similar columnar architecture.

  • ClickHouse vs Amazon Redshift

    Amazon Redshift: Cloud data warehouse service with strong analytics capabilities and integration with AWS ecosystem.

  • ClickHouse vs StarRocks

    StarRocks: Open-source analytical database with fast joins and real-time ingestion, for teams weighing another OLAP engine

  • ClickHouse vs Apache Doris

    Apache Doris: Open-source MPP analytics database with a MySQL-compatible interface, for real-time reporting workloads

  • ClickHouse vs BigQuery

    BigQuery: Serverless data warehouse billed on usage, for teams already on Google Cloud who want no cluster management

Pricing

How much does ClickHouse cost?

ClickHouse is free to use, with 3 plans on record. Taken from the vendor's own pricing page; prices move, so check before you buy.

Basic

On request

Scale

On request

Enterprise

On request

Capabilities

What can ClickHouse do?

ClickHouse lists 17 features, including column-oriented Storage, real-time Analytics and SQL Support.

  • Column-oriented Storage

  • Real-time Analytics

  • SQL Support

  • Linear Scalability

  • Data Compression

  • Vectorized Query Execution

  • Approximate Calculations

  • Kafka

    Integration with Kafka

  • S3

    Integration with S3

  • MySQL

    Integration with MySQL

  • PostgreSQL

    Integration with PostgreSQL

  • Grafana

    Integration with Grafana

Answered, with sources

Questions people ask

Each answer names the page it came from, so you can check it rather than take our word for it.

What is ClickHouse best used for?

ClickHouse is optimized for analytical workloads on large datasets. It excels at fast aggregations and queries, being 10-100x faster than PostgreSQL on large aggregations.

Source
Does ClickHouse support transactions?

ClickHouse has limited transaction support and expensive UPDATE/DELETE operations. It is not suitable for transactional workloads requiring strict ACID guarantees.

Source
How does ClickHouse compare to PostgreSQL?

ClickHouse is 10-100x faster for analytics but PostgreSQL is better for transactional workloads. Many teams use both: PostgreSQL for writes via MaterializedPostgreSQL replication to ClickHouse for analytics.

Source

Behind it

Who makes ClickHouse?

ClickHouse is made by ClickHouse Inc., founded in 2021 and based in San Francisco, California.

Company
ClickHouse Inc.
Based in
San Francisco, California

Timeline

ClickHouse over time

  1. Launch2016-06-15

    ClickHouse open-sourced and released as general-purpose database

    Source
  2. Milestone2009-01-01

    Yandex.Metrica uses specialized OLAP database for web analytics

    Source

Checked against

Sources

The pages the facts above were read from. Prices and limits change, so the vendor's own page is the final word.

Share

Keep looking

Where to go from ClickHouse

Best Databases software for

Compare ClickHouse with

Other Databases software

  • Real-time analytics database for sub-second OLAP queries

    Free plan6 researched notes
  • The real-time distributed SQL database for data-intensive applications

    Free, then $0.99/mo14 researched notes
  • Fast, scalable cloud data warehouse from AWS

    Free plan12 researched notes
  • Time-series database built on PostgreSQL for real-time analytics

    Free plan12 researched notes
  • Managed ClickHouse with a workflow that turns SQL queries into hosted HTTP APIs

    Free, then $25/mo12 researched notes
  • Streaming SQL engine built on ClickHouse internals, shipping as one small binary

    Free, then $199/mo12 researched notes
  • Google Cloud's serverless analytical warehouse, billed either by bytes scanned per query or by reserved compute slots.

    Free plan13 researched notes
  • Apache 2.0 MPP analytical database built for joins on open table formats

    Open source12 researched notes
  • The Meta-lineage distributed SQL query engine, distinct from the Trino fork

    Open source12 researched notes
  • The real-time data company for AI applications

    Free plan6 researched notes
  • SQL transformation framework enabling analytics engineers to version, test and deploy models

    Free plan8 researched notes
  • Erlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node

    Free, then $234/mo12 researched notes
  • Document-relational database whose hosted service closed in 2025 and whose core is now unmaintained Apache 2.0 code.

    Free plan12 researched notes
  • Real-time distributed OLAP datastore for analytics

    Free plan7 researched notes
  • Flexible, scalable NoSQL cloud database from Firebase

    Free plan8 researched notes
  • MPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables

    Open source12 researched notes
  • Manage massive amounts of data with linear scalability

    Free plan15 researched notes

Softwr does not host reviews and shows no star rating for ClickHouse, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.

More on ClickHouse

Best Databases software alternatives

Industrial process historian with published per-tag pricing and no client licence fees

Per tag band per year

NetApp-owned managed service for Cassandra, Kafka, OpenSearch, PostgreSQL and Cadence with a bring-your-own-cloud model

quote

Erlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node

Per month by connection and session volume

Attribute-based access control and masking applied inside Snowflake, Databricks and BigQuery

quote

MPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables

Open source, no licence fee

Streaming database that maintains incremental materialised views in SQL instead of Flink jobs

Per RisingWave Unit hour

Centralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI

quote

The Meta-lineage distributed SQL query engine, distinct from the Trino fork

Open source, no licence fee

Compare ClickHouse with alternatives