compare
ClickHouse vs DuckDB
The same facts for both, read from GitHub every night, and the relation a person reviewed.
| Fact | ClickHouse | DuckDB |
|---|---|---|
| Language | C++ | C++ |
| Licence | Apache-2.0 | MIT |
| Stars | 50k | 42k |
| Latest | v26.8.19.9-lts | v1.5.6 |
| Last push | 2026-10-06 | 2026-10-06 |
| Release cadence | about 1 day between releases | about 31 days between releases |
| Active contributors | 52+ commit authors on the default branch in the last 90 days | 46+ commit authors on the default branch in the last 90 days |
| Flags | none | none |
How they relate
Both replace BigQuery. Alternatives to BigQuery →
Full replacementClickHouseColumnar SQL analytics at scale.
PartialDuckDBAnalytical SQL on one machine.
Both replace Snowflake. Alternatives to Snowflake →
Full replacementClickHouseColumnar SQL analytics on your own servers or object storage.
PartialDuckDBIn-process analytical SQL over local files, Parquet and object storage, on one machine.
ClickHouse
- v26.8.19.9-lts2026-10-06Release v26.8.19.9-lts
- v26.7.23.7-stable2026-10-06Release v26.7.23.7-stable
- v26.3.43.4-lts2026-10-06Release v26.3.43.4-lts
- v26.9.11.2-stable2026-10-05Release v26.9.11.2-stable
- v26.8.18.2-lts2026-10-05Release v26.8.18.2-lts
ClickHouse
unsigned The latest release, v26.8.19.9-lts, carries no signature GitHub could verify.
Loading the security report
DuckDB
✓ signed The latest release, v1.5.6, carries a signature GitHub verified.
Loading the security report