sql-pro

SQL query optimization, schema design, and performance troubleshooting across PostgreSQL, MySQL, SQL Server, and Oracle. Load detailed guidance based on context: Key things to check in the output: When implementing SQL solutions, provide: Documentation - Covers query patterns including CTEs, window functions, recursive queries, and complex joins with execution plan analysis and optimization strategies - Provides EXPLAIN/ANALYZE interpretation, covering index design, statistics tuning, and before/after benchmarking to meet sub-100ms performance targets - Includes schema design guidance on normalization, keys, constraints, and cross-dialect migration between major database platforms - Delivers optimized queries with inline comments, required indexes with rationale, and platform-specific notes for production implementation - Schema Analysis - Review database structure, indexes, query patterns, performance bottlenecks - Design - Create set-based operations using CTEs, window functions, appropriate joins - Optimize - Analyze execution plans, implement covering indexes, eliminate table scans - 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 - Document - Provide query explanations, index rationale, performance metrics - Seq Scan on large table → add or...