clickhouse best practices — Agent Skill
by ClickHouse · Updated
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
At a glance
clickhouse-best-practices is an Agent Skill by ClickHouse in the Design & Creative category. In Claude Code it installs with `/plugin install clickhouse-best-practices@claude-plugins-official` after adding the anthropics/claude-plugins-official marketplace; other assistants use its SKILL.md instructions as rules. Its source repository has 562 GitHub stars (as of Oct 28, 2026).
How to install clickhouse best practices in your AI client
Setup for Claude Code, Claude Desktop, Cursor, Codex, Windsurf, Cline and VS Code — copy-paste ready.
How to install clickhouse best practices in Claude CodeAnthropic's agentic CLI
Add the marketplace
claude/plugin marketplace add anthropics/claude-plugins-officialInstall the skill
claude/plugin install clickhouse-best-practices@claude-plugins-officialUse it
These are slash commands for a Claude Code session, not your shell. Claude auto-invokes the skill when your request matches its description — or type its slash command if it exposes one.
How to install clickhouse best practices in Claude DesktopDesktop app (MCP config)
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitAdd the SKILL.md to your Skills folder
Settings → Capabilities → Skills → add the folder containing SKILL.md. Claude picks it up automatically.
How to install clickhouse best practices in CursorAI-first code editor
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitConvert to a Cursor rule
Create .cursor/rules/clickhouse-best-practices.mdc and paste the SKILL.md body. Set `alwaysApply` or a glob so the Agent loads it in context.
How to install clickhouse best practices in Codex CLIOpenAI coding agent
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitReference in AGENTS.md
Add the skill's instructions (or a link) to AGENTS.md at your repo root — Codex reads it on every run.
How to install clickhouse best practices in WindsurfCodeium's agentic IDE
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitAdd to your rules / context
Paste the SKILL.md instructions into this tool's custom rules or workspace instructions so the agent follows them.
How to install clickhouse best practices in ClineVS Code autonomous agent
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitAdd to your rules / context
Paste the SKILL.md instructions into this tool's custom rules or workspace instructions so the agent follows them.
How to install clickhouse best practices in VS CodeCopilot / MCP support
Clone the source
bashgit clone https://github.com/ClickHouse/agent-skills.gitAdd to your rules / context
Paste the SKILL.md instructions into this tool's custom rules or workspace instructions so the agent follows them.
Documentation
Full READMEClickHouse Agent Skills
The official Agent Skills for ClickHouse. These skills help LLMs and agents to adopt best practices when working with ClickHouse and chdb (in-process ClickHouse for Python).
You can use these skills with open-source ClickHouse and managed ClickHouse Cloud. Try ClickHouse Cloud with $300 in free credits.
Installation
npx
npx skills add clickhouse/agent-skillsThe CLI auto-detects installed agents and prompts you to select where to install.
clickhousectl
Use the ClickHouse CLI `clickhousectl` to install the agent skills:
clickhousectl skillsWhat is this?
Agent Skills are packaged instructions that extend AI coding agents (Claude Code, Cursor, Copilot, etc.) with domain-specific expertise. This repository provides skills for ClickHouse databases and chdb — covering schema design, query optimization, data ingestion patterns, and in-process analytics with Python.
When an agent loads these skills, it gains knowledge of ClickHouse best practices and chdb APIs, and can apply them while helping you design tables, write queries, analyze data, or troubleshoot performance issues.
Skills follow the open specification at agentskills.io.
Excerpt — the full document is on GitHub.
More Design & Creative skills
- Design & Creative185k
example skills
Collection of example skills demonstrating various capabilities including skill creation, MCP building, visual design, algorithmic art, internal communications, web testing, artifact building, Slack GIFs, and theme styling
Anthropic Skills12 skillsby anthropics
- Design & Creative185k
academy guide
Recommends relevant Claude Academy courses, tutorials, and use cases when users ask how to use Claude
Anthropic Skills1 skillsby anthropics
- Design & Creative75k
hyperframes
HyperFrames by HeyGen. Write HTML, render video. Compositions, GSAP and runtime adapter animations, captions, voiceovers, audio-reactive visuals, and website-to-video capture for HyperFrames.
Claude Plugins (Official)by heygen-com
- Design & Creative45k
discord
Discord messaging bridge with built-in access control. Manage pairing, allowlists, and policy via /discord:access.
Claude Plugins (Official)by anthropics
- Design & Creative45k
frontend design
Create distinctive, production-grade frontend interfaces with high design quality. Generates creative, polished code that avoids generic AI aesthetics.
Claude Plugins (Official)by anthropics
- Design & Creative45k
imessage
iMessage messaging bridge with built-in access control. Reads chat.db directly, sends via AppleScript. Manage pairing, allowlists, and policy via /imessage:access.
Claude Plugins (Official)by anthropics
Catalog data refreshed . Something wrong? Report it.