Implement and debug Go database access with sqlx or pgx.
npx skills add https://github.com/dashkan/pivox --skill golang-database-dashkan
Please help me install this Agent Skill. Skill: golang-database Source: https://github.com/dashkan/pivox/tree/main/.agents/skills/golang-database Command: npx skills add https://github.com/dashkan/pivox --skill golang-database-dashkan
This Skill helps you prevent common database bugs in Go by enforcing parameterized SQL, correct context propagation, reliable row handling, safe transactions, and production-safe patterns for scanning, NULLs, and error handling.
sql.ErrNoRows handling, and guaranteed rows.Close() plus rows.Err() checks.SELECT ... FOR UPDATE locking, NULLable column modeling, connection pool sizing, and bulk/batch processing heuristics.Use golang-database to implement or review a Go repository method that uses sqlx or pgx with safe parameterized queries, context-aware calls, correct scanning (including NULLable columns), and robust transaction behavior.
High-intent search queries and answers about installing and using this skill.
To prevent SQL injection in Go, you must use parameterized queries with driver-appropriate placeholders, explicitly banning string-built predicates. This ensures inputs are treated strictly as data values, not executable SQL code.
Correct database/sql usage requires explicitly checking for sql.ErrNoRows when scanning single rows and guaranteeing rows.Close() plus rows.Err() checks. This prevents resource leaks and unhandled errors during row iteration.
Managing PostgreSQL transactions with pgx or sqlx involves setting safe transaction isolation levels and applying SELECT ... FOR UPDATE locking. This ensures transactional correctness and prevents concurrent modification issues.
Yes, this database access approach supports PostgreSQL, MariaDB, MySQL, and SQLite using sqlx or pgx. It provides production-safe patterns for scanning, NULLable column modeling, and connection pool sizing across these drivers.
You should use external migration tooling for schema and migration SQL because this approach explicitly refuses to generate schema-defining SQL. It focuses strictly on safe query writing, transactional correctness, and repository-layer debugging.
Handling NULLable columns in Go requires proper modeling using types like sql.NullString or pointer fields during row scanning. This avoids scan errors and ensures safe data mapping when database values are absent.
constzzReview Go database code for parameterized queries and connection pooling.
jabrenaManage Flyway database migrations in Micronaut applications.
OlegHQImplement dependency-injected HTTP handlers with the Go standard library.
dotlab-hqDefine TypeScript database schemas, write type-safe queries, and manage migrations.