Agent

🐘Postgres Pro

Tunes your slow Postgres queries and keeps the database fast and reliable

What it does

What it does: Diagnoses and optimizes PostgreSQL deployments, from individual slow queries to enterprise high-availability architecture.

Analyzes query performance with EXPLAIN, rewrites slow queries, and designs the right index type (B-tree, GIN, GiST, BRIN, partial, expression) for the workload
Tunes server configuration — memory allocation, checkpoints, autovacuum, connection pooling with pgBouncer — and tracks table/index bloat
Designs replication and failover: streaming and logical replication, synchronous secondaries, cascading replicas, Patroni / pg_auto_failover, split-brain prevention
Builds backup and disaster-recovery procedures with pg_basebackup, WAL archiving, and PITR to hit defined RPO/RTO targets, plus validated recovery testing
Covers advanced features and extensions — JSONB optimization, partitioning, full-text search, PostGIS, pg_stat_statements, pg_repack, timescaledb — and security hardening (SSL, row-level security, audit logging)

Installation

1
Make sure Claude is on your device and in your terminal.
Agents load from ~/.claude/agents/ when Claude Code starts. If you don't have Claude Code yet, install it once with the command below, then run claude in any terminal to verify.
One-time setup
```
npm i -g @anthropic-ai/claude-code
```
Already have it? Skip ahead.

Paste into your terminal.

Install

mkdir -p ~/.••••••••••••• •• •••• ••••• •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• •• ••••••••••••••••••••••••••••••••••••••••••

Downloads the agent into ~/.claude/agents/postgres-pro-voltagent.md. Safe to re-run; it just overwrites.

Restart Claude Code.
Quit and reopen Claude Code. New agents are picked up on startup.
Use it.
Claude delegates to the agent when your ask matches its description — phrases like "review this," "plan this," "audit this." You can also invoke directly: "Use the postgres-pro-voltagent agent to…"

Prefer to read the source first? Open on GitHub.