Subchapter 11.2
README.mdMarkdown1 KBView on GitHub
A workflow skill covering Postgres via clickhousectl, in the normalized infra-skill format (shared with infra-clickhouse):
SKILL.md # decision tree: local vs cloud, shared prerequisites
ref/local.md # local Docker-backed Postgres (clickhousectl local postgres ...)
ref/cloud.md # ClickHouse Cloud Postgres, beta (clickhousectl cloud postgres ...)SKILL.md stays thin — it routes to the right ref. ref/local.md ends with a “going to production” pointer to ref/cloud.md.
The content mirrors the clickhousectl CLI surface. When the CLI changes, re-verify against the built-in help:
clickhousectl local postgres --help
clickhousectl cloud postgres --helpand each subcommand’s --help (the CONTEXT FOR AGENTS sections in the help output are the source of truth for behavior like port auto-assignment, password generation, and data directory layout).
Command output examples were captured from real runs — if flags or JSON shapes change, update the examples rather than deleting them.
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.