pgd

Encode PostgreSQL schemas into the PGD XML format with CLI guidance.

6|Updated Apr 5, 2026
One-click install
npx skills add https://github.com/vmkteam/claude-plugins --skill pgd
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pgd
Source: https://github.com/vmkteam/claude-plugins/tree/main/plugins/developer/skills/pgd
Command: npx skills add https://github.com/vmkteam/claude-plugins --skill pgd

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PGD provides a canonical reference for the pgDesigner PGD format and its CLI, helping teams encode PostgreSQL schemas in a portable, machine-readable way.

Core Features & Use Cases

  • Documentation and canonical structure for PGD: project, database, schemas, types, and mappings from SQL to PGD.
  • CLI usage guidance for pgdesigner commands like generate, diff, lint, and testdata.
  • Use Case: Teams migrating PostgreSQL schemas can convert SQL to PGD, share designs, and generate deterministic SQL diffs.

Quick Start

Run pgdesigner generate schema.pgd to produce SQL from a PGD file.

Frequently Asked Questions about pgd

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert PostgreSQL schemas to PGD XML format?

To convert PostgreSQL schemas to PGD XML format, encode project, database, schema, and type mappings using the canonical PGD structure. This creates a portable, machine-readable representation of your database design for sharing and migration planning.

What is the PGD format used for in database migration planning?

The PGD format is used in database migration planning to encode PostgreSQL schemas portably. Teams convert SQL to PGD, share database designs, and generate deterministic SQL diffs to manage schema changes across projects using pgDesigner.

How do I generate SQL from a PGD file using the pgdesigner CLI?

To generate SQL from a PGD file using the pgdesigner CLI, run the command 'pgdesigner generate schema.pgd'. This produces SQL output from your PGD file, enabling you to apply the encoded PostgreSQL schema design to a database.

Can I use pgdesigner CLI to lint and diff PostgreSQL schemas?

Yes, you can use the pgdesigner CLI to lint and diff PostgreSQL schemas. The CLI provides guidance for commands like generate, diff, lint, and testdata, enabling deterministic SQL diffs and schema validation across projects.

Do I need pgDesigner to document and share PostgreSQL database schemas?

You need the PGD format to document and share PostgreSQL database schemas portably. It provides a canonical reference for encoding schemas, types, and mappings, allowing teams to share database designs and generate deterministic SQL diffs across projects.