ClickHouse

ClickHouse is an open-source, column-oriented database management system (DBMS) purpose-built for online analytical processing (OLAP) — enabling organizations to run SQL queries across billions of rows in milliseconds. Originally developed inside Yandex in 2009 to power Yandex.Metrica, one of the world's largest web analytics platforms, it entered production in 2012, was open-sourced in 2016, and spun off as an independent company, ClickHouse, Inc., in September 2021.

The Problem It Solves

Traditional row-oriented databases like PostgreSQL or MySQL optimize for transactional workloads: reading and writing individual records quickly. They struggle with analytical queries that must scan millions or billions of records across a handful of columns. ClickHouse solves this by physically storing data column-by-column rather than row-by-row. When a query touches five columns out of a two-hundred-column table, the database reads only those five columns off disk — skipping the rest entirely. This single architectural decision drives ClickHouse's core performance claim: roughly 100x faster analytical query execution versus row-based systems on the same hardware.

How It Works

Columnar storage: Data is organized by column, enabling both high compression ratios and minimal I/O during queries. Typical analytical workloads exceed one billion rows processed per second on standard server hardware.

Vectorized query execution: The query engine processes data in large blocks rather than row-by-row, exploiting CPU SIMD instructions and cache locality for maximum throughput. A benchmark query scanning 100 million rows completed in 92 milliseconds in official testing.

Asynchronous multi-master replication: Data replicates across nodes asynchronously, providing high availability and automatic fault recovery without write bottlenecks at scale.

SQL compatibility: ClickHouse supports ANSI SQL — GROUP BY, JOINs, window functions, subqueries — so existing data teams need no proprietary query language.

Adaptive optimization: The engine automatically selects join strategies (hash vs. merge) at runtime based on data size and cardinality, requiring minimal manual tuning.

Key Features

• Sub-second queries on tables with hundreds of billions of rows; typical aggregations complete under 100 milliseconds
• Advanced compression codecs that materially reduce storage footprints versus row-based alternatives
• Flexible deployment: self-hosted open source under Apache 2.0, fully managed via ClickHouse Cloud on AWS, GCP, and Azure, or embedded via the chDB library
• Over 100 native integrations with visualization tools (Grafana, Tableau, Apache Superset), streaming platforms (Kafka, Amazon Kinesis), and ETL pipelines
• SQL-standard role-based access control (RBAC) for enterprise security requirements

ClickHouse Cloud and Business Trajectory

ClickHouse, Inc. commercializes the open-source project through ClickHouse Cloud, a fully managed service that handles provisioning, scaling, replication, backups, and upgrades. The service has grown to over 3,000 customers, including Meta, Microsoft, Spotify, Lyft, Tesla, Sony, Cursor, Anthropic, Capital One, and Polymarket. ARR grew more than 250% year-over-year into 2026, with Sacra estimating the company reached $250 million in annualized revenue by May 2026.

The company has expanded its scope through a series of acquisitions: Arctype (SQL client), chDB (embedded OLAP engine), PeerDB (Postgres change data capture), HyperDX (observability platform), LibreChat (open-source AI interface), and Langfuse (LLM observability with 20,000+ GitHub stars and 26 million monthly SDK installs). In January 2026, ClickHouse also announced a native Postgres service developed with Ubicloud, enabling users to sync transactional data directly into ClickHouse analytics without managing separate systems.

Funding history: ClickHouse, Inc. raised $50 million in Series A (2021, Index Ventures and Benchmark Capital), $250 million in Series B (October 2021, $2 billion valuation, led by Coatue Management and Altimeter Capital), $350 million in Series C (May 2025, approximately $6.35 billion valuation, led by Khosla Ventures), and $400 million in Series D (January 2026, approximately $15 billion valuation, led by Dragoneer Investment Group with participation from Bessemer Venture Partners, GIC, Index Ventures, Lightspeed Venture Partners, T. Rowe Price, and WCM Investment Management). Total funding exceeds $1 billion.

No Native Token

ClickHouse has no cryptocurrency token, staking mechanism, or on-chain governance. The open-source project is licensed under Apache 2.0. ClickHouse Cloud is a subscription-based commercial service billed on usage.

Solana Ecosystem Fit

ClickHouse has direct relevance to the Solana ecosystem through CryptoHouse — a free blockchain analytics platform built in partnership with Goldsky, a Solana-native data infrastructure provider. Launched in August 2024 and presented at Breakpoint 2024, Solana's flagship developer conference, CryptoHouse allows anyone to query real Solana on-chain data using standard SQL at no cost.

Available at crypto.clickhouse.com, CryptoHouse exposes the following Solana datasets, updated continuously in real time via Goldsky's streaming infrastructure:

• blocks — complete block-level metadata
• transactions — full transaction history
• token_transfers — SPL token movement records
• block_rewards — validator and staking reward data
• accounts — account state snapshots
• tokens — SPL token metadata

As of late 2024, the platform hosted over 400 TiB of Solana data and nearly 600 billion rows of instructions. Ethereum and Base are also supported, with additional chains planned.

The free SQL access model addresses a real cost barrier: querying Solana's full transaction history on services like BigQuery can cost tens of thousands of dollars monthly, given the chain's peak throughput. CryptoHouse eliminates that cost for developers building analytics tools, dashboards, and research on Solana data.

Beyond CryptoHouse, ClickHouse is embedded across the Solana builder stack. Projects building block explorers, DeFi analytics platforms, staking dashboards, and data indexing APIs routinely use ClickHouse to store and serve indexed on-chain data at the throughput Solana demands. Helius, one of Solana's leading RPC and data providers, used ClickHouse as its archival storage layer before later migrating to RocksDB for specific workloads — illustrating both the database's relevance to and the evolving tradeoffs within Solana infrastructure.

Team and Origins

ClickHouse's technical lineage runs through Yandex, where Alexey Milovidov led the original development beginning in 2009. Milovidov continues as CTO of ClickHouse, Inc. The company was incorporated in San Francisco and initially backed by Index Ventures, Benchmark Capital, and Yandex N.V. The open-source repository is hosted on GitHub under the ClickHouse organization and remains actively developed with a broad contributor community.