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,

chdb DataStore — It's Just Faster Pandas The Key Insight DataStore is a lazy, ClickHouse backed pandas replacement . Your existing pandas code works unchanged — but operations compile to optimized SQL and execute only when results are needed (e.g., print() , len() , iteration). Decision Tree: Pick the Right Approach Connect to Any Data Source — One Pattern All 16+ sources and URI schemes → [connectors.md](references/connectors.md) After Connecting — Full Pandas API 209 DataFrame methods supported. Full API → [api reference.md](references/api reference.md) Cross Source Join — The Killer Feature More join examples → [examples.md](examples/examples.md) Writing Data Troubleshooting Problem Fix ImportError: No module named 'chdb' pip install chdb ImportError: cannot import 'DataStore' Use from datastore import DataStore or from chdb.datastore import DataStore Database connection timeout Include port in host: host="db:3306" not host="db" Join returns empty result Check key types match (both int or both string); use .to sql() to inspect Unexpected results Call ds.to sql() to see the generated SQL and debug Environment check Run python scripts/verify install.py (from skill directory) References [API Reference](references/api reference.md) — Full DataStore method signatures [Connectors](references/connectors.md) — All 16+ data source connection methods [Examples](examples/examples.md) — 10+ runnable examples with expected output [Verify Install](scripts/verify install.py) — Environment verification script [Official Docs](https://clickhouse.com/docs/chdb) Note: This skill teaches how to use chdb DataStore. For raw SQL queries, use the chdb sql skill. For contributing to chdb source code, see CLAUDE.md in the project root.

chdb-datastore