メニュー
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 職業分類に基づく
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.
| 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?"