skilld
All skills
clickhouse avatar

/infra-postgres

@356a8c1 official
by clickhouseclickhouse/agent-skills543 stars
39

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. Also use when migrating an existing Postgres database (Neon, Supabase, RDS, Aurora, Cloud SQL, self-hosted) into ClickHouse Cloud Postgres.

Ask your Agent

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

This session only. Nothing lands on disk.

README.md

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

infra-postgres — maintainer guide

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 ...)
ref/migrate.md  # migrate an existing Postgres into ClickHouse Cloud Postgres (pg_dump/pg_restore)

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

Maintenance

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 --help

and 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.

Source: SKILL.md on GitHub

Third-party checks

1 alert2d3 checks · Risk HIGH
  • Gen Agent Trust Hub2d

    The skill facilitates Postgres management using the ClickHouse CLI (clickhousectl). It includes a standard vendor installation script from clickhouse.com and follows security best practices by advising users to keep API secrets out of the chat context. It identifies as having an indirect prompt injection surface because it reads and acts upon data produced by command-line tools, though it uses structured JSON data to minimize risk.

  • Socket2d

    No alerts

  • Snyk2d

    Risk: LOW · No issues

Provenance

Signed by skilld at 356a8c1. 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 3 days ago

Capability

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

README badge

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