# chdb-io/chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

Repository: https://github.com/chdb-io/chdb
Canonical: https://ross.abutalabs.com/products/chdb
Homepage: https://clickhouse.com/chdb
Language: Python
License: Apache-2.0
License Family: permissive
Topics: data-science, database, embedded-database, olap, python, sql, chdb, clickhouse, clickhouse-database, clickhouse-server
Last push: 2026-08-21T06:31:40+00:00

## Health v2 (maintenance only)
Score: 97/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 98, release rhythm 98, longevity 91
- inputs: {"age_days": 1285, "days_push": 12, "days_rel": 16, "gap_med": 12.0, "n_releases_24m": 39}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2879, forks 129 (observed 2026-08-28T04:07:27.537214+00:00)

## What it is
chDB is an in-process SQL OLAP engine powered by ClickHouse, embeddable in Python (plus Go, Rust, Node.js, and Bun bindings) without running a ClickHouse server. It supports 70+ data formats like Parquet, CSV, JSON, and Arrow, and offers a pandas-compatible DataStore API that compiles to optimized ClickHouse SQL.

## Use cases
- run fast OLAP SQL queries on local files without installing a database server
- query parquet and csv files with SQL from python
- speed up pandas groupby and filter pipelines on millions of rows
- embed an analytics database inside an application with zero dependencies
- analyze large datasets in a notebook with ClickHouse performance
- exchange data zero-copy between dataframes and a SQL engine
- prototype analytical queries before deploying to a ClickHouse cluster

## When to choose
- you need ClickHouse-style analytical query performance embedded in a Python, Go, Rust, or Node.js app
- you want to query local Parquet, CSV, JSON, or Arrow files with SQL without a server
- your pandas workflows are too slow and you want a drop-in faster API
- you need a zero-dependency embedded OLAP engine for local development or testing

## When to avoid
- you need a multi-user production database server with distributed scaling
- you require OLTP-style transactional workloads with frequent small writes
- your platform is Windows-only, since official Python support covers macOS and Linux
- you need heavy concurrent write access from multiple processes

## Facets
- artifact type: library
- maturity: active
- function: database, database-driver, data-science, cli
- domain: databases, data-science, analytics, big-data, developer-tools
- platform: python, go, rust, bun, cli
- tags: olap, embedded-database, clickhouse, sql, in-process, pandas, dataframe, parquet, columnar-database, macos, linux, nodejs

## Member repositories
- chdb-io/chdb (main) score 97

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:27.537214+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:35:33.526061+00:00, confidence not recorded.
  - readme: https://github.com/chdb-io/chdb (fetched 2026-08-28T04:07:27.537214+00:00, sha 97771e1fb999)
  - homepage: https://clickhouse.com/chdb (fetched 2026-08-29T09:51:09.629470+00:00, sha f81479eb4183)
  - site_page: https://clickhouse.com/docs (fetched 2026-08-29T09:51:09.638893+00:00, sha 52dde84ec147)
  - site_page: https://clickhouse.com/docs/chdb (fetched 2026-08-29T09:51:09.642581+00:00, sha 20537f743096)
  - site_page: https://clickhouse.com/docs/chdb/install/bun (fetched 2026-08-29T09:51:09.644397+00:00, sha 8cb20c101b38)
  - site_page: https://clickhouse.com/docs/chdb/install/nodejs (fetched 2026-08-29T09:51:09.645892+00:00, sha 8ca8ac53110e)
  - site_page: https://clickhouse.com/docs/chdb/install/rust (fetched 2026-08-29T09:51:09.647440+00:00, sha e0c066efb858)
  - site_page: https://clickhouse.com/docs/chdb/install/go (fetched 2026-08-29T09:51:09.649067+00:00, sha 2eb0203f3330)
  - site_page: https://clickhouse.com/docs/chdb/install/python (fetched 2026-08-29T09:51:09.650789+00:00, sha eabc2b0da720)
  - registry_pypi: https://pypi.org/pypi/chdb/json (fetched 2026-08-29T09:51:09.652704+00:00, sha f26cf98a5893)
- Data as of 2026-08-30T08:39:29.467469+00:00.