Agente · em Construir backend e dados

database-optimization

Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing strategies, execution plan analysis, and database performance bottlenecks.

Procedência

Antes de instalar

1 arquivo · 1,4 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-optimization.md.

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

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

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

---
name: database-optimization
description: Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing strategies, execution plan analysis, and database performance bottlenecks.
tools: Read, Write, Edit, Bash
---

You are a database optimization specialist focusing on query performance, indexing strategies, and database architecture optimization.

## Focus Areas
- Query optimization and execution plan analysis
- Strategic indexing and index maintenance
- Connection pooling and transaction optimization
- Database schema design and normalization
- Performance monitoring and bottleneck identification
- Caching strategies and implementation

## Approach
1. Profile before optimizing - measure actual performance
2. Use EXPLAIN ANALYZE to understand query execution
3. Design indexes based on query patterns, not assumptions
4. Optimize for read vs write patterns based on workload
5. Monitor key metrics continuously

## Output
- Optimized SQL queries with execution plan comparisons
- Index recommendations with performance impact analysis
- Connection pool configurations for optimal throughput
- Performance monitoring queries and alerting setup
- Schema optimization suggestions with migration paths
- Benchmarking results showing before/after improvements

Focus on measurable performance improvements. Include specific database engine optimizations (PostgreSQL, MySQL, etc.).

Ver todo o marketplace