‹ 首页

infra-clickhouse

@clickhouse · 收录于 昨天 · 上游提交 2 天前

Sets up and manages ClickHouse using the clickhousectl CLI — installs and runs a local ClickHouse server for development, and creates managed ClickHouse Cloud services for production (authentication, service creation, schema migration, application connection). Use when the user wants to build an application with ClickHouse, set up a local ClickHouse dev environment, create tables and start querying, deploy ClickHouse to production or ClickHouse Cloud, or migrate from a local setup to the cloud.

场景开发环境搭建生产部署数据迁移

适合你，如果需要管理ClickHouse数据库或迁移到云端。

/ 下载安装
https://github.com/clickhouse/agent-skills/tree/main/skills/infra-clickhouse ↗
/ 通过 npx 安装 校验哈希
npx oh-my-skill add clickhouse/agent-skills/infra-clickhouse
/ 通过 bash 安装
curl -fsSL https://oh-my-skill.com/install.sh | bash -s -- clickhouse/agent-skills/infra-clickhouse
/ 已经装过?验证本机副本,不用重装
npx oh-my-skill verify clickhouse/agent-skills/infra-clickhouse
安装目标可用 --agent / --scope 或 --to 明确指定;省略时只会在唯一已存在的 agent 目录上自动选择,零命中或多命中会停止并提示。content_hash 缺失或不一致均拒装。
498GitHub stars
~589最小装载
~2.6K含声明引用
~3K文本包总量
索引托管

怎么用

商店整理自技能原文 · 版本 6e5458d · 表述以原文为准
它做什么

该技能使Claude能通过clickhousectl命令行工具管理ClickHouse。它可以在用户电脑上安装并运行本地ClickHouse开发服务器，也可以创建ClickHouse Cloud托管服务用于生产环境，包括认证、服务创建、模式迁移和应用连接。

什么时候触发

当用户提到需要用到ClickHouse构建应用、设置本地开发环境、或部署到生产环境（含云端）时，Claude会触发此技能。

装好后可以这样说
Claude会启动本地ClickHouse并执行建表操作。
Claude会指导迁移流程。
Claude会引导你完成认证和服务创建。
技能原文 SKILL.md作者撰写 · Apache-2.0 · 6e5458d

ClickHouse with clickhousectl

clickhousectl manages ClickHouse in two environments:

  • Local — ClickHouse installed and running on the user's machine, for development.
  • Cloud — managed ClickHouse Cloud services, for production: fully managed, automatic scaling, backups, and upgrades.

This file routes to the right reference. The step-by-step workflows live in ref/local.md and ref/cloud.md — read the one that matches the user's situation before running commands.

Which reference to use

| The user wants to... | Read | |----------------------|------| | Build an app with ClickHouse, develop or prototype locally, no cloud account needed | [ref/local.md](ref/local.md) | | Go to production, host a managed ClickHouse, or use ClickHouse Cloud explicitly | [ref/cloud.md](ref/cloud.md) | | Operate an existing cloud service (schemas, users, queries against it) | [ref/cloud.md](ref/cloud.md) | | Develop locally now, ship to production later | Start with [ref/local.md](ref/local.md); it points to [ref/cloud.md](ref/cloud.md) when it's time to go to prod |

If it's genuinely ambiguous (e.g. "set up ClickHouse for my app"), default to local for development tasks and ask before creating anything in the cloud — cloud services cost money.

Prerequisites (both workflows)

Check that clickhousectl is installed:

which clickhousectl

If not found, install it:

curl -fsSL https://clickhouse.com/cli | sh

This installs to ~/.local/bin/clickhousectl (with a chctl alias). If the command is still not found, suggest export PATH="$HOME/.local/bin:$PATH" or a new terminal.

All commands accept --json for machine-readable output. Exit codes follow gh conventions: 0 success, 1 error, 2 cancelled, 4 auth required.

Related
  • When designing schemas, consult the clickhouse-best-practices skill for ORDER BY selection, data types, and partitioning.
  • For Postgres (local development or managed ClickHouse Cloud Postgres), use the infra-postgres skill.
按 Apache-2.0 许可原样转载,未经改动 · 在 GitHub 查看 →

评论

登录即可评论;带「已验证安装」的,是发布者名下有本店的安装或持有记录。
…