Manage PostgreSQL extensions and pgpm modules in a pgpm workspace. Use when asked to "add an extension", "install a module", "add a dependency", "use pgcrypto/uuid-ossp", or when working with .control files and the extensions/ directory. CRITICAL — never run CREATE EXTENSION directly; pgpm handles extension creation during deploy.
Quickly install pgpm-extensions AI skill to your development environment via command line
Source: constructive-io/constructive-skills.
How extensions and modules work in pgpm — adding dependencies, installing packages, and understanding the .control file.
NEVER run CREATE EXTENSION directly in SQL migration files. pgpm is deterministic — it reads the .control file and handles extension creation automatically during pgpm deploy. Writing CREATE EXTENSION in a deploy script will cause errors or duplicate operations.
| uuid-ossp | UUID generation (uuidgeneratev4()) | | pgcrypto | Cryptographic functions (genrandombytes()) | | plpgsql | PL/pgSQL procedural language | | pgtrgm | Trigram text similarity | | citext | Case-insensitive text | | hstore | Key-value store |
Manage PostgreSQL extensions and pgpm modules in a pgpm workspace. Use when asked to "add an extension", "install a module", "add a dependency", "use pgcrypto/uuid-ossp", or when working with .control files and the extensions/ directory. CRITICAL — never run CREATE EXTENSION directly; pgpm handles extension creation during deploy. Source: constructive-io/constructive-skills.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/constructive-io/constructive-skills --skill pgpm-extensionsManage PostgreSQL extensions and pgpm modules in a pgpm workspace. Use when asked to "add an extension", "install a module", "add a dependency", "use pgcrypto/uuid-ossp", or when working with .control files and the extensions/ directory. CRITICAL — never run CREATE EXTENSION directly; pgpm handles extension creation during deploy. Source: constructive-io/constructive-skills.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/constructive-io/constructive-skills --skill pgpm-extensions Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/constructive-io/constructive-skills