메뉴
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.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | golang-fullstack-best-practices |
| description | 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. |
| license | MIT |
| metadata | {"author":"saifoelloh","version":"3.0.0","skill_type":"meta","sub_skills":["concurrency-safety","clean-architecture","design-patterns","idiomatic-go","error-handling","gorm-query-patterns","postgresql-syntax","query-performance","migration-safety"],"last_updated":"2026-03-13"} |
Comprehensive code review skill coordinating 9 specialized domain skills for Go backend services using GORM with PostgreSQL.
v3.0.0: The "Ultimate Merger" release. Unified 89 rules across Go language and Database layers.
| Priority | Count | Focus |
|---|---|---|
| CRITICAL | 20 | Bugs, crashes, data loss, SQL injection |
| HIGH | 30 | Reliability, performance, architecture |
| MEDIUM | 34 | Quality, idioms, maintainability |
| ARCH | 5 | Clean Architecture compliance |
| TOTAL | 89 |
- Concurrency/Channels/Goroutines → concurrency-safety
- Layers/gRPC/Usecases/Dipendencies → clean-architecture
- Complex logic/Refactoring/Code smells → design-patterns
- Pointer usage/Interfaces/Idioms → idiomatic-go
- DB Errors/Postgres codes/errors.Is/As → error-handling
- GORM queries/db.Find/Transactions → gorm-query-patterns
- Raw SQL/Pg-specific functions/Syntax → postgresql-syntax
- Slow queries/Indexes/N+1/Pool → query-performance
- ALTER TABLE/AutoMigrate/Rollback → migration-safety
- Full Audit → all 9 skills
"Review this Go service for all language and database best practices"
"Audit this repository file for GORM query performance and N+1 issues" "Review these goroutines for race conditions and context leaks" "Is this database migration safe for production?"
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.
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.
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.