Build dynamic database queries with type-safe Options API helpers.
npx skills add https://github.com/griffnb/claude-plugins --skill model-queries
Please help me install this Agent Skill. Skill: model-queries Source: https://github.com/griffnb/claude-plugins/tree/main/plugins/backend/skills/model-queries Command: npx skills add https://github.com/griffnb/claude-plugins --skill model-queries
All database queries use a generated Options struct and column helpers for type-safe query building. The approach centralizes query logic and ensures consistent parameter binding across models.
Create a GetByEmail function that fetches a user by email using the Options API.
High-intent search queries and answers about installing and using this skill.
Type-safe database queries are built using an Options API with generated column helpers, applying WithCondition and WithParam to ensure consistent parameter binding and dynamic filtering.
Centralizing query logic in a dedicated queries.go file ensures consistent parameter binding across models, using an Options struct to enforce strict mocker context for testability and safe data access.
Yes, the Options API supports complex database queries with multiple conditions, IN lists, joins, and ordered results using the WithOrder helper to manage sorting across your data models.
You can fetch a user by email by creating a GetByEmail function that utilizes WithCondition and WithParam to execute simple lookups against the generated Columns struct for type safety.
Yes, the approach enforces strict mocker usage for testability, ensuring your backend data access layers remain isolated and verifiable when executing flexible filtering and parameterized conditions.
doanchienthangdevImplement Prisma ORM for type-safe database access and migrations.
shaprisGenerates and executes SQL to answer natural-language business questions using dbt semantic layer or compiled SQL.
jonnabioAutomate database migrations, schema changes, and query optimization.
marquesfelipIdentify and fix SQL injection vulnerabilities in data access layers.
