Does this skill support the latest versions of PostgreSQL?

Yes, it specifically provides guidance for PostgreSQL versions 14 through 17, including version-specific feature detection logic.

Why should I use pg_dump as a reference instead of standard documentation?

While documentation is helpful, pg_dump is the official tool used to dump databases; its source code contains the 'ground truth' for how PostgreSQL internals should be queried, especially for complex objects.

Is this skill specific to any programming language?

While it includes examples for Go, the SQL logic and system catalog patterns are universal and can be applied to any language including Python, Node.js, or Java.

Can this skill help with DDL formatting?

Yes, it references how pg_dump handles quoting rules and uses internal functions to generate correct DDL for constraints, indexes, and triggers.

pg_dump Reference

Name: pg_dump Reference
Author: Activer007

byActiver007

0•

データベース管理

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

The pg_dump Reference skill serves as a technical bridge between the official PostgreSQL source code and your development workflow. It provides precise instructions for querying internal system catalogs, handling complex database objects like triggers and constraints, and managing version-specific features across PostgreSQL 14-17. By treating pg_dump as the 'source of truth,' this skill ensures that database introspection and DDL generation logic remain robust, accurate, and aligned with PostgreSQL's internal representation of objects.

主な機能

01Maps database objects to specific pg_dump source functions and files

02Explains the usage of internal helper functions like pg_get_expr and pg_get_constraintdef

03Details object dependency tracking and relationship logic based on pg_depend

04Offers guidance on handling version-specific PostgreSQL syntax and features

05Provides verified SQL patterns for querying pg_catalog tables

060 GitHub stars

ユースケース

01Building or debugging database introspection tools and ORMs

02Learning how PostgreSQL represents complex objects like partial indexes and row-level security policies internally

03Implementing custom schema migration engines that require exact metadata

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