SQL file format and conventions for pgpm migration scripts. Use when writing deploy/revert/verify SQL files, when asked about migration file format, SQL naming conventions, dependency declarations, or the three-file pattern in pgpm.
Quickly install pgpm-sql-conventions AI skill to your development environment via command line
Source: constructive-io/constructive-skills.
Rules and format for writing SQL migration files in pgpm modules.
pgpm is deterministic — each change is deployed exactly once and reverted exactly once. Use CREATE, not CREATE OR REPLACE:
If you need to modify an existing function, create a new change that drops and recreates it, or use the revert/redeploy cycle.
SQL file format and conventions for pgpm migration scripts. Use when writing deploy/revert/verify SQL files, when asked about migration file format, SQL naming conventions, dependency declarations, or the three-file pattern in pgpm. 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-sql-conventionsSQL file format and conventions for pgpm migration scripts. Use when writing deploy/revert/verify SQL files, when asked about migration file format, SQL naming conventions, dependency declarations, or the three-file pattern in pgpm. 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-sql-conventions 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