DoubleCloud is winding down. Migrate to ClickHouse with limited-time free migration services. Contact us today ->->

chDB - fast, reliable, and scalable in-process database

Experience the power of ClickHouse, in-process. With unparalleled performance, reliability, and scalability for any data-intensive application.
Blazing fast SQL engine
Seamless data integration
Supports 80+ data formats

chDB and the ClickHouse ecosystem

Whether you're developing locally, running in-process analytics embedded in your app, or scaling production workloads, ClickHouse has you covered.
ClickHouse
chDB: ClickHouse In-Process
ClickHouse Local

Start using chDB in minutes

Install chDB for macOS and Linux
pip install chdb
query = "select count() FROM s3('s3://datasets-documentation/hackernews/hacknernews.json.gz')"
chdb.query(query,'DataFrame')
Sample Query
Book icon

Open-source
library

chDB is an open-source library, allowing you to customize and extend your database to fit your needs. Benefit from a vibrant community that keeps you updated with the latest innovations and security practices.
List icon

Query objects
directly

With chDB, you can query native objects in the programming language of choice directly. This direct access reduces latency and simplifies data processing, enabling faster operations.
File icon

Supports Python
DB API 2.0

chDB supports Python DB API 2.0, ensuring seamless integration with your Python applications. Enjoy consistency, reliability, and ease of use with familiar libraries and tools.
chDB supports bindings for many programming languages, including:
BunnodeRustGOPython

Embedded. No need to install or run ClickHouse services

Streamline deployment with no additional setup
Reduce system complexity and resource usage
Ideal for lightweight and embedded applications
Embedded

Minimized data copying from
C++ to Python

Enhance performance with direct memory access
Reduce overhead and latency in data processing
Achieve faster data handling and analysis
Minimized Copying

Input and output support
Parquet, CSV, JSON, Arrow,
ORC and 80+ more formats

Easily integrate with diverse data sources
Simplify data interchange and interoperability
Ensure compatibility with a wide range of data formats
Input Output

chDB regularly outperforms DuckDB, Pandas, and Polars in benchmark queries

With chDB, you have the benefit of ClickHouse's blazing speed, in-process.
Graph panelGraph chDBGraph DuckDBGraph PandasGraph Polars
For more details, check out our full benchmark results.
FAQ Icon

What is chDB used for?

Wherever you need us, we’re there. We love to engage in thoughtful conversation with the ClickHouse community and are always on-hand to answer your questions.
Ask us anything
01Testing your queries in CI without having to spin up a CH server
02Building self-contained prototypes/PoCs
03Jupyter notebooks without a CH Server running

Looking for a hosted solution?
Get started with ClickHouse Cloud

30 day free trial and $300 in credits to spend at your own pace.