Why use sqlx over the standard database/sql library?

sqlx reduces boilerplate by providing automatic struct scanning and named parameter support while remaining fully compatible with the standard library interfaces.

How does this skill handle database timeouts?

The skill enforces the use of Context-aware methods (e.g., GetContext, ExecContext) for every operation to ensure proper cancellation and timeout management.

Does it support MySQL-specific error handling?

Yes, it includes patterns for using errors.As with the MySQL driver to catch specific error codes like 1062 for duplicate entries or 1452 for foreign key violations.

What is the recommended transaction pattern?

It recommends using BeginTxx followed by an immediate defer tx.Rollback(), which becomes a no-op once an explicit Commit() is called on the success path.

Go MySQL & sqlx Patterns

Name: Go MySQL & sqlx Patterns
Author: deandum

bydeandum

0•

Database Management

Implements production-grade MySQL database access in Go using sqlx with best practices for pooling, transactions, and repository patterns.

This skill provides specialized guidance for building robust MySQL-backed services in Go, primarily leveraging the sqlx library to reduce boilerplate while maintaining performance. It offers standardized patterns for connection pooling, context-aware queries, transaction management with deferred rollbacks, and clean architecture implementation via the repository pattern. Developers can use this to ensure type-safe data mapping, handle MySQL-specific error codes, and implement scalable database access layers that follow industry-standard Go idioms.

Key Features

01Safe transaction management with mandatory deferred rollbacks and isolation levels

02Advanced sqlx query patterns including GetContext, SelectContext, and NamedExec

03Clean architecture repository pattern with consumer-side dependency injection

040 GitHub stars

05Production-ready MySQL connection pool configuration and DSN optimization

06Specific error handling for MySQL constraints like duplicate entries and foreign keys

Use Cases

01Implementing data-consistent operations across multiple tables using managed transactions

02Building high-performance, concurrent MySQL microservices in Go

03Refactoring legacy database/sql code into a cleaner, maintainable repository layer

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add deandum/go-claude-resources go-database

For use in Claude.ai and ChatGPT

Download Skill