skills.rest
evrendom
evrendomCOMMUNITY
Explore all skills by this author →
Website𝕏@evrendomGitHub

clickhouse-query

Query ClickHouse databases from the command line using chcli.

289|16|Updated Feb 16, 2026
Search Tags:#database#sql#query#data-extraction#clickhouse#chcli
One-click install
npx skills add https://github.com/evrendom/rudel --skill clickhouse-query-evrendom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickhouse-query
Source: https://github.com/evrendom/rudel/tree/main/.claude/skills/clickhouse-query
Command: npx skills add https://github.com/evrendom/rudel --skill clickhouse-query-evrendom

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill enables direct, fast querying of ClickHouse databases from the command line, enabling rapid data exploration and extraction without a GUI.

Core Features & Use Cases

  • CLI-based querying: Run SQL against ClickHouse databases to verify data, validate schemas, and retrieve results.
  • Schema discovery: Inspect databases and tables (SHOW DATABASES, SHOW TABLES, DESCRIBE) to understand data structures.
  • Data extraction: Export results in machine-friendly formats using -F options for downstream processing.
  • Use Case: Data analysts and engineers can diagnose data issues, verify migrations, or produce export datasets from ClickHouse.

Quick Start

Run a sample query against a ClickHouse instance using chcli.

Frequently Asked Questions about clickhouse-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query ClickHouse from the command line?▼

Query ClickHouse from the command line by executing SQL statements with chcli via bunx or npx. You can run inline ad-hoc queries, verify data, and retrieve results directly in your terminal without needing a GUI.

Can I inspect ClickHouse schemas and tables without a GUI?▼

Yes, you can inspect ClickHouse schemas without a GUI by running standard SQL commands like SHOW DATABASES, SHOW TABLES, and DESCRIBE through the chcli command line interface to explore your data structure.

How do I extract data from ClickHouse into machine-friendly formats?▼

Extract data from ClickHouse into machine-friendly formats by applying the -F option when running your SQL queries with chcli, allowing seamless data export for downstream processing pipelines.

Do I need to install chcli globally to run SQL queries against ClickHouse?▼

No, you do not need to install chcli globally to run ClickHouse SQL queries. The Skill executes chcli on demand using bunx or npx, pulling connection details directly from environment variables or CLI flags.

Can I query multiple ClickHouse databases in a single command?▼

Yes, you can query multiple ClickHouse databases in a single command by supplying the appropriate connection details and SQL syntax, enabling data extraction across single or multiple databases using chcli.

What is the best way to run ad-hoc SQL queries against ClickHouse for data validation?▼

The best way to run ad-hoc SQL queries against ClickHouse for data validation is using chcli through bunx or npx, passing inline SQL statements with the -q option to quickly verify data and diagnose issues.

Related Skills

Explore More Data & Analytics Skills→
PostHogPostHog
58

feature-flags-android

Configure PostHog feature flags in Android apps via the Android SDK.

Official
Intermediate
MapleTechLabsMapleTechLabs
1.6k

chdb-sql

Execute ClickHouse SQL queries on local files and remote databases in Python.

Official
Intermediate
fredericvahrenhorstfredericvahrenhorst

clickhouse-io

Apply ClickHouse patterns to optimize analytics queries and table designs.

Community
Advanced
DanielPodolskyDanielPodolsky
274

database-fundamentals

Analyze database schema design, SQL queries, and ORM usage for correctness.

Community
Basic