Sign in
skill · clickhouse.com

chdb-sql

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.

What is inside

A bundle nobody here opened

Its publisher serves this as an archive. Nothing in this catalog fetches it, unpacks it or looks inside, so everything on this page is what its publisher says it holds, and no more.

What this is

Skill

application/ai-skill-archive+gziplast seen 2026-08-28

These are the publisher's own words, read from what they serve at their own address.

Where it lives

The publisher's own address

https://clickhouse.com/.well-known/agent-skills/chdb-sql.tar.gz

This catalog links to it and never serves a copy, so what you get is whatever clickhouse.com is serving now.

In its own words

What its publisher says you would ask it

  • query CSV and JSON files with SQL from Python
  • read S3 or Iceberg tables with ClickHouse table functions in Python
  • run ClickHouse SQL on local parquet files without a server
Tags

How its publisher filed it

chdbpythonsqlembedded