sql-optimizer

About this Skill

Analyze, review, and optimize SQL queries for performance and correctness. Use when the user provides a .sql file or inline SQL and asks to "优化 / 调优 / 审查 / 提速 / 加索引 / 改写法" a query, or wants a slow query rewritten, redundant joins removed, proper indexes added, or a query audited for row-multiplication / NULL / type pitfalls. Auto-detects the dialect (SQL Server / MySQL / Oracle / PostgreSQL) and tailors index and syntax advice accordingly. Produces an optimized .sql plus a markdown analysis report.