Sql Optimization Patterns
ListedHelps with optimization, patterns as part of working with databases and data persistence workflows.
Install on your platform
sql-optimization-patterns. aaaaqwq/agi-super-team has no skill named "sql-optimization-patterns" any more. It was renamed, moved or deleted upstream.We check each listing against its upstream repository with the rules the skills CLI uses, last on 2026-10-30. We don't show a command we know will fail.
What we know about this skill
Publisher
aaaaqwq
Taken from the source listing. We haven't verified who controls this account.
Install target
Live repository
Not pinned. Installing fetches whatever the repository holds at the time you run the command.
Automated safety checks
We could not read this skill's source, so none of the checks below were run.
About this skill
What it does
This skill provides AI agents with the ability to identify and suggest SQL optimization patterns. It can analyze existing queries, pinpoint performance bottlenecks, and recommend improvements such as indexing strategies, query rewriting, or data type adjustments. The goal is to enhance database query efficiency and reduce execution time.
When to use it
- Slow Query Analysis: When a specific SQL query takes an unexpectedly long time to execute.
- Database Performance Tuning: As part of regular maintenance to proactively improve overall database performance.
- Query Optimization Recommendations: To get suggestions for improving the efficiency of complex or frequently executed queries.
- Identifying Indexing Opportunities: To discover missing indexes that could significantly speed up query execution.
Key capabilities
- SQL Query Analysis
- Performance Bottleneck Identification
- Indexing Strategy Suggestions
- Query Rewriting Recommendations
- Data Type Adjustment Proposals
Example prompts
- "Analyze this SQL query:
SELECT * FROM orders WHERE customer_id = 123;and suggest optimizations." - "I have a slow-running report. Can you identify potential SQL optimization patterns?"
- "Suggest indexes for the following table schema: [table schema details]"
Tips & gotchas
The skill's effectiveness depends on providing accurate and complete SQL query information, including table schemas when possible. It is not a replacement for thorough database administration but can be a valuable tool for identifying common optimization opportunities.