sqlc Compile Pure SQL Queries into Type-Safe Go Code

---
name: "sqlc-compile-sql-to-type-safe-go"
description: "Write raw, optimized SQL queries and compile them into 100% type-safe, boilerplate-free Go code."
metadata:
  author: "sqlc"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "compile sql with sqlc"
  - "sqlc.yaml configuration"
  - "write sqlc query annotation"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# sqlc Compile Pure SQL Queries into Type-Safe Go Code

Operates sqlc: writing sqlc.yaml configuration, authoring schema.sql and query.sql files, compiling with sqlc generate, type-safe query parameter structs, and integrating with pgx/v5 or database/sql.

## When to Invoke
Invoke this skill whenever you need to:
- compile sql with sqlc
- sqlc.yaml configuration
- write sqlc query annotation

## Execution SOP & Rules
1. Configure sqlc.yaml defining version: '2', sql: [{ engine: 'postgresql', schema: 'schema.sql', queries: 'query.sql' }].
2. Annotate queries: -- name: ListUsers :many
SELECT id, name, email FROM users ORDER BY name;.
3. Compile: sqlc generate to emit clean models.go and db.go.
4. Consume in application: queries := db.New(conn); users, err := queries.ListUsers(ctx).

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.