chdb-sql

Run analytical SQL without a server.

analytical SQL

What it does

Run ClickHouse SQL on local files, remote sources, and cloud storage from Python without a server.

When to use it

Use when the user wants SQL over files, URLs, S3 paths, remote databases, or ClickHouse SQL features.

Give it a SQL query and data source; it returns query results using chdb.query(), Session, or the DB-API connection.

What you provide

This skill

remote databases

Read

Reads remote databases

cloud storage

Read

Reads cloud storage

HTTP/HTTPS URLs

Read

Reads HTTP/HTTPS URLs

persistent Session database directory

Write

Saves persistent analytical tables

Requires Python 3.9 or newer.

Runs on macOS or Linux.

The chdb Python package must be installed with pip.

An LLM API key configured through environment variables enables the AI-assisted SQL features.