skills.rest
cline
clineOFFICIAL
Explore all skills by this author →
WebsiteGitHub

clickhouse

Query ClickHouse servers and Cloud services via the clickhousectl CLI.

19|3|Updated May 17, 2026
Search Tags:#sql#data-analytics#cloud-database#clickhouse#query-execution#schema-discovery#clickhousectl
One-click install
npx skills add https://github.com/cline/skills --skill clickhouse-cline
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickhouse
Source: https://github.com/cline/skills/tree/main/skills/data-analyst/skills/clickhouse
Command: npx skills add https://github.com/cline/skills --skill clickhouse-cline

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the friction of manually connecting to ClickHouse instances (local servers or ClickHouse Cloud services) and running ad-hoc SQL queries, handling authentication, server targeting, and safe query execution without requiring custom tooling or integrations.

Core Features & Use Cases

  • Multi-Target Connectivity: Connect to local ClickHouse servers managed by clickhousectl, any remote host/port instance, or ClickHouse Cloud services directly from the terminal.
  • Flexible Authentication: Supports browser OAuth for read-only Cloud exploration and API key auth for read/write operations, with secure local credential storage.
  • Safe Query Guardrails: Includes best practices for schema discovery, bounded queries to avoid timeouts on large tables, and structured result packaging for downstream use. A data analyst can use this to quickly inspect a Cloud service's event table schema, run a 7-day aggregated count query, and get parsed JSON results without leaving their terminal.

Quick Start

Use the clickhouse skill to run a SHOW DATABASES query against your connected ClickHouse Cloud service and return the results in JSON format.

Frequently Asked Questions about clickhouse

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

FAQPage Schema
How do I run ad-hoc SQL queries against ClickHouse Cloud from the terminal?▼

You can query ClickHouse Cloud directly from the terminal by authenticating with an API key or browser OAuth and executing SQL statements via the official clickhousectl CLI, receiving machine-readable formatted output for downstream processing.

Can I discover database schemas in ClickHouse without writing custom integration code?▼

Schema discovery in ClickHouse is supported natively through terminal-based commands, allowing you to inspect table structures and run bounded queries safely without needing custom tooling or complex integrations.

Does ClickHouse terminal querying support both local servers and Cloud services?▼

ClickHouse terminal connectivity supports multi-target querying, enabling you to connect to local servers managed by clickhousectl, remote host/port instances, or ClickHouse Cloud services directly from your workflow.

What is the best way to avoid query timeouts on large ClickHouse fact tables?▼

To avoid timeouts on large ClickHouse fact tables, you should apply safe bounded query practices by limiting query scopes, ensuring structured result packaging and preventing unbounded scans during ad-hoc data analysis.

How does authentication work for read-only exploration versus read-write operations in ClickHouse Cloud?▼

ClickHouse Cloud authentication uses browser OAuth for secure read-only exploration and API key authentication for read/write operations, with credentials stored locally to manage access safely.

Related Skills

Explore More Data & Analytics Skills→
MakisuoMakisuo
1.6k

clickhousectl-local-dev

Install and configure a local ClickHouse environment with clickhousectl.

Community
Intermediate
ginkidaginkida
20

sql-analyst

Optimize SQL queries and design schemas for PostgreSQL, MySQL, and SQLite.

Community
Intermediate
hgflimahgflima
1

deby

Manage PostgreSQL connections, schemas, and SQL queries via natural language.

Community
Advanced
interflownexinterflownex
2

cloud-sql-sqlserver-data

Execute SQL queries and inspect schema structures on Cloud SQL for SQL Server instances.

Community
Intermediate