Database Optimization
Helps with database, optimization as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add doanchienthangdev-database-optimization npx -- -y @trustedskills/doanchienthangdev-database-optimization
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"doanchienthangdev-database-optimization": {
"command": "npx",
"args": [
"-y",
"@trustedskills/doanchienthangdev-database-optimization"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill optimizes database performance. It analyzes query execution plans, identifies bottlenecks like missing indexes or inefficient joins, and suggests improvements to enhance overall database speed and efficiency. The agent can also help with tasks such as index creation and table restructuring based on identified issues.
When to use it
- Slow Query Performance: When users report that queries are taking too long to execute.
- High Database Load: When the database server is consistently experiencing high CPU or I/O utilization.
- Database Maintenance Tasks: As part of a regular schedule for proactive performance tuning.
- After Data Volume Increase: To ensure performance doesn't degrade after significant data growth.
Key capabilities
- Query execution plan analysis
- Index suggestion and creation
- Table restructuring recommendations
- Bottleneck identification (e.g., inefficient joins)
Example prompts
- "Analyze the query execution plan for this SQL statement: [SQL Query]"
- "Suggest indexes to improve performance of the 'orders' table."
- "Identify bottlenecks in our database that are causing slow response times."
Tips & gotchas
The agent requires access to the database schema and ideally, read-only permissions to execute queries. Be sure to specify the database type (e.g., MySQL, PostgreSQL) for accurate analysis and recommendations.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.