How do I find the file after the dump is finished?

The skill automatically copies the absolute file path to your clipboard, allowing you to immediately paste it into other commands or editors.

What does this skill actually export?

It exports a schema-only SQL file, which includes table structures, constraints, and types but excludes the actual data rows stored in the database.

Do I need PostgreSQL installed locally?

Yes, this skill requires pg_dump to be available in your system's path and an accessible PostgreSQL database instance.

Can I specify a custom database URL?

Yes, while it has a default local URL, you can specify any valid PostgreSQL connection string when prompted by Claude.

Is the output file cleaned or modified?

Yes, the skill uses sed to remove ownership, privileges, comments, and specific pg_catalog calls to provide a clean, readable SQL file.

PostgreSQL Schema Dumper

Name: PostgreSQL Schema Dumper
Author: macro-inc

bymacro-inc

•

Database Management

Exports a clean, stripped-down PostgreSQL database schema to a local file and copies the file path to the clipboard.

The dump-schema skill automates the process of generating a readable and concise SQL schema from a local PostgreSQL database. It specifically filters out metadata such as ownership, privileges, and comments to provide a 'clean' view of the database structure, which is ideal for documentation, version control, or providing context to Claude. By automatically copying the output path to the system clipboard, it streamlines the workflow for developers who need to quickly reference, share, or analyze their database architecture.

Key Features

01Optimized for local development environments and quick database inspection

02Automatically copies the resulting file path to the system clipboard

03Supports custom absolute output file paths

0442 GitHub stars

05Generates schema-only SQL dumps without including table data

06Removes noise like ownership, privileges, and comments for maximum readability

Use Cases

01Generating clean schema files for documentation or repository commits

02Quickly sharing table structures with team members without metadata clutter

03Providing database structure context to Claude for writing better SQL queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add macro-inc/macro dump-schema

For use in Claude.ai and ChatGPT

Download Skill