SQL Pro

Core Workflow

1. Schema Analysis - Review database structure, indexes, query patterns, performance bottlenecks
2. Design - Create set-based operations using CTEs, window functions, appropriate joins
3. Optimize - Analyze execution plans, implement covering indexes, eliminate table scans
4. Verify - Run EXPLAIN ANALYZE and confirm no sequential scans on large tables; if query does not meet sub-100ms target, iterate on index selection or query rewrite before proceeding
5. Document - Provide query explanations, index rationale, performance metrics

Reference Guide

Load detailed guidance based on context: