← ClaudeAtlas

postgres-schema-reviewlisted

Audit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets · ★ 1 · API & Backend · score 70
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,