What is the Options API in this skill?

The Options API is a design pattern that uses method chaining (like WithCondition and WithParam) to build SQL queries programmatically instead of using raw string concatenation.

How does this skill prevent SQL injection?

It enforces the use of parameterized queries using a specific ':key:' syntax and the WithParam method, ensuring that user input is never directly executed as SQL code.

Why is there a mocker check in every query function?

The mocker check allows the application to swap real database calls with mock implementations during testing, ensuring that unit tests are fast, isolated, and do not require a live database.

Where should I define my database joins?

Following the conventions of this skill, specific join logic and field inclusions should be organized within a 'joins.go' file to keep the primary query logic clean.

Go Model Query Builder

Name: Go Model Query Builder
Author: griffnb

bygriffnb

0•

数据库管理

Constructs type-safe database queries using a standardized Options API for Go backend services.

This skill enables Claude to generate structured, type-safe database queries utilizing an Options API pattern. It focuses on maintainability by enforcing the use of generated column helpers, parameter binding to prevent SQL injection, and a mandatory mocking pattern for robust unit testing. By centralizing logic in specific files like queries.go and joins.go, it ensures backend codebases remain consistent, readable, and easy to extend with complex filtering, joining, and ordering logic.

主要功能

01Type-safe query construction with generated Column helpers

02Standardized file organization for queries and joins

03Chained Options API for conditions, parameters, and limits

04Automatic slice handling for SQL IN operations

05Built-in mocking patterns for test-driven development

060 GitHub stars

使用场景

01Building reusable and mockable database access layers

02Implementing paginated and ordered result sets for backend APIs

03Generating complex lookup functions with multiple conditional filters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add griffnb/claude-plugins model-queries

For use in Claude.ai and ChatGPT

Download Skill