Sql Optimization Patterns
Helps with optimization, patterns 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 hermeticormus-sql-optimization-patterns npx -- -y @trustedskills/hermeticormus-sql-optimization-patterns
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"hermeticormus-sql-optimization-patterns": {
"command": "npx",
"args": [
"-y",
"@trustedskills/hermeticormus-sql-optimization-patterns"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides access to a collection of SQL optimization patterns. It can analyze inefficient SQL queries and suggest improvements using established techniques like indexing, query rewriting, and avoiding full table scans. The goal is to enhance database performance and reduce execution times for complex queries.
When to use it
- Slow Query Analysis: When you have identified specific SQL queries that are taking an unacceptably long time to execute.
- Database Performance Tuning: As part of a broader effort to improve the overall responsiveness of your database system.
- Complex Reporting: To optimize queries used for generating reports or dashboards, ensuring timely data delivery.
- High-Traffic Applications: In applications experiencing high query loads where even small performance gains can have significant impact.
Key capabilities
- SQL Query Analysis
- Indexing Recommendations
- Query Rewriting Suggestions
- Full Table Scan Avoidance Techniques
Example prompts
- "Analyze this SQL query:
SELECT * FROM orders WHERE customer_id = 123;and suggest optimizations." - "I'm seeing slow performance on a report. The query is:
...long query string.... Can you help me optimize it?" - "Suggest ways to avoid full table scans in this query:
SELECT ... FROM users WHERE ..."
Tips & gotchas
This skill requires access to the SQL query being analyzed. Be prepared to provide complete and accurate query text for optimal results.
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.