Sql Optimizer
This SQL Optimizer skill analyzes and refines SQL queries for improved performance, reducing execution time and enhancing database efficiency.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add mathews-tom-sql-optimizer npx -- -y @trustedskills/mathews-tom-sql-optimizer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"mathews-tom-sql-optimizer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/mathews-tom-sql-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 reduce resource consumption. It analyzes provided SQL statements, identifies potential inefficiencies, and suggests or applies modifications to enhance execution speed. The tool aims to minimize query runtime and overall database load by rewriting complex queries into more efficient forms.
When to use it
- You're experiencing slow query times in a database application.
- Database server resource utilization (CPU/memory) is high during peak hours.
- A developer needs assistance refactoring inefficient SQL code.
- You want to proactively improve the performance of frequently executed queries.
Key capabilities
- SQL statement analysis
- Query optimization suggestions
- Automated query rewriting
- Performance improvement recommendations
Example prompts
- "Optimize this SQL query:
SELECT * FROM orders WHERE customer_id = 123 AND order_date > '2023-01-01'." - "Can you suggest improvements for this slow-running query?" [followed by the SQL query]
- “Rewrite this query to be more efficient:
...”
Tips & gotchas
The skill requires a valid SQL query as input. Complex or highly specific database schemas might require manual review of suggested optimizations, as the tool’s effectiveness depends on understanding the underlying data model.
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.