clickhouse/agent-skills 是从 https://github.com/clickhouse/agent-skills. 导入的 Agent Skill 候选人。
概览
clickhouse/agent-skills 是从 https://github.com/clickhouse/agent-skills. 导入的 Agent Skill 候选人。
概述（AI 翻译）
ClickHouse 的官方代理技能。这些技能帮助大型语言模型和代理在使用 ClickHouse 和 chdb（Python版 ClickHouse 进行中）时采用最佳实践。
你可以在开源的ClickHouse和托管的ClickHouse Cloud上运用这些技能。试试ClickHouse Cloud，免费获得300美元积分。
安装
NPX
CLI会自动检测已安装的代理，并提示你选择安装位置。
咔嗒，houseCTL
使用 ClickHouse CLI clickhousectl 安装代理技能：
这是什么？
代理技能是一套套装的指令，旨在扩展 AI 编码代理（Claude Code、Cursor、Copilot 等）的领域专长。该仓库提供 ClickHouse 数据库和 chdb 的技能——涵盖模式设计、查询优化、数据摄取模式以及使用 Python 进行的中级分析。
当代理加载这些技能时，它会获得 ClickHouse 最佳实践和 chdb API 的知识，并能在帮助你设计表格、编写查询、分析数据或排查性能问题时应用它们。
技能遵循 agentskills.io 的开放规范。
可用技能
ClickHouse 最佳实践
本页由 AI 翻译，技术细节请以原文为准。
README
以下为原文 README 节选，完整内容请查看原文。
ClickHouse 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-skills
The 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 skills
What 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.
Available Skills
ClickHouse Best Practices
28 rules covering schema design, query optimization, and data ingestion—prioritized by impact.
| Category | Rules | Impact |
|---|---|---|
| Primary Key Selection | 4 | CRITICAL |
| Data Type Selection | 5 | CRITICAL |
| JOIN Optimization | 5 | CRITICAL |
| Insert Batching | 1 | CRITICAL |
| Mutation Avoidance | 2 | CRITICAL |
| Partitioning Strategy | 4 | HIGH |
| Skipping Indices | 1 | HIGH |
| Materialized Views | 2 | HIGH |
| Async Inserts | 2 | HIGH |
| OPTIMIZE Avoidance | 1 | HIGH |
| JSON Usage | 1 | MEDIUM |
Location: skills/clickhouse-best-practices/
For humans: Read SKILL.md for an overview, or AGENTS.md for the complete compiled guide.
For agents: The skill activates automatically when you work with ClickHouse—creating tables, writing queries, or designing data pipelines.
ClickHouse Architecture Advisor
5 decision frameworks covering workload-aware architecture decisions for real-time ClickHouse deployments.
| Decision Area | Impact |
|---|---|
| Ingestion Strategy | CRITICAL |
| Join & Enrichment Patterns | CRITICAL |
| Late-Arriving Data & Upserts | CRITICAL |
| Time-Series Partitioning | HIGH |
| Real-Time Pre-Aggregation | HIGH |
推荐工具
换一个关键词，或者移除筛选条件。
安装
npx skillfish add clickhouse/agent-skills