Is it safe to use on production databases?

This skill is designed primarily for test environments to validate assumptions and migration plans. Always use caution and follow security best practices before connecting to production systems.

Does this skill support different PostgreSQL versions?

Yes, it includes specific workflows for cross-version testing and validation for PostgreSQL versions 14 through 17.

How does the skill handle database credentials?

The skill reads connection details such as PGHOST, PGUSER, and PGPASSWORD from a .env file located at the project root.

Can I use this skill with databases other than PostgreSQL?

No, this specific skill is optimized for PostgreSQL-specific tools and system catalogs like pg_dump and pgschema.

PostgreSQL Schema Validator

Name: PostgreSQL Schema Validator
Author: Activer007

byActiver007

데이터베이스 관리

Validates PostgreSQL database schemas by comparing live database states, pg_dump outputs, and system catalog queries.

소개

This skill provides a comprehensive suite of tools for PostgreSQL database introspection and validation. It allows developers to interactively query system catalogs, compare DDL outputs between pg_dump and pgschema, and verify migration plans against live test databases. By automating schema verification and DDL formatting checks, it ensures consistency across database tools and helps identify bugs in schema introspection logic or version-specific behavior across PostgreSQL 14-17.

주요 기능

Cross-version validation for PostgreSQL 14 through 17
Live PostgreSQL connection for real-time schema validation
Direct comparison between pg_dump and pgschema outputs
Automated database setup and cleanup for testing workflows
0 GitHub stars
Interactive system catalog querying for deep introspection

사용 사례

Comparing custom schema export tools against standard pg_dump output
Debugging complex schema introspection issues within system catalogs
Validating DDL migration plans on a temporary test database before production

소개

주요 기능

Cross-version validation for PostgreSQL 14 through 17
Live PostgreSQL connection for real-time schema validation
Direct comparison between pg_dump and pgschema outputs
Automated database setup and cleanup for testing workflows
0 GitHub stars
Interactive system catalog querying for deep introspection

사용 사례

Comparing custom schema export tools against standard pg_dump output
Debugging complex schema introspection issues within system catalogs
Validating DDL migration plans on a temporary test database before production