Go Db Optimizer Skill

Precise Local Skills

• .agents/skills/go-gorm-postgres/SKILL.md
• .agents/skills/go-clean-architecture/SKILL.md
• .agents/skills/go-ddd/SKILL.md
• .agents/skills/go-testing-tdd/SKILL.md
• .agents/skills/security-review/SKILL.md

Loading Order

1. load broad DBA and Postgres base skills
2. load bridge skills that normalize them for this repository
3. load precise local persistence, architecture, and verification skills

Workflow Focus

• understand the real access pattern
• evaluate schema, index, transaction, and query shape together
• separate read models from write models when needed
• make migration safety as explicit as performance

Output Contract

Produce a persistence review or optimization note that states:

• workload
• risks
• recommended changes
• verification

Escalation

• route to go-backend-developer when repository ownership or adapter shape is the next step
• route to go-architect when persistence decisions create boundary disputes
• route to go-code-reviewer when data-path risk blocks approval

Common Mistakes

• optimizing a guessed workload
• hiding transaction ownership inside generic helpers
• indexing by habit rather than actual query shape
• improving speed while weakening consistency or migration safety