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

0•

データベース管理

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

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.

主な機能

010 GitHub stars

02Mapping of schema objects to specific pg_dump source functions

03Object dependency tracking and sorting logic guidance

04Detailed system catalog query patterns for complex metadata extraction

05Best practices for using PostgreSQL helper functions like pg_get_expr

06Version-specific feature detection for PostgreSQL 14-17

ユースケース

01Developing database introspection logic for Go or other backend languages

02Debugging inconsistent metadata results from standard information_schema queries

03Implementing declarative schema management and diffing tools

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills pg-dump-reference

For use in Claude.ai and ChatGPT

Download Skill