Validate with Database
OfficialValidate schemas in live PostgreSQL confidently.
Authorpgschema
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Connect to a live PostgreSQL database to validate schema assumptions, compare pg_dump and pgschema outputs, and inspect system catalogs interactively.
Core Features & Use Cases
- Cross-validate database schemas by comparing actual database state with schema files and dumps.
- Inspect system catalogs and metadata to verify object definitions, constraints, and indexes.
- Validate migration plans and reproduce plan results across PostgreSQL versions 14-18.
- Debug schema introspection issues by querying catalog data and comparing with expected results.
Quick Start
Run a quick validation workflow by dumping the target schema with pg_dump and comparing the results with pgschema output, then query system catalogs to verify definitions.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: Validate with Database Download link: https://github.com/pgschema/pgschema/archive/main.zip#validate-with-database 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.