What problem does it solve? Adding a database to a Go Gin API involves many decisions: ORM choice, connection pooling, transactions, migrations, and keeping SQL out of handlers. This Skill provides production-oriented patterns for wiring PostgreSQL into a Gin project cleanly, so database logic stays in repositories and business logic stays testable. ## Core Features & Use Cases - Repository Pattern with GORM or sqlx: Define interfaces in the domain layer and swap GORM for sqlx implementations without touching services or handlers. - Connection Setup & Resilience: ConnectWithRetry with exponential backoff, connection pool tuning, and TLS/sslmode configuration for production. - Transactions, Pagination & Migrations: Context-based transaction propagation, cursor/keyset pagination, and golang-migrate workflows including zero-downtime patterns. - Use Case: You are building a Gin API and need a users table with CRUD endpoints. Use this Skill to scaffold the domain interface, a GORM repository with soft deletes and error mapping, migrations for the schema, and dependency injection wiring in main.go. ## Quick Start Ask the AI to add a PostgreSQL-backed user repository to your Gin project using GORM, with migrations and dependency injection in main.go.
