Which database libraries are supported by this skill?

This skill primarily focuses on pgx for PostgreSQL, Squirrel for fluent SQL building, and Goose for database migrations, alongside standard Redis integration.

Does this skill provide guidance on transaction management?

Absolutely. It suggests best practices for transaction boundaries, including the use of transaction managers and context injection for robust error handling.

When should I use ClickHouse vs PostgreSQL according to this skill?

The skill recommends PostgreSQL for transactional workloads and standard relational data, while suggesting ClickHouse for high-performance analytical workloads.

How does this skill handle Go database migrations?

It provides structured guidance for using Goose, ensuring migrations are idempotent, timestamp-prefixed, and include both Up and Down sections for safety.

Can it help with Go Repository Pattern implementation?

Yes, it enforces a clean Repository Pattern that separates private DB-tagged models from public domain entities, facilitating better maintainability and testing.

Go Database Integration

Name: Go Database Integration
Author: victorzhuk

byvictorzhuk

0•

Gestión de Bases de Datos

Streamlines Go database development with expert patterns for PostgreSQL, ClickHouse, and Redis using pgx and Goose.

The Go Database Integration skill transforms Claude into an expert database engineer for Go applications. It provides high-performance implementation patterns for PostgreSQL, ClickHouse, and Redis, focusing on the Repository Pattern, dynamic query building with Squirrel, and reliable migrations with Goose. This skill ensures your data layer is production-ready by automating complex tasks like connection pool tuning, transaction management with context injection, and mapping database-specific errors to domain-level entities for cleaner architecture.

Características Principales

01Automated migration workflows with Goose featuring idempotent Up/Down sections

02Standardized Repository Pattern with clear separation between DB models and domain entities

03Optimized connection pool configuration for pgxpool to handle high-concurrency workloads

04Advanced Redis caching strategies including cache-aside patterns and TTL management

050 GitHub stars

06Dynamic SQL construction using Squirrel for complex joins, pagination, and conditions

Casos de Uso

01Adding a Redis-backed caching layer to Go microservices to reduce database latency

02Architecting a scalable PostgreSQL backend with robust repository layers and transaction handling

03Implementing high-performance analytical data processing using ClickHouse integration

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add victorzhuk/go-ent go

For use in Claude.ai and ChatGPT

Download Skill