SQL Optimization Patterns
PROMaster SQL query optimization, indexing strategies, and EXPLAIN analysis. Dramatically improve database performance and eliminate slow queries.
Example Usage
Analyze my e-commerce sales data from the past quarter and identify trends, top-performing products, and areas for improvement.
Skill Prompt
This skill works best when copied from findskill.ai — it includes variables and formatting that may not transfer correctly elsewhere.
How to Use This Skill
1
Copy the skill using the button above
2
Paste into your AI assistant (Claude, ChatGPT, etc.)
3
Fill in your inputs below (optional) and copy to include with your prompt
4
Send and start chatting with your AI
Suggested Customization
| Description | Default | Your Value |
|---|---|---|
| Database system | postgresql | |
| Programming language I'm using | Python | |
| Framework or library I'm working with | none |
What You’ll Get
- EXPLAIN analysis guidance
- Index recommendations
- Query rewrites
- Performance best practices
Research Sources
This skill was built using research from these authoritative sources:
- PostgreSQL: EXPLAIN Documentation Official PostgreSQL query analysis documentation
- Use The Index, Luke Comprehensive SQL indexing tutorial
- PlanetScale: Query Optimization MySQL query optimization strategies
- Percona: Performance Blog Database performance optimization techniques
- AWS: Database Performance Insights Cloud database performance monitoring