Skip to content

pgsql-coding v0.1.0

Latest

Choose a tag to compare

@sebastian-iancu sebastian-iancu released this 27 Oct 13:44

First release of pgsql-coding: PostgreSQL coding standards for Claude Code and Cursor. It covers queries, json and jsonb, schema design, indexing, performance analysis and safe migrations. PostgreSQL 18 is the floor, and PostgreSQL 19 additions are flagged as hints.

Install and host setup: docs/install.md.

Added

  • Skills: pgsql-coding router with the versions.md reference (what needs PostgreSQL 17, 18 or 19).
  • Skills: pgsql-query, pgsql-jsonb, pgsql-schema, pgsql-indexing, pgsql-performance and pgsql-migrations, each with cited references/.
  • Skills: /pgsql-lint-setup writes the reference .squawk.toml.
  • Agents: pgsql-reviewer, a report-only SQL reviewer.
  • Agents: pgsql-plan-analyst, a report-only analyst of a long EXPLAIN plan or a before-and-after pair.
  • Skills: pgsql-performance ships scripts/plan-summary.py, a TEXT and JSON plan summariser.
  • Scripts: scripts/plan-summary-test.py with real PostgreSQL 18.6 plans in scripts/testdata/plans/.
  • Hooks: session-start.sh, lint-on-save.sh (squawk, opt-in through .squawk.toml) and skill-nudge.sh, wired for Claude Code and Cursor.
  • Cursor rule: rules/pgsql-context.mdc for **/*.sql.
  • References: references/squawk.toml.
  • Evals: one case per focused skill under evals/.
  • Scripts: scripts/validate.py (with --selftest and --check-links), scripts/validate.sh, scripts/hooks-test.sh.
  • Docs: docs/install.md, docs/testing.md, docs/versioning.md, docs/authoring.md; CI workflows validate.yml and links.yml.