Can I use this to test database migrations?

Yes, it includes a dedicated 'Test Plan/Apply' workflow designed to validate migration DDL before it is executed on production systems.

How does the skill connect to my database?

It uses connection details stored in a .env file at your project root, defaulting to localhost:5432 with configurable user and database parameters.

Can I query system catalogs directly?

Absolutely. The skill includes pre-configured SQL templates for inspecting tables, constraints, indexes, triggers, and comments directly from the PostgreSQL system catalogs.

What PostgreSQL versions does this skill support?

The skill is specifically optimized and documented for testing and validation across PostgreSQL versions 14, 15, 16, and 17.

Does it support comparing different schema dump tools?

Yes, it provides specific workflows to compare the output of standard pg_dump against the project-specific pgschema tool to identify discrepancies.

Validate with Database

Name: Validate with Database
Author: Activer007

byActiver007

データベース管理

Validates PostgreSQL schema assumptions and cross-references DDL outputs using live database connections.

概要

This skill empowers developers to bridge the gap between schema definitions and actual PostgreSQL behavior by providing a suite of tools for live database interaction. It enables real-time validation of system catalog queries, side-by-side comparison of pg_dump and pgschema outputs, and rigorous testing of migration plans. By connecting directly to a PostgreSQL instance (supporting versions 14-17), users can debug introspection issues, verify DDL formatting, and ensure cross-version compatibility within their database-driven applications.

主な機能

Live PostgreSQL connection management via .env configuration
Cross-version testing support for PostgreSQL 14 through 17
0 GitHub stars
Deep introspection of system catalogs for triggers, indexes, and constraints
Automated comparison between pg_dump and pgschema outputs
Migration plan validation through test-apply-verify workflows

ユースケース

Verifying database migration plans in a safe test environment before deployment
Debugging complex PostgreSQL schema introspection and DDL generation issues
Comparing custom schema extraction tools against official PostgreSQL pg_dump results

概要

主な機能

Live PostgreSQL connection management via .env configuration
Cross-version testing support for PostgreSQL 14 through 17
0 GitHub stars
Deep introspection of system catalogs for triggers, indexes, and constraints
Automated comparison between pg_dump and pgschema outputs
Migration plan validation through test-apply-verify workflows

ユースケース

Verifying database migration plans in a safe test environment before deployment
Debugging complex PostgreSQL schema introspection and DDL generation issues
Comparing custom schema extraction tools against official PostgreSQL pg_dump results