postgres-schema-reviewlisted
Install: claude install-skill genaptic/skillsets
# Outcome
Produce a concrete, reviewable result for the workflow below without overstating what was
observed, executed, or verified.
## Compatibility
Portable across Claude Code, Codex, and OpenCode. Catalog guidance targets PostgreSQL 18;
adapt it to the deployed version and provider permissions. The optional renderer requires
Python 3.11, emits SQL only, never connects to a database, and refuses to overwrite output.
## Use this skill when
- An existing database, schema dump, migration history, or catalog snapshot needs a structured audit.
- Ownership, grants, default privileges, `search_path`, role attributes, or RLS behavior may violate a trust boundary.
- Constraints, indexes, partitions, generated values, or dependencies may have drifted from intended DDL.
- Review findings need severity, confidence, evidence, minimal remediation, and rollout implications.
## Do not use this skill when
- The task is to create the target domain model from first principles; use `postgres-schema-design`.
- The task is to diagnose a particular statement from EXPLAIN evidence; use `postgres-query-performance-review`.
- The design decision is complete and only low-risk rollout remains; use `postgres-migration-safety`.
- The task is backup topology or recovery assurance; use `postgres-backup-recovery`.
## Inputs
Inspect or obtain:
- Environment, PostgreSQL major version/provider, database identity, collection time, and review authorization.
- Intended domain invariants, tenant model,