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 jeremylongshore-sql-query-optimizer npx -- -y @trustedskills/jeremylongshore-sql-query-optimizer
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"jeremylongshore-sql-query-optimizer": {
"command": "npx",
"args": [
"-y",
"@trustedskills/jeremylongshore-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 existing SQL code, identifies potential bottlenecks, and suggests modifications such as index creation or query restructuring. The goal is to reduce execution time and resource consumption for database operations.
When to use it
- Slow Query Performance: When a specific SQL query takes an unacceptably long time to execute.
- High Database Load: To alleviate strain on the database server by optimizing frequently run queries.
- Complex Joins: When dealing with complex joins across multiple tables that are impacting performance.
- Large Datasets: When querying large datasets where optimization can significantly reduce processing time.
Key capabilities
- SQL query analysis
- Performance bottleneck identification
- Index suggestion
- Query restructuring recommendations
Example prompts
- "Optimize this SQL query:
SELECT * FROM orders WHERE customer_id = 123;" - "Can you suggest ways to improve the performance of this stored procedure?"
- "Analyze this query and recommend indexes that would speed it up:
...complex query..."
Tips & gotchas
The skill requires access to the SQL query for analysis. It's best suited for standard SQL dialects; proprietary extensions might not be fully supported.
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.