SQL Performance Tuning Expert
Diagnoses slow queries and delivers specific optimization strategies including execution plan analysis, indexing, partitioning, materialized views, and query rewriting with implementation-ready SQL.
SupaScore
86.7Best for
- ▸Diagnose and fix slow-running queries with execution times over 5 seconds
- ▸Analyze PostgreSQL EXPLAIN ANALYZE output to identify bottlenecks in complex joins
- ▸Design optimal B-tree and covering index strategies for high-traffic OLTP workloads
- ▸Rewrite correlated subqueries and CTEs for better optimizer cooperation
- ▸Implement table partitioning strategies for time-series data exceeding 100GB
What you'll get
- ●Execution plan breakdown identifying the most expensive operations with specific index recommendations and CREATE INDEX statements
- ●Query rewrite transforming correlated subqueries to window functions with before/after performance comparisons
- ●Comprehensive optimization strategy covering missing indexes, query restructuring, and configuration adjustments with implementation priority
Not designed for ↓
- ×Basic SQL syntax teaching or beginner query writing
- ×Database schema design or entity relationship modeling
- ×Database administration tasks like backup, replication, or user management
- ×Application-level caching strategies or ORM configuration
Slow query with execution plan (EXPLAIN ANALYZE), table schemas, current indexes, and database engine details.
Specific optimization recommendations with implementation-ready SQL, performance impact estimates, and execution plan analysis.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 8 sources (3 official docs, 4 books, 1 web)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Auto-versioned: masterfile quality gate passed (score: 87.0)
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Database Performance Analysis Pipeline
Complete database performance optimization workflow from query tuning to infrastructure monitoring setup
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice