pgpm

What problem does it solve?

This Skill streamlines PostgreSQL database schema management by providing deterministic, plan-driven migrations and dependency management, akin to package managers like npm for code.

Core Features & Use Cases

• Automated Migrations: Define database changes with deploy, revert, and verify scripts for safe, repeatable deployments.
• Dependency Management: Handle dependencies between changes and across modules within a workspace.
• Module Packaging: Package and publish SQL database logic as reusable modules.
• Use Case: When developing a new feature that requires database schema changes, use pgpm to add new tables, functions, and indexes, ensuring they can be reliably deployed and reverted across different environments.

Quick Start

Use the pgpm skill to deploy all pending database changes to the 'myapp_dev' database.