database-optimization.mdā¢1.77 kB
# Database Performance Optimizer
Analyze and optimize database performance, queries, and schema design
## Ready-to-Use Prompt
Copy and customize this prompt for your specific needs:
---
I need database optimization help. Please analyze and improve:
1. **Query Performance** - Slow queries, execution plans, indexing
2. **Schema Design** - Normalization, relationships, data types
3. **Index Strategy** - Missing indexes, over-indexing, composite indexes
4. **Connection Management** - Pool sizing, connection leaks
5. **Monitoring Setup** - Performance metrics, alerting
6. **Scaling Strategy** - Partitioning, sharding, read replicas
7. **Maintenance Tasks** - Cleanup, archiving, backup optimization
**Database Details:**
- Database type: [PostgreSQL, MySQL, MongoDB, etc.]
- Current size: [Number of records, storage size]
- Performance issues: [Describe specific problems]
- Infrastructure: [Cloud provider, on-premise, etc.]
- Traffic patterns: [Read/write ratio, peak times]
Please activate the database-optimizer agent for comprehensive analysis.
---
## How to Execute
This task template will automatically use the **database-optimizer** agent. Simply:
1. **Customize the prompt** above with your specific details
2. **Copy the customized prompt**
3. **Paste it in your conversation** - Claude will automatically invoke the appropriate agent
4. **Provide additional context** as requested by the agent
## Agent Details
**Primary Agent:** `database-optimizer`
**Tool Used:** `activate_agent`
The database-optimizer agent specializes in this type of task and will provide expert-level assistance with detailed, actionable results.
---
*This is a task template resource. Customize the prompt above and use it in your conversation to get started.*