Setting the chapter. One moment.
11 chapters · 36 min
Skills
Chapter 11 of 11
Sets up and manages Postgres using the clickhousectl CLI — runs a local Docker-backed Postgres for development, and creates and operates managed ClickHouse Cloud Postgres services…
1 minute · 230 words · 4 sections
clickhousectl manages Postgres in two environments:
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.
| The user wants to… | Read |
|---|---|
| Develop or prototype locally, run tests/CI against Postgres, no cloud account needed | ref/local.md (opens in a new tab) |
| Go to production, host a managed Postgres, or use ClickHouse Cloud explicitly | ref/cloud.md (opens in a new tab) |
| Operate an existing cloud service (passwords, TLS, config, replicas, failover, restore) | ref/cloud.md (opens in a new tab) |
| Develop locally now, ship to production later | Start with ref/local.md; it points to when it’s time to go to prod |
If it’s genuinely ambiguous (e.g. “set up Postgres for my app”), default to local for development tasks and ask before creating anything in the cloud — cloud services cost money.
Check that clickhousectl is installed:
which clickhousectlIf not found, install it:
curl -fsSL https://clickhouse.com/cli | shThis 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.
clickhousectl cloud clickpipe --help).infra-clickhouse skill.Install this repository
npx skills add ClickHouse/agent-skills/plugin marketplace add ClickHouse/agent-skillsSkills install per repository, not per chapter — the CLI has no documented per-skill form, so we do not print one.
Sets up and manages Postgres using the clickhousectl CLI — runs a local Docker-backed Postgres for development, and creates and operates managed ClickHouse Cloud Postgres services (connections, TLS, runtime config, read replicas, failover, point-in-time restore). Use when the user wants a Postgres or PostgreSQL database for their application, a local Postgres dev environment, psql access, or a managed/production Postgres in ClickHouse Cloud, or mentions moving a local Postgres to production.
The verbatim description from this skill’s front matter — the string an agent matches on to decide whether to load it.
skills/infra-postgres/SKILL.mdmain, last pushed 6 August 2026.SKILL.md, not by matching a directory convention. One layout observed: skills/*/SKILL.md.h1 and no skipped levels:.claude-plugin/marketplace.json by ClickHouse, declaring 8 plugins. It is read for editorial metadata only — never as the skill index, which is always the repository tree./ClickHouse/agent-skills.md.md4 files · 10 KB
Everything this skill ships beside its prose. All of it is set here, as subchapters of chapter 11.
Everything else published alongside the skill.