clickhouse-docs

Stars7

Forks1

UpdatedJuly 25, 2026 at 04:08

Use when working with ClickHouse: MergeTree engine family, SQL syntax, data types, table functions, materialized views, dictionaries, data modeling (denormalization, sharding, replication), integrations (Kafka, S3, PostgreSQL, MySQL), ClickHouse Cloud, Kubernetes operator, data compression, query optimization, or troubleshooting ClickHouse issues.

Installation

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Source

wenerme

wenerme/ai

View GitHub Repository View Creator Repositories

Download

Related occupationsSOC

Based on SOC occupation classification

Database ArchitectsComputer and Mathematical Occupations·SOC 15-1243

File Explorer

100 files

SKILL.md

readonly

name	clickhouse-docs
description	Use when working with ClickHouse: MergeTree engine family, SQL syntax, data types, table functions, materialized views, dictionaries, data modeling (denormalization, sharding, replication), integrations (Kafka, S3, PostgreSQL, MySQL), ClickHouse Cloud, Kubernetes operator, data compression, query optimization, or troubleshooting ClickHouse issues.

ClickHouse Documentation

Official ClickHouse docs (sourced from github.com/ClickHouse/clickhouse-docs).

CRITICAL: grep references/ for keywords before answering.

Topic Index

Getting Started

docs/getting-started/ — Installation, quick start
docs/intro.md, docs/tutorial.md — Introduction, tutorial

Concepts & Data Modeling

docs/concepts/ — Core concepts
docs/data-modeling/ — Schema design, denormalization, sharding, replication
docs/data-compression/ — Compression codecs and optimization

SQL & Engine Reference

docs/guides/ — SQL reference, table engines, MergeTree family, data types, functions
docs/dictionary/ — External dictionaries
docs/materialized-view/ — Materialized views

Data Management

docs/managing-data/ — Insert, update, delete, migrations, TTL

Integrations

docs/integrations/ — Kafka, S3, PostgreSQL, MySQL, ClickPipes, language clients, visualization tools (Grafana, Superset, Metabase)

Operations

docs/operations_/ — Configuration, monitoring, access control, backup, scaling
docs/deployment-guides/ — Self-managed deployment
docs/kubernetes-operator/ — K8s operator

Cloud

docs/cloud/ — ClickHouse Cloud: setup, security, billing, migrations

Advanced

docs/best-practices/ — Best practices
docs/use-cases/ — Analytics, observability, time series
docs/native-protocol/ — Native binary protocol
docs/chdb/ — chDB (embedded ClickHouse)
docs/tools-and-utilities/ — clickhouse-client, clickhouse-local, clickhouse-benchmark

Troubleshooting & FAQ

docs/troubleshooting/ — Common issues
docs/faq/ — Frequently asked questions
knowledgebase/ — 118 community knowledge base articles

More from this repository

same repository

claude-code-docs

wenerme/ai

Use when answering questions about Claude Code CLI features, configuration, hooks, skills, MCP, permissions, settings, sub-agents, teams, plugins, keybindings, IDE integration, CI/CD setup, troubleshooting, or any Claude Code usage topic.

2026-07-267

doris-docs

wenerme/ai

Use when working with Apache Doris: table design, data models (Duplicate/Unique/Aggregate), partitioning, bucketing, SQL syntax, data import (Stream Load, Broker Load, INSERT INTO), data export, lakehouse (Hive/Iceberg/Hudi/Paimon catalogs), materialized views, query acceleration, inverted index, compute-storage decoupled mode, administration, or Doris ecosystem tools.

2026-07-267

justfile-docs

wenerme/ai

justfile (just) documentation — a command runner with make-inspired syntax. Covers recipes (parameters, dependencies, shebang/script recipes), justfile language (settings, strings, functions, constants, attributes, conditionals, backticks), modules/imports, variables, shell configuration, and CLI options. USE THIS SKILL WHEN the user asks about just, justfile syntax, just recipes, just modules, just functions, or just settings.

2026-07-267

mastra-docs

wenerme/ai

USE THIS SKILL WHEN working with Mastra (TypeScript AI agent framework): building agents, workflows, RAG pipelines, memory, voice, evals, MCP tools, observability/tracing, deploying to Mastra Cloud/Cloudflare/Vercel, or using Mastra client SDK. Triggers on: mastra, Mastra agent, Mastra workflow, createAgent, createWorkflow, mastra.run, MastraClient, @mastra/core.

2026-07-267

openrouter-docs

wenerme/ai

Use when working with the OpenRouter API: model routing, provider selection, model variants (free/nitro/thinking), tool calling, structured outputs, prompt caching, OAuth, API keys, rate limits, streaming, embeddings, Claude Code integration, or any OpenRouter-specific feature.

2026-07-267

ultralytics-docs

wenerme/ai

Use when working with Ultralytics YOLO, including YOLO26/YOLO11/YOLOv8 models, detect/segment/classify/pose/OBB tasks, train/val/predict/export/track/benchmark modes, dataset YAML formats, HUB/platform workflows, integrations, solutions, or ultralytics Python API behavior.

2026-07-267

name	clickhouse-docs
description	Use when working with ClickHouse: MergeTree engine family, SQL syntax, data types, table functions, materialized views, dictionaries, data modeling (denormalization, sharding, replication), integrations (Kafka, S3, PostgreSQL, MySQL), ClickHouse Cloud, Kubernetes operator, data compression, query optimization, or troubleshooting ClickHouse issues.

ClickHouse Documentation

Official ClickHouse docs (sourced from github.com/ClickHouse/clickhouse-docs).

CRITICAL: grep references/ for keywords before answering.

Topic Index

Getting Started

docs/getting-started/ — Installation, quick start
docs/intro.md, docs/tutorial.md — Introduction, tutorial

Concepts & Data Modeling

docs/concepts/ — Core concepts
docs/data-modeling/ — Schema design, denormalization, sharding, replication
docs/data-compression/ — Compression codecs and optimization

SQL & Engine Reference

docs/guides/ — SQL reference, table engines, MergeTree family, data types, functions
docs/dictionary/ — External dictionaries
docs/materialized-view/ — Materialized views

Data Management

docs/managing-data/ — Insert, update, delete, migrations, TTL

Integrations

docs/integrations/ — Kafka, S3, PostgreSQL, MySQL, ClickPipes, language clients, visualization tools (Grafana, Superset, Metabase)

Operations

docs/operations_/ — Configuration, monitoring, access control, backup, scaling
docs/deployment-guides/ — Self-managed deployment
docs/kubernetes-operator/ — K8s operator

Cloud

docs/cloud/ — ClickHouse Cloud: setup, security, billing, migrations

Advanced

docs/best-practices/ — Best practices
docs/use-cases/ — Analytics, observability, time series
docs/native-protocol/ — Native binary protocol
docs/chdb/ — chDB (embedded ClickHouse)
docs/tools-and-utilities/ — clickhouse-client, clickhouse-local, clickhouse-benchmark

Troubleshooting & FAQ

docs/troubleshooting/ — Common issues
docs/faq/ — Frequently asked questions
knowledgebase/ — 118 community knowledge base articles