pgmdd

Name: pgmdd
Availability: InStock
Author: vmkteam

Guide database modeling with MicroOLAP PDD format and XML structure.

6|Updated Apr 5, 2026

Search Tags:#migration #xml #composite-keys #database-design #id-management #pdd #microolap

Ready to run

npx skills add https://github.com/vmkteam/claude-plugins --skill pgmdd

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: pgmdd
Source: https://github.com/vmkteam/claude-plugins/tree/main/plugins/developer/skills/pgmdd
Command: npx skills add https://github.com/vmkteam/claude-plugins --skill pgmdd

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PDD is a legacy MicroOLAP Database Designer format used to edit PDD files. Public specifications are not available, so this guide helps engineers work with PDD-based projects and reason about migration toward newer formats like PGD.

Core Features & Use Cases

Documents the PDD file structure, including IDs, composites, indexes, and REFERENCES sections.
Provides non-obvious rules and best practices for editing PDD files to ensure consistency and compatibility with the MicroOLAP GUI.
Serves as a practical reference for tooling and workflows when working with MicroOLAP Database Designer for PostgreSQL.

Quick Start

Review existing PDD files in your project and reference the documented rules to guide edits.

Frequently Asked Questions about pgmdd

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

FAQPage Schema

How do I edit a PDD file for PostgreSQL without breaking the MicroOLAP Database Designer structure?▼

To edit a PDD file safely, follow documented rules for IDs, composites, indexes, and the REFERENCES section to maintain compatibility with the MicroOLAP GUI and ensure valid XML outputs.

What is the MicroOLAP PDD format used for in database design?▼

The PDD format is a legacy XML-based database design format used to model PostgreSQL databases. It structures database schemas using unique IDs, composite keys, and indexes within specific XML sections.

How do I manage ID uniqueness and composite keys in a PDD file?▼

Managing ID uniqueness and composite keys in a PDD file requires strict adherence to specific XML structure rules and editor constraints to ensure consistent identifier management across the database design.

Can I migrate a legacy PDD file to a newer PostgreSQL database design format?▼

Migration from the legacy PDD format is supported by relating PDD structures to newer formats like PGD. The guide helps engineers reason about migration considerations to transition database design projects effectively.

What are the limitations of editing PDD files for PostgreSQL without public specifications?▼

Without public specifications, editing PDD files risks breaking the XML structure and ID consistency needed for the MicroOLAP GUI. These limitations are mitigated by following documented best practices for the PDD format.