Configure pgx connection pools, queries, migrations, and transactions in Go.
npx skills add https://github.com/anicdh/agstack --skill go-db-anicdh
Please help me install this Agent Skill. Skill: go-db Source: https://github.com/anicdh/agstack/tree/main/.claude/skills/go/go-db Command: npx skills add https://github.com/anicdh/agstack --skill go-db-anicdh
Go developers writing database interactions with pgx need clear patterns for connection pooling, safe queries, migrations, and transaction handling; this skill provides practical Go pgx usage patterns and examples.
Create a Go module and implement the pgx-based DB layer following the patterns and examples provided.
High-intent search queries and answers about installing and using this skill.
Configure a global PostgreSQL connection pool in Go using pgx by defining min and max connections and managing the pool lifecycle for efficient database access. This ensures safe backend service operations.
Handle database transactions in Go pgx by executing multi-step operations with proper rollback mechanisms on failure. This pattern ensures reliable complex query execution and data integrity.
Run SQL migrations in a Go pgx project by organizing migration files in a dedicated migrations folder. This approach maintains version control over PostgreSQL schema changes across microservices.
Handle nullable PostgreSQL columns and wrap query errors in Go by using proper scanning patterns and error wrapping for clarity. This ensures robust context-aware database operations.
Yes, pgx supports context-aware parameterized queries for Go backend services. It enables safe PostgreSQL data access by propagating context and using parameterized statements to prevent injection.
Use pgx for Go microservices when you need reliable PostgreSQL access with advanced connection pooling, complex transaction handling, and organized migrations for data pipelines and API servers.
constzzReview Go database code for parameterized queries and connection pooling.
ehylandBuild and consume type-safe tRPC APIs with shared TypeScript types.
linehaul-aiImplement layered Go/Echo/pgx backend services with handlers, repositories, and transactional operations.
isharoverwhiteImplement SQLAlchemy 2.0 ORM models for Python database operations.
