chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
About the project
chDB is an in-process OLAP SQL engine powered by ClickHouse, allowing applications to query analytical data without running a separate database server. Python users and data practitioners use it to work with formats such as Parquet, CSV, JSON, Arrow, and ORC through SQL or a pandas-compatible API. Its catalogue add-ons provide agent instructions, rules, skills, and an agent for working with the project.
Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. Provides chDB DataStore — same pandas API, ClickHouse engine underneath. Also handles reading from S3, MySQL, PostgreSQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake…
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ functions, Session for…