How do I install the Gorm SQL Gorm Query Patterns skill?

Run npx skillmds@latest add saifoelloh/gorm-sql-gorm-query-patterns in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Gorm SQL Gorm Query Patterns safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Gorm SQL Gorm Query Patterns?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Gorm SQL Gorm Query Patterns free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under MIT.

Who published Gorm SQL Gorm Query Patterns?

saifoelloh (@saifoelloh) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Gorm SQL Gorm Query Patterns by saifoelloh

Name: Gorm SQL Gorm Query Patterns
Rating: 4.666666666666667 (3 reviews)
Author: saifoelloh

Gorm SQL Gorm Query Patterns

GORM ORM query pattern review for PostgreSQL. Use when reviewing or writing Go database code using GORM — covers N+1, Preload vs Joins, transactions, error checking, Save vs Updates, and context propagation. Trigger on any GORM method usage.

saifoelloh Updated Sep 10, 2026

File contents

GORM Query Patterns

Expert-level review of GORM ORM usage in Go services backed by PostgreSQL. Covers correctness, safety, and idiomatic patterns.

When to Apply

Use this skill when:

Writing or reviewing repository layer code using GORM
Debugging unexpected query behavior (wrong results, wrong ORDER, missing data)
Reviewing association loading (Preload, Joins)
Auditing multi-step write operations for transaction safety

Rule Categories

Priority	Count	Focus
Critical	3	SQL injection, silent errors, partial writes
High	5	N+1, First vs Find, Save vs Updates, context, column selection
Medium	3	Scopes, pagination, association upserts

Rules Covered (11 total)

Critical Issues (3)

critical-sql-injection — Never concatenate user input into SQL strings
critical-error-check — Always check .Error after every GORM operation
critical-transaction-wrap — Wrap multi-step operations in db.Transaction()

High-Impact Patterns (5)

high-preload-vs-joins — Preload for loading, Joins for filtering
high-first-vs-find — First for single record, Find for lists
high-save-vs-updates — Use Updates with map for partial updates, not Save
high-with-context — Always pass context via db.WithContext(ctx)
high-select-columns — Select only required columns, never SELECT *

Medium Improvements (3)

medium-scopes — Extract reusable WHERE logic into GORM scopes
medium-pagination-order — Always include ORDER BY in paginated queries
medium-omit-associations — Use Omit to prevent unintended association upserts

Trigger Phrases

"Review this GORM query"
"Check repository layer"
"db.Find / db.First / db.Create / db.Where"
"Preload / Joins"
"GORM transaction"
"Is this GORM code correct?"

Related Skills

postgresql-syntax — For raw SQL correctness and Postgres-specific syntax
query-performance — For index usage and N+1 detection
error-handling — For GORM and PostgreSQL error handling patterns
golang-best-practices-skill database-repository — Companion Go skill covering identifier quoting and select redundancy

Output Format

## Critical Issues Found: X

### [Rule ID] (File: repository.go, approx. line Y)
**Issue**: Brief description
**Fix**: Suggested correction
**Example**:
```go
// Corrected code here

High-Impact Patterns: X

Medium Improvements: X

---name: gorm-sql-gorm-query-patternsdescription: GORM ORM query pattern review for PostgreSQL. Use when reviewing or writing Go database code using GORM — covers N+1, Preload vs Joins, transactions, error checking, Save vs Updates, and context propagation. Trigger on any GORM method usage.license: MIT---# GORM Query PatternsExpert-level review of GORM ORM usage in Go services backed by PostgreSQL. Covers correctness, safety, and idiomatic patterns.## When to ApplyUse this skill when:- Writing or reviewing repository layer code using GORM- Debugging unexpected query behavior (wrong results, wrong ORDER, missing data)- Reviewing association loading (Preload, Joins)- Auditing multi-step write operations for transaction safety## Rule Categories| Priority | Count | Focus ||---|---|---|| Critical | 3 | SQL injection, silent errors, partial writes || High | 5 | N+1, First vs Find, Save vs Updates, context, column selection || Medium | 3 | Scopes, pagination, association upserts |## Rules Covered (11 total)### Critical Issues (3)- `critical-sql-injection` — Never concatenate user input into SQL strings- `critical-error-check` — Always check `.Error` after every GORM operation- `critical-transaction-wrap` — Wrap multi-step operations in `db.Transaction()`### High-Impact Patterns (5)- `high-preload-vs-joins` — Preload for loading, Joins for filtering- `high-first-vs-find` — First for single record, Find for lists- `high-save-vs-updates` — Use Updates with map for partial updates, not Save- `high-with-context` — Always pass context via `db.WithContext(ctx)`- `high-select-columns` — Select only required columns, never `SELECT *`### Medium Improvements (3)- `medium-scopes` — Extract reusable WHERE logic into GORM scopes- `medium-pagination-order` — Always include ORDER BY in paginated queries- `medium-omit-associations` — Use Omit to prevent unintended association upserts## Trigger Phrases- "Review this GORM query"- "Check repository layer"- "db.Find / db.First / db.Create / db.Where"- "Preload / Joins"- "GORM transaction"- "Is this GORM code correct?"## Related Skills- [postgresql-syntax](../postgresql-syntax/SKILL.md) — For raw SQL correctness and Postgres-specific syntax- [query-performance](../query-performance/SKILL.md) — For index usage and N+1 detection- [error-handling](../error-handling/SKILL.md) — For GORM and PostgreSQL error handling patterns- **golang-best-practices-skill** `database-repository` — Companion Go skill covering identifier quoting and select redundancy## Output Format```## Critical Issues Found: X### [Rule ID] (File: repository.go, approx. line Y)**Issue**: Brief description**Fix**: Suggested correction**Example**:```go// Corrected code here```## High-Impact Patterns: X## Medium Improvements: X```

Frequently asked questions