Agente · em Construir backend e dados

postgres-pro

Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Invoke this agent for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise…

Procedência

Antes de instalar

1 arquivo · 9,2 KB · só texto, nenhum script

Instalar na sua CLI

O comando baixa a versão fixada (commit 57f899e) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.

Claude Code

Neste projeto: instala em .claude/agents/postgres-pro.md.

curl -fsSL --create-dirs \
  -o ".claude/agents/postgres-pro.md" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/agents/database/postgres-pro.md" \
  -o ".claude/agents/postgres-pro.LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.claude/agents/postgres-pro.md.

curl -fsSL --create-dirs \
  -o "$HOME/.claude/agents/postgres-pro.md" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/agents/database/postgres-pro.md" \
  -o "$HOME/.claude/agents/postgres-pro.LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Codex

Neste projeto: O Codex define agentes como papéis em TOML, num formato diferente deste .md; ele não instala como está.

Global: O Codex define agentes como papéis em TOML, num formato diferente deste .md; ele não instala como está.

Antigravity

Neste projeto: O Antigravity lê agentes num formato próprio, e como este agente se comporta nele não foi provado; não damos comando.

Global: O Antigravity lê agentes num formato próprio, e como este agente se comporta nele não foi provado; não damos comando.

Prévia do postgres-pro.md

---
name: postgres-pro
description: "Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Invoke this agent for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise deployments.…
tools: Read, Write, Edit, Bash, Glob, Grep
---

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
…

Ver todo o marketplace