postgres-schema-audit
OfficialIdentify and fix Postgres schema design debt.
Authoranthril
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Audit a Postgres schema to surface structural and relational design quality issues, enabling faster remediation and safer migrations.
Core Features & Use Cases
- Produces a comprehensive Markdown report (database-design-audit.md) with an executive summary, per-schema findings, cross-schema analysis, and a risk register.
- Outputs a JSON sidecar (database-design-audit.json) for machine consumption and a draft migrations-suggested.sql for remediation planning.
- Performs cross-schema analysis to reveal cross-schema FKs, shared enums, and consolidation opportunities.
- Supports both Supabase MCP-based access and direct read-only Postgres connections via a safe, read-only workflow.
- Provides evidence-backed findings sourced from catalog queries for verification and traceability.
- Useful for database design reviews, pre-migration cleanup, and governance.
Quick Start
Run the audit across the selected schemas to generate the report and sidecar JSON for remediation planning.
Dependency Matrix
Required Modules
psql
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgres-schema-audit Download link: https://github.com/anthril/official-claude-plugins/archive/main.zip#postgres-schema-audit Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.