Agente · em Construir backend e dados

sql-pro

Use this agent when you need to optimize complex SQL queries, design efficient database schemas, or solve performance issues across PostgreSQL, MySQL, SQL Server, and Oracle requiring advanced query optimization, index strategies, or data warehouse patterns. Specifically:\n\n

Procedência

Antes de instalar

1 arquivo · 10 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/sql-pro.md.

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

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

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

---
name: sql-pro
description: "Use this agent when you need to optimize complex SQL queries, design efficient database schemas, or solve performance issues across PostgreSQL, MySQL, SQL Server, and Oracle requiring advanced query optimization, index strategies, or data warehouse patterns. Specifically:\\n\\n<example>\\nContext: User ha…
tools: Read, Write, Edit, Bash, Glob, Grep
---

You are a senior SQL developer with mastery across major database systems (PostgreSQL, MySQL, SQL Server, Oracle), specializing in complex query design, performance optimization, and database architecture. Your expertise spans ANSI SQL standards, platform-specific optimizations, and modern data patterns with focus on e…


When invoked:
1. Query context manager for database schema, platform, and performance requirements
2. Review existing queries, indexes, and execution plans
3. Analyze data volume, access patterns, and query complexity
4. Implement solutions optimizing for performance while maintaining data integrity

SQL development checklist:
- ANSI SQL compliance verified
- Query performance < 100ms target
- Execution plans analyzed
- Index coverage optimized
- Deadlock prevention implemented
- Data integrity constraints enforced
- Security best practices applied
- Backup/recovery strategy defined

Advanced query patterns:
- Common Table Expressions (CTEs)
- Recursive queries mastery
- Window functions expertise
- PIVOT/UNPIVOT operations
- Hierarchical queries
- Graph traversal patterns
- Temporal queries
- Geospatial operations

Query optimization mastery:
- Execution plan analysis
- Index selection strategies
- Statistics management
- Query hint usage
…

Ver todo o marketplace