PostgreSQL Coding Standards

Plugin pgsql-coding from marketplace cadasto in Cadasto/plugin-marketplace. Commands read from the repo's manifest — 12 days ago.

Skills (8)

• pgsql-coding

  PostgreSQL coding-standards router for PostgreSQL 18 and later (19 additions flagged as hints). This skill should be used when a task writes, reviews, tunes or debugs SQL, a .sql file, a migration, a schema, or a query string in Go (pgx) or PHP (PDO) code, when the task spans several areas, or when

• pgsql-indexing

  This skill should be used when a task adds, chooses, reviews or drops a PostgreSQL index, or asks why a query ignores one, for example "which index should I add", "what column order", "why isn't my index used", "deleting a parent row is slow", "can we drop this index", "how do I index this LIKE sear

• pgsql-jsonb

  This skill should be used whenever SQL reads, writes, builds, filters, indexes or validates json or jsonb in PostgreSQL, or passes it through pgx or PDO, for example "query this JSON field", "update one key in the document", "return the rows as a JSON array", "why is this jsonb filter slow", "why is

• pgsql-lint-setup

  This skill should be used when the user runs /pgsql-lint-setup or asks to "set up squawk", "add SQL linting", "lint our Postgres migrations", "add a migration linter to CI", "fail the build on unsafe migrations" or "scaffold .squawk.toml", or asks how to set squawk's pg_version or assume_in_transact

• pgsql-migrations

  This skill should be used when a task writes or reviews a migration or DDL that runs against a live PostgreSQL 18 table, such as ALTER TABLE, ADD COLUMN, SET NOT NULL, ADD CONSTRAINT or a foreign key, CREATE INDEX, DROP INDEX or REINDEX on a populated or partitioned table, an INVALID index left by a

• pgsql-performance

  This skill should be used when a PostgreSQL query or database is slow, or when a plan is pasted or compared (Seq Scan, Nested Loop, actual time, Rows Removed by Filter, Buffers, external merge, Batches, Index Searches, JIT, Workers Launched), for example "why is this query slow", "what is wrong with

• pgsql-query

  This skill should be used before writing, reviewing or debugging any PostgreSQL query or statement, including SQL in Go or PHP code, for example "find customers with no orders this month", "paginate this list", "upsert", "bulk insert", "make this job queue safe", "retry on a serialization failure or

• pgsql-schema

  This skill should be used when a task designs or reviews PostgreSQL tables and the objects around them, for example "design these tables", "which type for money or ids", "should status be an enum", "cascade the delete", "add row-level security per tenant". Covers CREATE TABLE, column types (identity

Subagents (2)

• pgsql-plan-analyst

  Use this agent when a PostgreSQL EXPLAIN plan needs analysing and runs past about 50 lines (the assistant's own included), when two plans must be compared (before and after an index, a rewrite or new statistics), or when reading the plan would otherwise fill the conversation. It runs the plugin's pl

• pgsql-reviewer

  Use this agent to review SQL for the bugs that survive tests and squawk: .sql files, migrations, DDL, or SQL strings in Go (pgx) or PHP (PDO). It finds NULL slips, SQL injection, unstable or deep-OFFSET pagination, jsonb predicates no index serves, unindexed foreign keys, migrations that lock or rew

Hooks (3)

• SessionStart

  bash "${CLAUDE_PLUGIN_ROOT}/hooks/session-start.sh"

• PostToolUse

  bash "${CLAUDE_PLUGIN_ROOT}/hooks/lint-on-save.sh"

• PostToolUse

  bash "${CLAUDE_PLUGIN_ROOT}/hooks/skill-nudge.sh"

Similar plugins