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

0•

Database Management

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

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.

Key Features

01Live PostgreSQL connectivity for schema introspection and validation

02Migration verification through specialized Plan/Apply workflows

030 GitHub stars

04Automated side-by-side comparison between pg_dump and custom schema outputs

05Direct system catalog querying for triggers, constraints, and indexes

06Cross-version compatibility testing for PostgreSQL 14-17

Use Cases

01Verifying DDL generation for complex database objects like triggers and views

02Debugging discrepancies between live database schemas and code definitions

03Validating database migration scripts in a test environment before deployment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills validate-with-database

For use in Claude.ai and ChatGPT

Download Skill