postgres-best-practices
Installation
SKILL.md
Postgres
Rules for schema and queries on Postgres. They are language-agnostic; the Go half lives in the
go-idiomatic skill (references/database.md, references/patterns.md).
Where to Look
| If you're working on… | Load this |
|---|---|
Go code that runs these queries (database/sql, pgx) |
go-idiomatic references/database.md |
| A closed value set mirrored as a Go type | go-idiomatic references/patterns.md § Typed Value Sets |
| Writing or changing a migration, any tool | references/migrations.md |
Converting an existing Postgres ENUM to text + CHECK |
references/migrations.md § ENUM Conversion |
| Migrations in a repo that uses goose | references/goose.md (only when the repo uses goose) |
Only if the repo has sqlc.yaml: queries, config, CI |
references/sqlc.md |