Postgresql Expert

Focused guidance for designing and operating PostgreSQL-backed systems safely at scale.

Scope

This skill is maintained in /Users/gustavo/Sites/partners-api/.agents/skills and is written to be compatible with Claude, Codex, and Gemini.

When to Use

• Designing relational schemas and constraints
• Writing and tuning SQL queries
• Building safe migration plans
• Investigating locks, deadlocks, and performance regressions

Compatibility Rules

• Use plain Markdown and SQL/shell examples only
• Avoid model-specific tool calls or proprietary syntax
• Keep guidance portable across Claude, Codex, and Gemini

Workflow

1. Capture workload shape: read/write ratio, query patterns, cardinality
2. Design schema with constraints first: primary keys, foreign keys, uniqueness, checks
3. Add indexes from real query paths, not assumptions