skills.rest
ClickHouse
ClickHouseOFFICIAL
Explore all skills by this author →
Website𝕏@ClickHouseDBGitHub

infra-clickhouse

Sets up local ClickHouse development servers and deploys managed ClickHouse Cloud services via clickhousectl.

525|36|Updated Jan 15, 2026
Search Tags:#schema migration#cloud deployment#local development#clickhouse#database setup#clickhousectl#devOps
One-click install
npx skills add https://github.com/ClickHouse/agent-skills --skill infra-clickhouse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: infra-clickhouse
Source: https://github.com/ClickHouse/agent-skills/tree/main/skills/infra-clickhouse
Command: npx skills add https://github.com/ClickHouse/agent-skills --skill infra-clickhouse

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Setting up ClickHouse for development and production involves many manual steps: installing binaries, starting servers, writing schemas, seeding data, creating cloud accounts, authenticating CLIs, migrating schemas, and provisioning application users. This Skill turns that into guided, step-by-step workflows driven by the clickhousectl CLI.

Core Features & Use Cases

  • Local Development Workflow: Installs ClickHouse, initializes a project structure (tables, materialized views, queries, seed data), starts a local server, applies schemas, and verifies the setup.
  • ClickHouse Cloud Deployment: Walks through account signup, API key authentication, service creation, schema migration from local files, and deployment verification.
  • Secure Application Connection: Creates a dedicated least-privilege database user with generated credentials stored in .env instead of using the admin default user.
  • Use Case: A developer building an analytics app asks to set up ClickHouse locally; the Skill installs the server, creates tables, seeds data, and later migrates everything to ClickHouse Cloud when going to production.

Quick Start

Ask the agent to set up a local ClickHouse development environment with clickhousectl, or to deploy your local ClickHouse schema to ClickHouse Cloud for production.

Frequently Asked Questions about infra-clickhouse

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

FAQPage Schema
How do I set up a local ClickHouse server for development?▼

Install clickhousectl, then run clickhousectl local use latest to install ClickHouse, clickhousectl local init to create the project structure, and clickhousectl local server start to launch a server. Apply schemas with clickhousectl local client --queries-file.

How to deploy ClickHouse to ClickHouse Cloud from the command line?▼

Authenticate with clickhousectl cloud auth login using an API key and secret, then run clickhousectl cloud service create --name <name>. Migrate schemas with clickhousectl cloud service query --queries-file and verify with SHOW TABLES.

Does clickhousectl require a ClickHouse Cloud account for local development?▼

No, local development with clickhousectl local commands works entirely on your machine without any cloud account. A ClickHouse Cloud account and API key are only needed for the cloud workflow commands.

Why does clickhousectl cloud auth need an Admin API key?▼

The cloud service query command auto-provisions a per-service query endpoint API key on first use, which requires permission to create keys. Developer-scoped keys can manage services but may fail during that auto-provisioning step.

Should my application connect to ClickHouse with the default user?▼

No, the default user has full admin rights and should not be used by applications. Create a dedicated user with a generated password and grant only the minimum permissions needed, such as SELECT and INSERT on the specific database.

Related Skills

Explore More Software Engineering Skills→
MakisuoMakisuo
1.6k

clickhousectl-local-dev

Install and configure a local ClickHouse environment with clickhousectl.

Community
Intermediate
The-Skyy-Rose-Collection-LLCThe-Skyy-Rose-Collection-LLC
3

clickhouse-io

Design ClickHouse analytics schemas with MergeTree table engines and query optimizations.

Official
Intermediate
duyetduyet

clickhouse

Provides ClickHouse schema, query, and ingestion optimization guidance.

Community
Advanced
OpenHandsOpenHands
134

docker

Start a Docker daemon and run containers inside containerized environments.

Official
Advanced