Review Go database code for SQL injection, context, and transaction safety.
npx skills add https://github.com/muratmirgun/gophers --skill go-database-muratmirgun
Please help me install this Agent Skill. Skill: go-database Source: https://github.com/muratmirgun/gophers/tree/main/skills/go-database Command: npx skills add https://github.com/muratmirgun/gophers --skill go-database-muratmirgun
This Skill helps you write, review, and debug Go code that talks to SQL databases without falling into common production traps like SQL injection, leaked connections, missing context propagation, and unsafe transaction handling.
Ask the assistant to review your Go database code for SQL injection risks, missing context usage, row-closing bugs, and transaction safety issues.
High-intent search queries and answers about installing and using this skill.
Prevent SQL injection in Go database code by enforcing parameterized queries and safe dynamic IN clause construction. This Skill guides SQL query building across libraries like database/sql, sqlx, sqlc, and pgx to eliminate injection risks.
Handle NULL values when scanning rows in Go by applying NULL-safe scanning techniques. This Skill ensures your repository code correctly manages NULL database values alongside explicit rows.Err checks to prevent runtime panics.
Manage transactions and connection pools in Go by structuring transactions with proper isolation and locking while tuning connection pool parameters. This Skill prevents leaked connections and ensures reliable database access.
Use context-aware queries with database/sql in Go by passing context variables to query execution methods. This Skill updates repository layers to use context-aware I/O, ensuring operations can be cancelled and timed out correctly.
Choose pgx over sqlx or sqlc when you need specialized PostgreSQL driver performance, whereas sqlx offers convenience and sqlc provides type-safe generation. This Skill helps select the right library and avoid ORMs like GORM.
constzzReview Go database code for parameterized queries and connection pooling.
terrylicaRun multi-agent validation across environment, data flow, and query layers.
matlockxProvides PostgreSQL best practices for Go services including schema design, golang-migrate, and connection pooling.
galihcittaConvert ORM calls to raw SQL and analyze query performance.
