Golang database

Skill ComeOnOliver/skillshub/skills/HoangNguyen0403/agent-skills-standard/golang-database

Standards for database interaction, connection pooling, and repository patterns in Golang. Use when implementing database access, connection pools, or repositories in Go. (triggers: internal/adapter/repository/**, database, sql, postgres, gorm, sqlc, pgx)From its SKILL.md

Install

npx -y skills add ComeOnOliver/skillshub --skill golang-database

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

1.4 KB, 295 tokens by cl100k_base, as published. Nobody here has run it

Golang Database Standards

Priority: P0 (CRITICAL)

Principles

Prefer Raw SQL/Builders over ORMs: Go structs map well to SQL. ORMs (GORM) can obscure performance. Recommended: sqlc (type-safe SQL generation).
Repository Pattern: Abstract DB access behind interfaces in internal/port/ (e.g., UserRepository).
Connection Pooling: Always configure SetMaxOpenConns, SetMaxIdleConns, SetConnMaxLifetime.
Transactions: Logic requiring ACID MUST use transactions. Pass context.Context everywhere.

Drivers

PostgreSQL: jackc/pgx (Prefer pgx/v5 for performance and features).
MySQL: go-sql-driver/mysql.
SQLite: mattn/go-sqlite3 or modernc.org/sqlite (pure Go).

Anti-Patterns

No global db var: Inject DB connection via constructor; never use var db *sql.DB.
No bare queries: Use QueryContext/ExecContext; bare queries ignore context timeouts.
No leaked rows: Always defer rows.Close() and check rows.Err() after iteration.

References

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.