skills.rest
vmkteam
vmkteamOFFICIAL
Explore all skills by this author →
GitHub

pgmdd

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
One-click install
npx skills add https://github.com/vmkteam/claude-plugins --skill pgmdd
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
BekaChkhiroBekaChkhiro
1

pfCloudLink

Link a local directory to a PlanFlow cloud project by ID or selection.

Community
Intermediate
vmkteamvmkteam
6

pgd

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

Official
Intermediate
liuridaliurida

gorm-composite-primary-key

Model composite primary keys in GORM structs with multi-column uniqueness.

Community
Intermediate
cosmixcosmix
53

database-design

Design normalized relational and NoSQL database schemas with migrations and indexing.

Community
Advanced