菜单
PostgreSQL SQL syntax review for Go/GORM projects. Use when writing or reviewing raw SQL used via db.Raw(), db.Exec(), or migrations. Covers placeholder style, reserved keyword quoting, RETURNING, ILIKE, JSONB operators, and type casting. Don't use for MySQL or SQLite.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Comprehensive Go + GORM + PostgreSQL review meta-skill. Coordinates 9 specialized domain skills for fullstack Go application audits. Covers concurrency, architecture, idioms, queries, SQL performance, and migration safety.
Unified Go + GORM + PostgreSQL error handling review. Covers error wrapping, context propagation, PostgreSQL error codes (23505, 40001), errors.Is/As mapping, and retry logic. Ensures proper error chains and robust database failure recovery.
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.
Database migration safety review for GORM + PostgreSQL. Use when writing or reviewing schema changes, AutoMigrate usage, ALTER TABLE statements, or index creation. Covers zero-downtime patterns, NOT NULL backfill, CONCURRENTLY indexes, idempotency, and rollback files.
GORM + PostgreSQL query performance review. Use when optimizing slow queries, designing indexes, analyzing N+1 patterns, or configuring connection pools. Trigger on "slow", "optimize", "index", "EXPLAIN", "N+1", or performance degradation.
Clean Architecture audit for Go services. Use when reviewing layered architecture, dependency rules, or gRPC/usecase/repository patterns. Ensures proper separation of concerns and dependency inversion.
| name | gorm-sql-postgresql-syntax |
| description | PostgreSQL SQL syntax review for Go/GORM projects. Use when writing or reviewing raw SQL used via db.Raw(), db.Exec(), or migrations. Covers placeholder style, reserved keyword quoting, RETURNING, ILIKE, JSONB operators, and type casting. Don't use for MySQL or SQLite. |
| license | MIT |
| metadata | {"author":"saifoelloh","version":"1.0.0","parent_skill":"gorm-sql-best-practices","sources":["PostgreSQL 16 Official Documentation","The Art of PostgreSQL (Dimitri Fontaine)","GORM Official Documentation (gorm.io/docs)"],"last_updated":"2026-03-13"} |
Expert-level review of raw PostgreSQL SQL syntax in GORM/Go projects. Ensures correct Postgres-specific usage, idiomatic SQL, and avoids common runtime errors.
Use this skill when:
db.Raw(), db.Exec(), or migration filessyntax error or operator does not exist PostgreSQL errorsRETURNING, CTEs, window functions, or ILIKE| Priority | Count | Focus |
|---|---|---|
| Critical | 1 | Placeholder style mismatch |
| High | 4 | Identifier quoting, RETURNING, ILIKE, type casting |
| Medium | 4 | CTE readability, JSONB operators, INTERVAL, select redundancy |
critical-placeholder-style — Use ? with GORM, $N only with pgx/pq directlyhigh-identifier-quoting — Quote reserved keywords (order, user, group) in raw SQLhigh-returning-clause — Use RETURNING for generated values after INSERT/UPDATEhigh-ilike-search — Use ILIKE for case-insensitive search, not LOWER(col) LIKEhigh-explicit-cast — Cast types explicitly (::uuid, ::bigint) to avoid operator does not existmedium-cte-readability — Use CTEs instead of nested subqueries for complex queriesmedium-jsonb-operators — Use correct @>, ->>, -> operators for JSONB queriesmedium-interval-arithmetic — Use INTERVAL for date math, not manual second calculationsmedium-select-redundancy — Don't manually quote plain column names in .Select() (GORM handles it)Two rules in this skill directly extend rules from the companion database-repository skill in golang-best-practices-skill:
| This skill | golang-best-practices-skill | Relationship |
|---|---|---|
high-identifier-quoting | high-gorm-identifier-quoting | Expanded — more Postgres examples, full reserved word list |
medium-select-redundancy | medium-gorm-select-redundancy | Mirror — same rule, cross-referenced |