AgentSkillsCN

go-sqlparams-query-author

使用 Mike 的 go-sqlparams 包编写并重构 SQL 查询代码。适用于构建参数化 SQL、构造 WHERE 子句、实现分页与排序，或绑定命名参数时使用。

SKILL.md
--- frontmatter
name: go-sqlparams-query-author
description: Write and refactor SQL query code using Mike's go-sqlparams package. Use when building parameterized SQL, constructing WHERE clauses, pagination/sorting, or binding named params.

SQL Params Query Author

Use this skill when the user asks to:

  • •create SQL queries with parameters
  • •refactor raw SQL + manual args into go-sqlparams
  • •build dynamic filters (optional clauses) safely
  • •implement pagination, sorting, and query composition

Mandatory references (read in order)

  1. •references/nonnegotiables.md
  2. •references/doterr.md
  3. •references/clearpath.md (production code only)
  4. •references/sqlparams-package-notes.md (go-sqlparams catalog notes)

Hard constraints

  • •Never build SQL by concatenating untrusted values.
  • •Use parameter binding patterns from go-sqlparams; do not invent your own.
  • •Preserve behavior when refactoring unless the user explicitly asks to change semantics.
  • •Return errors via doterr.

Composition approach (default)

  • •Keep SQL text readable (multi-line raw string literals).
  • •Use go-sqlparams to manage:
    • •named parameters / argument lists
    • •optional predicates
    • •IN lists / repeated parameters (as supported by the package)
  • •Build query pieces (SELECT, FROM, WHERE, ORDER, LIMIT/OFFSET) in a small number of clear steps.

Deliverables

When asked to implement a query:

  • •Provide the query builder function(s)
  • •Show the execution call site (db.Query / db.QueryContext etc. as appropriate)
  • •Include row scanning code (or mapping helpers) if relevant
  • •Include a short note on indexes/constraints if the query implies them (optional)

Self-check

  • •No compound init-if.
  • •No ignored errors.
  • •No string concatenation for untrusted SQL values.
  • •Uses go-sqlparams for parameter management and doterr for errors.