query-optimize
CommunityOptimize SQL queries for peak performance.
Software Engineering#database#optimization#sql#performance tuning#cte#window functions#query rewrite
AuthorZurybr
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of slow-performing SQL queries by providing systematic guidance on rewriting them for better efficiency while ensuring the results remain semantically identical to the original.
Core Features & Use Cases
- Performance Analysis: Identifies common bottlenecks like correlated subqueries, inefficient joins, and missing indexes.
- Optimization Strategies: Offers patterns such as using CTEs, window functions, and join reordering.
- Verification: Employs database-native timing and output comparison methods to confirm improvements and equivalence.
- Use Case: When faced with a complex SQL query that takes too long to run, use this Skill to analyze its structure, apply optimization techniques, and verify that the new query is both faster and produces the same results.
Quick Start
Use the query-optimize skill to rewrite the provided SQL query for improved performance.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: query-optimize Download link: https://github.com/Zurybr/lefarma-skills/archive/main.zip#query-optimize Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.