pgxgen

Configure and use pgxgen — a code generation tool for PostgreSQL, MySQL, and SQLite. Triggers when: working with pgxgen.yaml config files, generating CRUD SQL queries, generating Go models from SQL schema, sqlc integration and auto-generated sqlc.yaml, database code generation, Go struct generation from tables, type mapping (SQL to Go), soft delete configuration, batch inserts, table constants generation, or any mention of pgxgen CLI commands (generate, validate, watch, init, migrate, example, schema, fmt). Also triggers for: configuring per-table repos vs single repo layout, custom CRUD templates, nullable type handling (pgtype, sql.Null*), enum generation, and struct tag customization (json, db, validate tags).

Compile SQL queries to type-safe Go code with sqlc. Use this skill whenever working with sqlc configuration (sqlc.yaml, sqlc.json), writing SQL query files with sqlc annotations (:one, :many, :exec, :execrows, :execresult, :execlastid, :copyfrom, :batchone, :batchmany, :batchexec), configuring type overrides, setting up vet/lint rules, managing sqlc plugins (WASM or process), or troubleshooting sqlc code generation. Also triggers when code imports generated sqlc packages, when the user mentions "sqlc generate", "sqlc init", "sqlc vet", "sqlc diff", "sqlc compile", or asks about SQL-to-Go code generation, query compilation, database schema parsing, or Go struct generation from SQL tables. Applies to PostgreSQL, MySQL, and SQLite engines.