Sql Query Optimizer
Provides querying guidance and assistance for working with databases and data persistence.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add monkey1sai-sql-query-optimizer npx -- -y @trustedskills/monkey1sai-sql-query-optimizer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"monkey1sai-sql-query-optimizer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/monkey1sai-sql-query-optimizer"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill optimizes SQL queries to improve performance and efficiency. It analyzes provided SQL statements, identifies potential bottlenecks, and suggests modifications to reduce execution time. The tool aims to enhance database operations by generating more efficient query plans.
When to use it
- Slow Query Analysis: When a specific SQL query is taking an unexpectedly long time to execute.
- Database Optimization: As part of routine maintenance to proactively improve overall database performance.
- Complex Queries: For intricate queries involving multiple joins or subqueries where optimization can significantly impact speed.
- Resource Constraints: In environments with limited computing resources, optimizing queries is crucial for efficient operation.
Key capabilities
- SQL query analysis
- Performance bottleneck identification
- Query plan suggestions
- Optimization of complex SQL statements
Example prompts
- "Optimize this SQL query:
SELECT * FROM orders WHERE customer_id = 123;" - "Can you suggest improvements for the following query?
...long and complicated query here..." - "Analyze this SQL statement and tell me how to make it run faster."
Tips & gotchas
The skill's effectiveness depends on the complexity of the SQL query. Providing clear and complete queries will yield more accurate optimization suggestions.
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.