{"skill":{"slug":"skylv-database-query-helper","displayName":"Skylv Database Query Helper","summary":"SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization.","description":"---\nname: skylv-sql-helper\nslug: skylv-sql-helper\nversion: 1.0.0\ndescription: \"SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization.\"\nauthor: SKY-lv\nlicense: MIT\ntags: [automation, tools]\nkeywords: [automation, tools]\ntriggers: sql-helper\n---\n\n# SQL Helper\n\n## Overview\nHelps write, optimize, and debug SQL queries.\n\n## When to Use\n- User asks to \"write a SQL query\" or \"optimize this query\"\n- Debugging slow database operations\n\n## Pagination\nSELECT * FROM users ORDER BY id LIMIT 20 OFFSET 40;\n\n## Join with Aggregation\nSELECT u.name, COUNT(o.id) as order_count\nFROM users u\nLEFT JOIN orders o ON u.id = o.user_id\nGROUP BY u.id;\n\n## Optimization Rules\n- Add indexes on WHERE/JOIN columns\n- Avoid SELECT * - specify columns\n- Use EXPLAIN to analyze execution plan\n- Optimize JOIN order (small table first)\n- Add LIMIT for pagination\n\n## Anti-Patterns to Avoid\n- SELECT * in production code\n- Nested subqueries (use JOINs or CTEs)\n- OR in WHERE clause (use IN or UNION)\n","topics":["Database","SQL Query"],"tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":346,"installsAllTime":13,"installsCurrent":1,"stars":0,"versions":1},"createdAt":1777690145662,"updatedAt":1778492826217},"latestVersion":{"version":"1.0.0","createdAt":1777690145662,"changelog":"- Initial release of skylv-sql-helper.\n- Generates SQL queries, explains execution plans, and offers query optimization tips.\n- Supports debugging of slow database operations.\n- Includes practical query examples for pagination and joins with aggregation.\n- Provides optimization rules and highlights common SQL anti-patterns to avoid.","license":"MIT-0"},"metadata":{"setup":[],"os":null,"systems":null},"owner":{"handle":"sky-lv","userId":"s17fgkeb63szvtadtmm753m0gd84e4vz","displayName":"SKY-lv","image":"https://avatars.githubusercontent.com/u/259750852?v=4"},"moderation":null}