skilld
All skills
clickhouse avatar

/infra-clickhouse

@6e5458d official
by clickhouseclickhouse/agent-skills543 stars
39

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.

Ask your Agent

Use this Skill: https://skilld.dev/gh/clickhouse/agent-skills/infra-clickhouse

This session only. Nothing lands on disk.

README.md

≈291 tokens on demand. Your agent reads this file only when SKILL.md points to it.

infra-clickhouse — maintainer guide

A workflow skill covering ClickHouse via clickhousectl, in the normalized infra-skill format (shared with infra-postgres):

SKILL.md        # decision tree: local vs cloud, shared prerequisites
ref/local.md    # local ClickHouse development (clickhousectl local ...)
ref/cloud.md    # ClickHouse Cloud deployment (clickhousectl cloud ...)

SKILL.md stays thin — it routes to the right ref. ref/local.md ends with a "going to production" pointer to ref/cloud.md.

This skill merges and supersedes the former clickhousectl-local-dev and clickhousectl-cloud-deploy skills.

Maintenance

The content mirrors the clickhousectl CLI surface. When the CLI changes, re-verify against the built-in help:

clickhousectl local --help
clickhousectl cloud --help

and each subcommand's --help (the CONTEXT FOR AGENTS sections in the help output are the source of truth).

Bump version in both the SKILL.md frontmatter and metadata.json when editing, and keep the SKILL.md frontmatter description emphasizing both the local and cloud cases — it is what triggers skill activation.

Source: SKILL.md on GitHub

Third-party checks

1 warning2mo3 checks · Risk SAFE
  • Gen Agent Trust Hub2mo

    This skill provides standard workflows for managing ClickHouse databases using the clickhousectl CLI. It includes instructions for installing the CLI, setting up local development environments, and deploying to ClickHouse Cloud. The skill correctly follows security best practices by advising users to gitignore sensitive environment files, suggesting the creation of dedicated application users with limited permissions, and instructing users to handle authentication tokens in separate terminal sessions to avoid chat history exposure. The remote installation command is sourced from the vendor's official domain.

  • Socket2mo

    No alerts

  • Snyk2mo

    Risk: MEDIUM · 1 issue

Provenance

Signed by skilld at 6e5458d. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 3 days ago.

Activeupdated 2 months ago

Capability

metadata
{
  "author": "ClickHouse Inc",
  "version": "0.3.0"
}

README badge

README badge for clickhouse/agent-skills/infra-clickhouse