AGENT SKILL

pm-postgres

PostgreSQL connector knowledge and safe action guide.

License 许可
AGPL-3.0
所属仓库
polymetrics-ai/cli
最近更新
2026-09-21
Stars
★ 7
Forks
0

01 前言 Front Matter

name
pm-postgres
description
PostgreSQL connector knowledge and safe action guide.

03 SKILL.md 正文

pm-postgres

Purpose

Reads PostgreSQL tables, supports PostgreSQL 14+ logical-replication CDC into the local warehouse, and delivers managed PostgreSQL targets through the warehouse-mediated transport. Direct Connector.Write remains unavailable; query is not implemented.

Icon

Capabilities

  • check=true catalog=true read=true write=false query=false
  • Integration type: database

Authentication

  • password: Live connections require password authentication; peer/socket and client-certificate modes, including ambient certificates, are unsupported.
    • config: host, database, username
    • secrets: password
    • supports: read=true write=false

Configuration

  • cdc_publication
  • cursor_field
  • database (required)
  • host (required)
  • mode
  • port
  • read_limit
  • schema
  • sslmode
  • sslrootcert
  • sslservername
  • username (required)
  • password (secret) (required when mode is not fixture): Fixture mode does not open a source connection.

Security

  • read risk: low
  • write risk: not a generic write capability; the closed managed target transport follows its existing plan, preview, approval, execute boundary
  • approval: source reads require none; managed target transport follows its plan, preview, approval, execute boundary
  • Never pass secret values in chat, shell arguments, logs, docs, or JSON output.

Sync Transport

  • Source transport: declared
  • Destination transport: declared
  • A declared transport still requires runtime preflight and externally verified conformance; it is not a certification claim.
  • Source executor: native_database/postgres_polling_watermark
  • Destination executor: native_database/postgres_managed_target

Polling Watermark

  • Static declaration status: planned
  • Mechanism: polling_watermark is a bounded polling scan, not CDC or change capture.
  • Runtime eligibility: this connector constructs an implemented declaration per selected catalog object. Every requested mode still requires runtime preflight for its destination binding, registered native executors, and immutable conformance evidence.
  • Reason: PostgreSQL binds its cursor type, per-stream cursor column, and unique tie-breaker from the live catalog at run time. The static bundle cannot truthfully name those dynamic fields; the live sync transport constructs and preflights the implemented polling declaration.

Commands

Inspect as a manual

pm connectors inspect postgres

Inspect as structured JSON

pm connectors inspect postgres --json

Agent Rules

  • Run pm connectors inspect postgres before creating credentials or plans.
  • Use --json only when the caller needs structured output; use the manual for human-readable guidance.
  • Never ask the user to paste secret values into chat.

04 同仓库更多 Skills