
Postgres
Persona
Planner behavior with statistics, cardinality, and index selectivity — Postgres queries that the planner executes efficiently at scale.
About
Most postgres work breaks on exactly the cases teams skip until production: planner behavior with statistics, cardinality, and index selectivity, and lock modes, transaction isolation, and deadlock/contention risk.
What Postgres does:
- planner behavior with statistics, cardinality, and index selectivity
- lock modes, transaction isolation, and deadlock/contention risk
- index design including btree/gin/gist/brin suitability tradeoffs
- schema evolution and migration/backfill safety on large tables
- vacuum/analyze/autovacuum implications for long-term performance
- partitioning and retention strategies where workload scale justifies it
- replication and failover considerations for operational safety
What you get:
SOUL.md— Postgres's identity and working methodologypostgres-expert.md— the full persona instruction fileMEMORY.md— session-persistent context template
Install:
# 1. Place in your project
cp postgres-expert.md .claude/personas/POSTGRES.md
# 2. Add to CLAUDE.md
echo "## Active Persona\nPostgres handles postgres work. See: .claude/personas/POSTGRES.md" >> CLAUDE.md
# 3. Call by name in Claude Code
# Postgres, [your task here]
Postgres maps the problem space before writing a line, validates success and failure paths, and reports residual risk honestly. Use it when production discipline matters more than speed.
Core Capabilities
- planner behavior with statistics, cardinality, and index selectivity
- lock modes, transaction isolation, and deadlock/contention risk
- index design including btree/gin/gist/brin suitability tradeoffs
- schema evolution and migration/backfill safety on large tables
- vacuum/analyze/autovacuum implications for long-term performance
- partitioning and retention strategies where workload scale justifies it
- replication and failover considerations for operational safety
Customer ratings
0 reviews
No ratings yet
- 5 star0
- 4 star0
- 3 star0
- 2 star0
- 1 star0
No reviews yet. Be the first buyer to share feedback.
Version History
This persona is actively maintained.
March 26, 2026
v1.0.0 — Initial release
One-time purchase
$49
By continuing, you agree to the Buyer Terms of Service.
Creator
iceboks
Creator
Software engineer building production AI tools. Skills and personas for engineering, DevOps, and executive leadership. Free skills that actually work. Paid personas with real decision frameworks and three-tier memory. Our agents include setup scripts and instructions on how to install. I'm always open to feed back for improvements or feature requests
View creator profile →Details
- Type
- Persona
- Category
- Engineering
- Price
- $49
- Version
- 1
- License
- One-time purchase
Works With
Works with OpenClaw, Claude Projects, Custom GPTs and other instruction-friendly AI tools.
Recommended Skills
Skills that complement this persona.
Multi-AI Critique with Memory
Engineering
The code review that argues with you, and remembers. Two AI reviewers on different models, semantic vector memory, three protocols. A few cents a review.
$19
Agent API Key Security
Engineering
Stop your agent leaking API keys and secrets
$9
Agent Autonomy Preflight
Engineering
Make an unattended agent safe to leave alone
$19