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+ function

chdb SQL — ClickHouse in Your Python Process Run ClickHouse SQL directly in Python — no server needed. Query local files, remote databases, and cloud storage with full ClickHouse SQL power. Decision Tree: Pick the Right API chdb.query() — One Line, Any Data Table functions → [table functions.md](references/table functions.md) SQL functions → [sql functions.md](references/sql functions.md) Full API → [api reference.md](references/api reference.md) Session — Stateful Analysis Pipelines Connection API (DB API 2.0) Troubleshooting Problem Fix ImportError: No module named 'chdb' pip install chdb DB::Exception: FILE NOT FOUND Check file path; use absolute path or verify cwd DB::Exception: Unknown table function Check function name spelling (e.g., deltaLake not deltalake ) Connection refused to remote DB Check host:port format; ensure remote DB allows connections Environment check Run python scripts/verify install.py (from skill directory) References [API Reference](references/api reference.md) — query/Session/connect signatures [Table Functions](references/table functions.md) — All ClickHouse table functions [SQL Functions](references/sql functions.md) — Commonly used SQL functions [Examples](examples/examples.md) — 9 runnable examples with expected output [Official Docs](https://clickhouse.com/docs/chdb) Note: This skill teaches how to use chdb SQL. For pandas style operations, use the chdb datastore skill. For contributing to chdb source code, see CLAUDE.md in the project root.

chdb-sql