clickhouse-best-practices
Schema, query, and configuration optimization rules for ClickHouse.
Developer Setup
Setup & Installation
npx skills add https://github.com/ClickHouse/agent-skills --skill clickhouse-best-practicesnpx skills add https://github.com/ClickHouse/agent-skills --skill clickhouse-best-practicesOverview
What This Skill Does
Defines 31 rule-checks to audit and optimize ClickHouse schemas, queries, compressions, and resource configurations.
Application
When to use this Skill
- Reviewing ClickHouse database schemas, queries, or configuration parameters.
- Citing specific optimization rules when analyzing slow SQL queries.
- Implementing compression, encoding, and codecs for column types.
- Resolving common performance anti-patterns in partition keys or index setups.
- Auditing system resource allocations for ClickHouse memory or disk threads.
Documentation
Show Skills.md file
ClickHouse Best Practices
Comprehensive guidance for ClickHouse covering schema design, query optimization, data ingestion, and AI agent connectivity. Contains 31 rules across 4 main categories (schema, query, insert, agent), prioritized by impact.
Official docs: ClickHouse Best Practices
IMPORTANT: How to Apply This Skill
Before answering ClickHouse questions, follow this priority order:
- Check for applicable rules in the
rules/directory - If rules exist: Apply them and cite them in your response using "Per
rule-name..." - If no rule exists: Use the LLM's ClickHouse knowledge or search documentation
- If uncertain: Use web search for current best practices
- Always cite your source: rule name, "general ClickHouse guidance", or URL
Why rules take priority: ClickHouse has specific behaviors (columnar storage, sparse indexes, merge tree mechanics) where general database intuition can be misleading. The rules encode validated, ClickHouse-specific guidance.
Agent Connectivity & Query Workflow
Before querying ClickHouse, agents must establish a connection and follow the discovery workflow:
rules/agent-connect-mcp.md- Connection setup (MCP + CLI), credential discovery, output format selection
Recommendations
Explore other random skills
frontend-skill
Create visually strong landing pages, websites, and app UIs with restrained composition
playwright-interactive
Persistent browser and Electron interaction via js_repl for iterative UI debugging
slides
Create and edit .pptx presentation decks with PptxGenJS