Add or modify a PostgreSQL system-catalog entry — covers adding a pgproc.dat builtin function, pgoperator.dat operator, pgtype.dat type, pgcast.dat cast, pgopclass.dat opclass, adding a new column on pgclass / pgaggregate / pgattribute / etc., BKI bootstrap entries, OID assignment policy (genbki.pl, unusedoids), catversion (CATALOGVERSIONNO) bumping, and regenerating postgres.bki. Use whenever a PG patch edits anything under src/include/catalog/ (.h or .dat), adds a SQL-visible builtin (function/operator/type/cast/opclass), assigns or recycles an OID, or bumps the catversion. Skip for user-level informationschema queries on a running server, Django / Alembic / Rails / Flyway / Liquibase migrations, Oracle DBA / MySQL informationschema / Snowflake INFORMATIONSCHEMA catalog questions, schema design and normalization advice, ER-diagram tooling, and adding constraints to user-application tables.
Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI
Supported by the Atlas install prompt. Skill-specific requirements vary.
Skill stats
Skills1CategoryEngineeringStars0
About this skill
Add or modify a PostgreSQL system-catalog entry — covers adding a pgproc.dat builtin function, pgoperator.dat operator, pgtype.dat type, pgcast.dat cast, pgopclass.dat opclass, adding a new column on pgclass / pgaggregate / pgattribute / etc., BKI bootstrap entries, OID assignment policy (genbki.pl, unusedoids), catversion (CATALOGVERSIONNO) bumping, and regenerating postgres.bki. Use whenever a PG patch edits anything under src/include/catalog/ (.h or .dat), adds a SQL-visible builtin (function/operator/type/cast/opclass), assigns or recycles an OID, or bumps the catversion. Skip for user-level informationschema queries on a running server, Django / Alembic / Rails / Flyway / Liquibase migrations, Oracle DBA / MySQL informationschema / Snowflake INFORMATIONSCHEMA catalog questions, schema design and normalization advice, ER-diagram tooling, and adding constraints to user-application tables.
Quick start
Copy the install prompt. Use the green button above this README.
Send it to your agent. Paste it into your coding agent’s chat and send.
Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
Add or modify a PostgreSQL system-catalog entry — covers adding a pg_proc.dat builtin function, pg_operator.dat operator, pg_type.dat type, pg_cast.dat cast, pg_opclass.dat opclass, adding a new column on pg_class / pg_aggregate / pg_attribute / etc., BKI bootstrap entries, OID assignment policy (genbki.pl, unused_oids), catversion (CATALOG_VERSION_NO) bumping, and regenerating postgres.bki. Use whenever a PG patch edits anything under src/include/catalog/ (.h or .dat), adds a SQL-visible builtin (function/operator/type/cast/opclass), assigns or recycles an OID, or bumps the catversion. Skip for user-level information_schema queries on a running server, Django / Alembic / Rails / Flyway / Liquibase migrations, Oracle DBA_* / MySQL information_schema / Snowflake INFORMATION_SCHEMA catalog questions, schema design and normalization advice, ER-diagram tooling, and adding constraints to user-application tables.
About this listing
Category
Engineering
Reported license
PostgreSQL
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.
Claude Code
Codex
Cursor
GitHub Copilot
Gemini CLI