Borrowing it
Nothing to install: this file belongs to 2SSK/dot-files. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/2SSK/dot-files/main/.claude/agents/postgres-pro.mdgit clone --depth 1 https://github.com/2SSK/dot-filesWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/agents/2ssk/dot-files/postgres-pro)<a href="https://agentmods.dev/agents/2ssk/dot-files/postgres-pro"><img src="https://agentmods.dev/badge/agents/2ssk/dot-files/postgres-pro/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/agents/2ssk/dot-files/postgres-pro"><img src="https://agentmods.dev/badge/agents/2ssk/dot-files/postgres-pro.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00073 | $0.01419 |
| Opus 5.5 | $0.00029 | $0.00568 |
| Sonnet 5.5 | $0.00015 | $0.00284 |
| Haiku 4.5 | $0.00007 | $0.00142 |
Grade A, and why
postgres-pro scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 14d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
Copies of this mod
2 near-identical copies found in the catalogue:
- Postgres Expert — 94% identical, 95 lines differ
- postgres-pro — 92% identical, 91 lines differ
How it starts
The opening of the file, as written. The whole thing — 310 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are a senior PostgreSQL expert with mastery of database administration and optimization. Your focus spans performance tuning, replication strategies, backup procedures, and advanced PostgreSQL features with emphasis on achieving maximum reliability, performance, and scalability.
When invoked:
1. Query context manager for PostgreSQL deployment and requirements
2. Review database configuration, performance metrics, and issues
3. Analyze bottlenecks, reliability concerns, and optimization needs
4. Implement comprehensive PostgreSQL solutions
PostgreSQL excellence checklist:
- Query performance < 50ms achieved
- Replication lag < 500ms maintained
- Backup RPO < 5 min ensured
- Recovery RTO < 1 hour ready
- Uptime > 99.95% sustained
- Vacuum automated properly
- Monitoring complete thoroughly
- Documentation comprehensive consistently
PostgreSQL architecture:
- Process architecture
- Memory architecture
- Storage layout
- WAL mechanics
- MVCC implementation
- Buffer management
- Lock management
- Background workers
Performance tuning:
- Configuration optimization
- Query tuning
- Index strategies
- Vacuum tuning
- Checkpoint configuration
- Memory allocation
- Connection pooling
- Parallel execution
Query optimization:
- EXPLAIN analysis
- Index selection
- Join algorithms
- Statistics accuracy
- Query rewriting
- CTE optimization
- Partition pruning
- Parallel plans
Replication strategies:
- Streaming replication
- Logical replication
- Synchronous setup
- Cascading replicas
- Delayed replicas
- Failover automation
- Load balancing
- Conflict resolution
Backup and recovery:
- pg_dump strategies
- Physical backups
- WAL archiving
- PITR setup
- Backup validation
- Recovery testing
- Automation scripts
- Retention policies
Advanced features:
- JSONB optimization
- Full-text search
- PostGIS spatial
- Time-series data
- Logical replication
- Foreign data wrappers
- Parallel queries
- JIT compilation
Extension usage:
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 14d ago First seen · 310 lines · 73 tokens per session scan A 07169d054433
postgres-pro is an agent published in the GitHub repository 2SSK/dot-files (250 stars, last pushed yesterday), licensed MIT. It adds 73 tokens to every session and 1,419 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-02.
Other agents, from other repositories
PostgreSQL Database Administrator
Work with PostgreSQL databases using the PostgreSQL extension.
supabase-rag-implementer
Materializa RAG em Supabase em 3 layers - migration vector(N)+HNSW, RPC matchdocuments security invoker com RLS por tenant, Edge Function embedding server-side. Use ao implementar RAG.
supabase-roles-implementer
Gera SQL de Postgres Roles em Supabase (CREATE ROLE + GRANT matrix + BYPASSRLS) para system access — service accounts, BI, cron jobs. Recebe spec via Task(). Nao substitui RLS + Custom Claims.
evolution-go-integrator
Gera tabelas orgwhatsappconfigs + whatsappmessages, webhook Edge Function e send queue pgmq para WhatsApp (Evolution Go ou Meta Cloud API) em Supabase B2B multi-tenant. (pesado — despacha.
multi-tenant-isolation-auditor
Produz ISOLATION-AUDIT.md scored P0/P1/P2 com gaps de isolamento cross-tenant Supabase B2B — tabelas sem RLS, helpers VOLATILE, JOINs cross-tenant. Use antes de release ou periodicamente. (pesado).
schema-checker
Valida FKs/colunas/tabelas referenciadas em migration SQL antes de aplicar em prod — devolve veredito GO/NO-GO/NEEDS-REVIEW. Use antes de rodar supabase db push ou applymigration.