Why use pg_dump logic instead of information_schema?

While information_schema is a standard, it often lacks the depth required for advanced objects like triggers, partitioned tables, or specific constraint definitions that are only fully accessible via pg_catalog tables.

What is the pg_dump Reference skill?

It is a specialized capability for Claude Code that provides technical guidance on how to query PostgreSQL's internal system catalogs correctly by referencing the official pg_dump source code implementation.

Can this skill help with DDL generation?

Yes, it provides patterns for using built-in PostgreSQL formatting functions like pg_get_indexdef and pg_get_triggerdef to ensure generated SQL matches canonical formats.

Which PostgreSQL versions are supported?

This skill specifically focuses on modern PostgreSQL implementations, covering versions 14, 15, 16, and 17.

PostgreSQL pg_dump Reference Guide

Name: PostgreSQL pg_dump Reference Guide
Author: Activer007

byActiver007

Database Management

Consults PostgreSQL's pg_dump source code to provide authoritative guidance on system catalog queries and schema extraction patterns.

About

This skill provides specialized knowledge derived from the canonical PostgreSQL pg_dump implementation to assist in building database introspection tools and schema management features. It enables Claude to accurately navigate complex system catalogs like pg_attribute and pg_class, handle version-specific features for PostgreSQL 14 through 17, and implement correct DDL formatting. By referencing the source of truth for PostgreSQL schema dumping, it ensures that generated queries for triggers, constraints, indexes, and other objects are reliable and follow internal best practices.

Key Features

0 GitHub stars
Mapping of schema objects to specific pg_dump source functions
Object dependency tracking and sorting logic guidance
Detailed system catalog query patterns for complex metadata extraction
Best practices for using PostgreSQL helper functions like pg_get_expr
Version-specific feature detection for PostgreSQL 14-17

Use Cases

Developing database introspection logic for Go or other backend languages
Debugging inconsistent metadata results from standard information_schema queries
Implementing declarative schema management and diffing tools

About

Key Features

0 GitHub stars
Mapping of schema objects to specific pg_dump source functions
Object dependency tracking and sorting logic guidance
Detailed system catalog query patterns for complex metadata extraction
Best practices for using PostgreSQL helper functions like pg_get_expr
Version-specific feature detection for PostgreSQL 14-17

Use Cases

Developing database introspection logic for Go or other backend languages
Debugging inconsistent metadata results from standard information_schema queries
Implementing declarative schema management and diffing tools