chdb

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

What is chdb?

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

Overview of chdb

What it is

chDB is an in-process SQL OLAP Engine powered by ClickHouse. It is designed to run embedded in applications without requiring a separate ClickHouse installation. The project also provides chDB-Wasm, a WebAssembly build that runs the full ClickHouse engine in the browser.

Key features

  • Pandas-compatible DataStore API that allows using familiar pandas syntax with ClickHouse performance - Runs in the browser via WebAssembly (chDB-Wasm) at wasm.chdb.io - In-process SQL OLAP Engine, no need to install ClickHouse - Minimized data copy from C++ to Python using Python memoryview - Input and output support for Parquet, CSV, JSON, Arrow, ORC and 60+ other formats - Supports Python DB API 2.0

Use cases

Use cases include in-process OLAP queries, data analysis with a pandas-like API, querying files in various formats (Parquet, CSV, JSON, etc.), and running SQL directly in the browser via WebAssembly.

Getting started

Install chDB via pip: bash pip install chdb For ADBC support (Python 3.10+): bash pip install 'chdb[adbc]' Run a quick SQL query from the command line: bash python3 -m chdb 'SELECT 1,'abc'' Pretty For a no-install option, open wasm.chdb.io in a browser. To use the DataStore API, change your import: python import datastore as pd

License and pricing

The project is licensed under Apache-2.0 and is open source.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/chdb-iochdb.svg)](https://yunodb.com/tools/chdb-iochdb?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/chdb-iochdb?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/chdb-iochdb.svg" alt="Featured on YunoDB" height="20"></a>