Which PostgreSQL versions are supported?

This skill is optimized for PostgreSQL versions 14, 15, 16, and 17.

How does it handle database credentials?

The skill retrieves connection details from a .env file at the project root, including PGHOST, PGDATABASE, PGUSER, and PGPASSWORD.

Does it support complex SQL objects?

Yes, it includes specialized queries for inspecting triggers, indexes, materialized views, and specific DDL formatting like primary key ordering.

Can I use this to compare different schema dump tools?

Yes, it features a specific workflow to compare pg_dump output with pgschema or other custom implementations to identify bugs or formatting differences.

PostgreSQL Schema Validator

Name: PostgreSQL Schema Validator
Author: Activer007

byActiver007

Gestión de Bases de Datos

Connects to live PostgreSQL databases to validate schema assumptions, perform system catalog queries, and cross-validate DDL outputs.

Acerca de

This skill empowers Claude to interact directly with live PostgreSQL environments to ensure database schema integrity and accuracy. It provides specialized workflows for comparing pg_dump results with project-specific schema tools, debugging complex introspection issues via system catalogs, and verifying version-specific behaviors across PostgreSQL 14 through 17. By bridging the gap between static code and live data, it enables reliable database migration planning, real-time schema validation, and detailed DDL formatting analysis.

Características Principales

Live PostgreSQL connectivity for schema introspection and validation
Migration verification through specialized Plan/Apply workflows
0 GitHub stars
Automated side-by-side comparison between pg_dump and custom schema outputs
Direct system catalog querying for triggers, constraints, and indexes
Cross-version compatibility testing for PostgreSQL 14-17

Casos de Uso

Verifying DDL generation for complex database objects like triggers and views
Debugging discrepancies between live database schemas and code definitions
Validating database migration scripts in a test environment before deployment

Acerca de

Características Principales

Live PostgreSQL connectivity for schema introspection and validation
Migration verification through specialized Plan/Apply workflows
0 GitHub stars
Automated side-by-side comparison between pg_dump and custom schema outputs
Direct system catalog querying for triggers, constraints, and indexes
Cross-version compatibility testing for PostgreSQL 14-17

Casos de Uso

Verifying DDL generation for complex database objects like triggers and views
Debugging discrepancies between live database schemas and code definitions
Validating database migration scripts in a test environment before deployment