Chdb Sql
by ClickHouse2f6ec4b17a81Apache-2.0544 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 9 days ago
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 stateful multi-step pipelines, parametrized queries, and cross-source joins via `s3()`, `mysql()`, `postgresql()`, `iceberg()`, `deltaLake()`, `remoteSecure()` table functions. TRIGGER when: user wants SQL on parquet/csv/files or across remote analytical sources; uses ClickHouse SQL features (window functions, windowFunnel, geoToH3, JSON path ops, Session, parametrized queries); imports `chdb` or calls `chdb.query()`. SKIP this skill for pandas-style DataFrame method-chaining (use chdb-datastore instead) or ClickHouse server administration.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| examples/examples.md | 9.4 KB | text/markdown |
| metadata.json | 451 B | application/json |
| README.md | 1.2 KB | text/markdown |
| references/api-reference.md | 6.3 KB | text/markdown |
| references/sql-functions.md | 9.8 KB | text/markdown |
| references/table-functions.md | 5.2 KB | text/markdown |
| scripts/verify_install.py | 2.7 KB | text/plain |
| SKILL.md | 4.9 KB | text/markdown |
Source and attribution
Source:ClickHouse/agent-skillsinskills/chdb-sqlat commit2f6ec4b
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from ClickHouse/agent-skills
Clickhouse Managed Postgres Rca
ClickHouse
Evidence-based root cause analysis workflow for performance issues on ClickHouse-managed Postgres instances.
Clickhouse Js Node Troubleshooting
ClickHouse
Troubleshoots common errors and configuration issues with the ClickHouse Node.js client (@clickhouse/client).
Clickhouse Best Practices
ClickHouse
Reviews ClickHouse schemas, queries, and ingestion strategies against 31 documented best-practice rules.
Clickhouse Architecture Advisor
ClickHouse
Guides ClickHouse architecture decisions for specific workloads, labeling each recommendation as official, derived, or field.
Chdb Datastore
ClickHouse
Use chdb DataStore as a drop-in, ClickHouse-backed replacement for pandas to query, join and aggregate tabular data.