Database Optimizer
Optimizes Alexander Danilenko's databases for speed and efficiency through automated indexing and query tuning.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add alexander-danilenko-database-optimizer npx -- -y @trustedskills/alexander-danilenko-database-optimizer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"alexander-danilenko-database-optimizer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/alexander-danilenko-database-optimizer"
]
}
}
}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 such as missing indexes or inefficient joins, and suggests specific SQL modifications to improve speed and resource utilization. The tool aims to reduce query latency and overall database load for improved application responsiveness.
When to use it
- Slow Queries: When users report slow loading times for reports or dashboards that rely on complex database queries.
- High Database Load: When server monitoring indicates consistently high CPU or I/O usage by the database server.
- Performance Tuning: As part of a proactive effort to regularly optimize database performance and prevent future slowdowns.
- Post-Deployment Optimization: After deploying new features or data models that may impact existing query performance.
Key capabilities
- Query plan analysis
- Bottleneck identification (missing indexes, inefficient joins)
- SQL modification suggestions
- Performance improvement recommendations
Example prompts
- "Analyze the execution plan for this SQL query:
SELECT ... FROM ... WHERE ...and suggest optimizations." - "My database is running slowly. Can you identify any performance bottlenecks?"
- "Suggest indexes to improve the performance of queries against the 'orders' table."
Tips & gotchas
The skill’s suggestions should be reviewed by a database administrator before implementation, as incorrect modifications can negatively impact data integrity or introduce new issues. Understanding basic SQL and database concepts is helpful for interpreting the 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.