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.
How to install chdb-sql?
clickhouse/agent-skills/chdb-sql
$npx -y skills add clickhouse/agent-skills --skill chdb-sqlInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/clickhouse/agent-skills" --skill "clickhouse/agent-skills/chdb-sql"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/clickhouse/agent-skills" that are relevant to the current task. Run `npx skills add "https://github.com/clickhouse/agent-skills"` and select the relevant skills, then follow their instructions.
Related
6 picksType
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase.Jul 2026
- firebase-data-connect-basicsBuilds and deploys Firebase SQL Connect (aka Firebase Data Connect) backends with PostgreSQL securely.Jul 2026
- firebase-firestoreSets up, manages, queries, and configures Cloud Firestore databases (Standard/Enterprise edition), including data modeling, security rules, indexes, and SDK…Jul 2026
- prisma-database-setupGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).Jul 2026
- prisma-client-apiPrisma Client API reference covering model queries, filters, operators, and client methods.Jul 2026
- prisma-cliPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp.Jul 2026
