Design PostgreSQL repository layers in Go with pgx or sqlx.
npx skills add https://github.com/pure-golang/level85 --skill x-database-patterns
Please help me install this Agent Skill. Skill: x-database-patterns Source: https://github.com/pure-golang/level85/tree/main/.agents/skills/x-database-patterns Command: npx skills add https://github.com/pure-golang/level85 --skill x-database-patterns
This skill helps you structure PostgreSQL access in a Go service or adapter so that database drivers, repository boundaries, transactions across repos, and constraint error handling are consistent and maintainable.
Ask the assistant to design your PostgreSQL repo layer for a Go service using pgx, including a shared dbQuerier, cross-repository transactions, and constraint-error handling strategy.
High-intent search queries and answers about installing and using this skill.
Design a PostgreSQL repository layer by defining a shared dbQuerier interface that works with both connection pools and transactions, allowing a single transaction to be passed into multiple repositories for atomic cross-repository operations.
Choose between pgx and sqlx for your Go database access layer based on specific project needs; pgx offers native PostgreSQL protocol support while sqlx provides constraint helper functions for reliable error mapping, and this decision guides the entire repository structure.
Handle PostgreSQL constraint violations consistently by using sqlx helper functions for reliable constraint error mapping, ensuring your service or adaptor catches and translates these database errors into predictable application-level responses.
Avoid using JSONB as the primary data model in PostgreSQL when your Go service requires constraints, search, or join logic; structured relational data modeling is necessary to maintain query performance and data integrity.
A dbQuerier contract in Go is a shared interface that standardizes query execution methods, unifying connection pools and transactions so repository constructors remain side-effect free and can operate seamlessly within either context.
musujDefine project terminology, entities, relationships, and data structures.
Holo00Create or modify IdeaForge API endpoints with Zod validation and ApiResponse wrapping.
matlockxProvides PostgreSQL best practices for Go services including schema design, golang-migrate, and connection pooling.
eduardo-slProvide idiomatic database access patterns for Go services using database/sql, sqlc, GORM, or ent.
