sqlc-go

What problem does it solve?

Writing SQL queries and manually mapping them to Go structs is error-prone and time-consuming. This Skill automates Go code generation from SQL, ensuring type safety and significantly reducing boilerplate, so you can focus on application logic.

Core Features & Use Cases

• Type-Safe Go Code Generation: Automatically generates Go code from your SQL queries, eliminating manual mapping errors and ensuring robust database interactions.
• PostgreSQL Best Practices: Provides expert guidance on advanced PostgreSQL features like JSONB, arrays, Common Table Expressions (CTEs), and window functions.
• Migration Management: Seamlessly integrates with golang-migrate for robust and reversible database schema evolution, simplifying your development workflow.
• Use Case: Need to add a new feature requiring complex database interactions? This Skill helps you define your SQL, generate the Go code, and manage schema changes effortlessly, letting you focus on building features, not fighting with ORMs.

Quick Start

Help me configure sqlc for a new Go project using PostgreSQL and generate a query to list users by email.