Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Initial release of sql-pro: a specialist skill for advanced SQL and database optimization tasks. - Senior SQL developer persona with expertise in query optimization, schema design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. - Supports complex query patterns (CTEs, window functions, recursive queries) and advanced indexing strategies. - Workflow covers schema analysis, design, optimization, verification, and documentation. - Includes a detailed reference guide and strict best practices (must-do and must-not-do constraints). - Outputs include optimized queries, recommended indexes, execution plan analysis, performance metrics, and platform-specific notes.