There are 2 open-source alternatives to ClickHouse in this directory. The most popular is Duckdb with 37.4k GitHub stars, followed by StarRocks(11.1k stars). All are open source, free to use, and many can be self-hosted.
| # | Tool | Stars | Language | License |
|---|---|---|---|---|
| 1 | Duckdb DuckDB is an analytical in-process SQL database management system that offers fast and efficient query processing for analytical workloads. | 37.4k | C++ | MIT License |
| 2 | StarRocks StarRocks is an open source, high-performance analytical database and query engine designed for sub-second analytics both on and off the data lakehouse. It excels in multi-dimensional analytics, real-time analytics, and complex ad-hoc queries, offering flexibility for a wide range of analytical scenarios as a Linux Foundation project. | 11.1k | Java | Apache License 2.0 |
DuckDB is an analytical in-process SQL database management system that offers fast and efficient query processing for analytical workloads.
StarRocks is an open source, high-performance analytical database and query engine designed for sub-second analytics both on and off the data lakehouse. It excels in multi-dimensional analytics, real-time analytics, and complex ad-hoc queries, offering flexibility for a wide range of analytical scenarios as a Linux Foundation project.
The top three are Duckdb(37.4k stars), StarRocks(11.1k stars). All are open source and free to use.
Yes. Every tool listed here is open source and free to use in your own projects. Many can be self-hosted on your own infrastructure, which means no subscription fees and full control over your data.
Many of the alternatives listed are self-hostable. Each tool's page lists hosting details, system requirements, and licensing terms.
Get notified about new tools and updates to existing ones.