chdb-sql
chdb-sql is an agent skill published by clickhouse, listed under data & analysis. It lives in the ClickHouse/agent-skills repository, which has 561 GitHub stars and is licensed under Apache-2.0; we last read it on 2026-09-16.
chdb-sql connects to local files, URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) and runs SQL queries, including analytical SQL, using embedded ClickHouse SQL in Python with support for 1000+ functions, sessions, parametrized queries, and cross-source joins.
Install
skills is a generic installer for any repository of Claude agent skills -- it reads ClickHouse/agent-skills’s own structure rather than assuming one, the same way this page reads the skill’s own SKILL.md rather than assuming a format.
npx skills add ClickHouse/agent-skills
Maintenance
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.
chdb-sql compared with similar skills
| Skill | Publisher | What it does | Repo stars | Last update |
|---|---|---|---|---|
| chdb-sql (this page) | clickhouse | Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3… | 561 | 2026-10-25 |
| chdb-datastore(same repository) | clickhouse | Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group,… | 561 | 2026-10-25 |
| agent-platform-rag-engine-management | Manage and query Agent Platform RAG Engine Corpora and retrieve grounded contexts using the Google GenAI SDK.… | 21,580 | 2026-10-25 | |
| alloydb-basics | Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Contex… | 21,580 | 2026-10-25 | |
| bigquery-ai-ml | Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. Use when y… | 21,580 | 2026-10-25 | |
| bigquery-basics | Manages datasets, tables, and jobs in BigQuery. Use when you need to interact with BigQuery, run SQL queries,… | 21,580 | 2026-10-25 | |
| bigquery-bigframes | Generates Python code using BigQuery DataFrames (BigFrames). Use by default for any Python data task involvin… | 21,580 | 2026-10-25 |
Skills from the same repository first, then others for this job by repository stars. Figures are from each repository when we last read it.
Common questions about chdb-sql
- What does chdb-sql do?
- chdb-sql connects to local files, URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) and runs SQL queries, including analytical SQL, using embedded ClickHouse SQL in Python with support for 1000+ functions, sessions, parametrized queries, and cross-source joins.
- How do I install chdb-sql?
- Run npx skills add ClickHouse/agent-skills. The skills installer reads the repository’s own structure, so it works for any repository of agent skills.
- Who publishes chdb-sql?
- clickhouse.
- Is chdb-sql maintained, and what licence does it use?
- Its repository has 561 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-25. The repository declares the Apache-2.0 licence.
More agent skills for data & analysis
- case-study-writingby 101-skills
- python-executorby 101-skills
- marketplace-managerby bradautomates
- ebay-sold-listings-searchby browser-act
- facebook-page-postsby browser-act
- facebook-page-profile-postsby browser-act