TiloBox
Back to directory
chDB project preview
Developer ToolsAlternative to BigQuery LocalAlternative to DuckDBAlternative to SQLite

chDB

In-process ClickHouse SQL engine powered by ClickHouse for ultra-fast local analytics.

View on GitHub Visit website
LicenseApache-2.0
GitHub stars2.8k
Last commit1 weeks ago
Tags5 topics
Parquet Query EngineZero Copy SqlEmbedded OlapClickhouse In ProcessDeveloper Tools
Overview

Why consider chDB?

chDB is an open-source, in-process SQL OLAP engine powered by ClickHouse and written in C++ and Python. Designed to run embedded inside Python, Node.js, and Go without external database servers, chDB executes zero-copy SQL queries across Parquet, CSV, JSON, and Arrow datasets.

Guided learning

Learn chDB by building

Practical setup notes, real use cases, and copy-ready examples in one focused guide.

1 min read 2 sections
In this guide2 sections

Overview of chDB

chDB executes vector-accelerated ClickHouse SQL directly in-memory against local Parquet and JSON files.

Quickstart

bash
1pip install chdb
python
1import chdb
2res = chdb.query("SELECT * FROM 'data.parquet' LIMIT 10", "JSON")
3print(res)

chDB is licensed under the Apache License Version 2.0.

Related tools

More options with a similar category or technology profile.

diskus logo

diskus

Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.

peco logo

peco

Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.

Dapr CLI logo

Dapr CLI

Command-line tool for managing Dapr distributed application runtime environments and sidecars.

Freeze logo

Freeze

Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.

chDB FAQs

chDB is listed as a Developer Tools tool on TiloBox. Review the overview, features, and official documentation on this page to decide whether it solves your specific workflow.

Start with the project's GitHub repository and official website for supported installation and deployment instructions. Test the setup with representative data or a small project before rolling it out more widely.

chDB is listed under the Apache-2.0 license. Read the complete license text and the project's notices before using, modifying, or distributing the software.

Production readiness depends on your requirements. Review maintenance activity, security practices, documentation, backup and upgrade procedures, and compatibility with your stack; then validate it in a non-production environment.

chDB is listed as an alternative to BigQuery Local. Compare the core workflow, deployment model, integrations, and licensing against your must-have requirements before switching.