Enable type-safe Go database access and migrations in Encore services.
npx skills add https://github.com/encoredev/skills --skill encore-go-database
Please help me install this Agent Skill. Skill: encore-go-database Source: https://github.com/encoredev/skills/tree/main/encore/go-database Command: npx skills add https://github.com/encoredev/skills --skill encore-go-database
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.
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.
Set up a Go service, configure the Encore database with your migrations, and implement a sample user query using sqldb.Query.
High-intent search queries and answers about installing and using this skill.
Type-safe database queries in Go are written using sqldb.Query, sqldb.QueryRow, and sqldb.Exec with generics, ensuring safe struct mapping and SQL injection protection for your Encore services.
Database migrations in Encore require a configured migrations directory. Schema migrations are automatically applied on application startup, providing clear versioning and consistent schema evolution across services.
Managing transactional records and user accounts in Encore involves building data access layers with sqldb.Query and sqldb.Exec, enabling multi-step operations within transactions for robust record handling.
No, you do not need to manually apply schema migrations. Encore automatically applies migrations from your configured migrations directory on startup, preventing drift between code and database.
Yes, Encore supports multi-step transactional database operations in Go. By using sqldb methods, you can execute structured queries that maintain safe data access and robust error handling.
AgentsMeshCreate and initialize isolated Git worktrees with automated development environment setup.
theofernandezzEnforce Prisma singleton client and service layer patterns for PostgreSQL and Neon serverless.
Holo00Generate idempotent SQL migrations for IdeaForge database schema changes.
tmoeishGenerate type-safe SQL query builders from annotated Go structs.
