validate-with-database

Name: validate-with-database
Rating: 5 (485 reviews)
Author: pgschema

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively

TL;DR

Connect to live PostgreSQL to validate schema assumptions and compare pg_dump vs pgschema outputs.

What Is It

Validate schema behavior in live database
Compare pg_dump and pgschema schema outputs
Query system catalogs interactively
Test schema changes against real database

Key Features

Supports interactive psql queries
Enables schema comparison via pg_dump and pgschema
Allows system catalog inspection
Validates migration plans before implementation
Supports version-specific behavior checks (14-18)
Provides direct access to real database objects

How to Use

1.Connect using psql with provided credentials
2.Run pg_dump and pgschema to compare schema outputs
3.Query system catalogs for trigger/definition details
4.Validate migration plans with real database state

Guardrails & Gotchas

FORBIDDEN: Never modify production data without approval
MUST: Always verify schema differences before applying changes
MUST: Clean up test objects after validation
CRITICAL: Use only test databases for schema testing

GitHub Stats

Author

@pgschema

Repository

pgschema/pgschema

Stars

485

Explore More Skills

move-code-quality

@davila7

Analyzes Move language packages against the official Move Book Code Quality Checklist. Use this skill when reviewing Move code, checking Move 2024 Edition compliance, or analyzing Move packages for best practices. Activates automatically when working with .move files or Move.toml manifests.

12.4k

1.1k

1w ago

validate-with-database

Explore More Skills

move-code-quality

e2e-testing-patterns

testing-anti-patterns