postgresql-replication-review

name	postgresql-replication-review
description	Reviews PostgreSQL replication posture, lag, sender/receiver state, and failover risk. Use when: replication health is questioned, lag needs interpretation, a primary/replica topology should be reviewed, or the user wants a concise replication status summary before operational action.
license	MIT
compatibility	opencode
metadata	{"owner":"postgresql-admin","type":"read-only","approval":"No"}

postgresql-replication-review

Owner: postgresql-admin Type: read-only Approval: No

What I Do

Builds a concise PostgreSQL replication health view from live replication evidence.

When to Use Me

• replication lag review
• primary/replica posture review
• failover readiness discussion

Context Requirements

Requires already loaded:
  .crux/workspace/postgresql-admin/MEMORY.md

Loads during execution (lazy):
  .crux/docs/postgresql-operations-principles.md
  (generate from agent assets first if missing)

Inputs

Input	Source	Required
target-host	user / MEMORY.md	Yes
target-port	user / MEMORY.md	No

Steps

1. Confirm connection and role
2. Inspect replication views and lag indicators
3. Identify healthy / warning / critical posture
4. Summarise operational risk and next action
5. Skill complete — unload

Output

Inline markdown summary.

Error Handling

Condition	Action
Replication view unavailable	report topology evidence gap
Lag signal unclear	state uncertainty explicitly
Unexpected failure	Stop. Write error to bus. Notify user.