cargo pgrx — Postgres extension tooling

What it does

Clear, practical guidance for developing Postgres extensions with pgrx and Rust. Explains the runtime boundary between code that runs inside Postgres (cdylib) and pure Rust test binaries, describes when to use #[test] vs #[pg_test], and provides command routing for common workflows (build, test, run, regress, package).

When to use it

Use this skill when you are authoring or testing pgrx extensions, deciding whether tests need a Postgres backend, selecting the minimal cargo command for a task, or preparing SQL regression tests and packaging. Helpful during CI setup, local development, and debugging linker errors related to pg_sys.

What's included

• Scripts: none in the SKILL dir, but many reference docs (test.md, run.md, regress.md, etc.) listed as sibling files.
• References: explanatory tables and subcommand reference sections inside the skill body.
• Instructions: classification rules for tests, anti-patterns, and precise command examples (cargo check, cargo pgrx test, cargo pgrx run, regress workflows).

Compatible agents

Best used by developer-focused agents with shell and repo access (Copilot/Codex/CLI-oriented agents) that can recommend commands and edit CI configs.