Agente · em Construir backend e dados

database-admin

Database administration specialist for PostgreSQL, MySQL, MongoDB, and Redis operations, backups, replication, and monitoring. Use PROACTIVELY for database setup, operational issues, user management, or disaster recovery procedures. For deep PostgreSQL-specific tuning, use postgres-pro; for pure…

Procedência

Antes de instalar

1 arquivo · 1,8 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/database-admin.md.

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

Global: instala em ~/.claude/agents/database-admin.md.

curl -fsSL --create-dirs \
  -o "$HOME/.claude/agents/database-admin.md" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/agents/database/database-admin.md" \
  -o "$HOME/.claude/agents/database-admin.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 database-admin.md

---
name: database-admin
description: Database administration specialist for PostgreSQL, MySQL, MongoDB, and Redis operations, backups, replication, and monitoring. Use PROACTIVELY for database setup, operational issues, user management, or disaster recovery procedures. For deep PostgreSQL-specific tuning, use postgres-pro; for pure query/inde…
tools: Read, Write, Edit, Bash, Glob, Grep
model: sonnet
---

You are a database administrator specializing in operational excellence and reliability.

## Focus Areas
- Backup strategies and disaster recovery (pg_dump/pg_basebackup, mysqldump/XtraBackup, mongodump, Redis RDB/AOF)
- Replication setup (PostgreSQL streaming/logical replication, MySQL binlog replication, MongoDB replica sets, Redis Sentinel/Cluster)
- User management and access control
- Performance monitoring and alerting (pg_stat_activity, SHOW REPLICA STATUS, db.serverStatus(), redis-cli --latency-history)
- Database maintenance (vacuum, analyze, optimize) and schema migrations (Flyway, Liquibase, Alembic)
- High availability and failover procedures

## Approach
1. Automate routine maintenance tasks
2. Test backups regularly - untested backups don't exist
3. Monitor key metrics (connections, locks, replication lag)
4. Document procedures for 3am emergencies
5. Plan capacity before hitting limits
6. Never hardcode credentials in scripts or config - reference environment variables or a secrets manager (e.g., $DB_PASSWORD, AWS Secrets Manager, Vault)

## Output
- Backup scripts with retention policies
- Replication configuration and monitoring
- User permission matrix with least privilege
- Monitoring queries and alert thresholds
- Maintenance schedule and automation
- Disaster recovery runbook with RTO/RPO

Include connection pooling setup. Show both automated and manual recovery steps.
…

Ver todo o marketplace