chdb-sql
In-process ClickHouse SQL engine for Python — run ClickHouse SQL queries directly on local files, remote databases, and cloud storage without a server. Use when the user wants to write SQL queries against Parquet/CSV/ JSON files, use ClickHouse table functions (mysql(), s3(), postgresql(), iceberg(), deltaLake() etc.), build stateful analytical pipelines with Session, use parametrized queries, window functions, or other advanced ClickHouse SQL features. Also use when the user explicitly mentions chdb.query(), ClickHouse SQL syntax, or wants cross-source SQL joins. Do NOT use for pandas-style DataFrame operations — use chdb-datastore instead.
- Version
- 4.1
- License
- Apache-2.0
- Compatibility
- Requires Python 3.9+, macOS or Linux. pip install chdb.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/chdb-sql/SKILL.md
- skills/chdb-sql/LICENSE
- skills/chdb-sql/README.md
- skills/chdb-sql/examples/examples.md
- skills/chdb-sql/metadata.json
- skills/chdb-sql/references/api-reference.md
- skills/chdb-sql/references/sql-functions.md
- skills/chdb-sql/references/table-functions.md
- skills/chdb-sql/scripts/verify_install.py
Every link opens the file at its source, pinned to the revision this page describes.