encore-go-database

What problem does it solve?

Encore Go projects often struggle with unsafe, ad-hoc database access and unmanaged migrations. This Skill provides type-safe query patterns, structured migrations, and robust error handling to reduce runtime errors and drift between code and database.

Core Features & Use Cases

• Type-safe queries with generics using sqldb.Query, sqldb.QueryRow, and sqldb.Exec.
• Migrations structure with automatic application on startup and clear versioning.
• Safe struct mapping and SQL injection protection for common Go data access patterns.

Use cases include building data access layers for users, accounts, and transactions, executing multi-step operations within transactions, and maintaining consistent schema evolution across services.

Quick Start

Set up a Go service, configure the Encore database with your migrations, and implement a sample user query using sqldb.Query.