What problem does it solve? Go developers frequently ship database code with connection leaks, SQL injection risks, unhandled NULL values, and missing transaction boundaries. This Skill enforces safe, explicit database access patterns so these defects are caught at the code level rather than in production. ## Core Features & Use Cases - Safe Query Patterns: Enforces parameterized queries, context propagation, explicit rows.Close(), and sql.ErrNoRows translation into domain errors. - Transactions and Locking: Covers BeginTxx/defer Rollback/Commit flows, isolation levels, and SELECT FOR UPDATE for race-condition prevention. - Performance and Testing Guidance: Provides connection pool sizing, batch processing (100-1000 rows), cursor-based pagination, pgx COPY bulk inserts, and integration tests with build tags and testcontainers. - Use Case: When asked to write a funds-transfer function in Go, the Skill produces a serializable transaction that locks account rows with SELECT FOR UPDATE, defers rollback, and wraps errors with context. ## Quick Start Ask the agent to write or review a Go repository function that queries PostgreSQL with sqlx, and it will apply parameterized queries, context propagation, and proper error handling automatically.
