postgresql-recovery-readiness-review

name	postgresql-recovery-readiness-review
description	Evaluates whether PostgreSQL backup posture is actually recoverable in practice. Use when: the user asks if recovery is realistic, RPO/RTO readiness needs review, restore evidence is unclear, or backup status alone is not enough for confidence.
license	MIT
compatibility	opencode
metadata	{"owner":"postgresql-admin","type":"read-only","approval":"No"}

postgresql-recovery-readiness-review

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

What I Do

Turns backup and restore evidence into a practical PostgreSQL recovery-readiness judgment.

When to Use Me

• restore preparedness review
• RPO/RTO discussion
• backup exists but recovery confidence is unclear

Context Requirements

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

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

Inputs

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

Steps

1. Review available backup and WAL evidence
2. Review restore path and test evidence if any
3. Assess recovery confidence against known expectations
4. Return practical readiness summary and gaps
5. Skill complete — unload

Output

Inline markdown summary.

Error Handling

Condition	Action
Restore evidence absent	mark readiness as unproven
Inputs are partial	state confidence accordingly
Unexpected failure	Stop. Write error to bus. Notify user.