Skills
.Work. You
Rest

chdb-sql

Official

Run SQL locally in Python with ClickHouse

Data & Analytics#python#sql#session#data-analytics#clickhouse#table-functions#parametrized-queries
AuthorClickHouse
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Run SQL analytics locally in Python without a server by embedding ClickHouse SQL through chdb to query local files (parquet, csv, json), URLs, S3 paths, or remote databases such as Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, and Delta Lake.

Core Features & Use Cases

  • Embeds ClickHouse SQL in Python via chdb.query() and Session for multi-step pipelines with parametrized queries.
  • Access external data sources with table functions like file(), s3(), mysql(), postgresql(), remoteSecure(), iceberg(), deltaLake(), enabling cross-source joins.
  • Outputs results in CSV, DataFrame, or other formats to integrate with Python data workflows; suitable for ad-hoc analytics, lightweight ETL, and data discovery.

Quick Start

Install chdb and run a simple query against a local Parquet file to verify the setup.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: chdb-sql
Download link: https://github.com/ClickHouse/agent-skills/archive/main.zip#chdb-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.