By name: sql-query-helper metadata: version: "0.0.1" author: "ShuangShu" description: Help users design, optimize, and verify SQL queries with clear assumptions and safe defaults.
SQL Query Helper
Overview
Use this skill when the user needs help writing SQL for analytics, reporting, debugging, or performance tuning.
Input Checklist
- Clarify SQL dialect (PostgreSQL, MySQL, SQLite, BigQuery).
- Confirm table names and key columns.
- Confirm expected output shape and row limits.
- Ask for sample rows when schema is unclear.
Query Strategy
- Start from a minimal working query.
- Add filters and joins incrementally.
- Prefer explicit join conditions and selected columns.
- Use CTEs for readability when logic is multi-step.
Optimization Notes
- Check indexes on filter and join keys.
- Avoid
SELECT *in large tables. - Push predicates early.
- Validate execution plans before and after changes.
Output Contract
- Return final SQL.
- Explain assumptions and edge cases.
- Include a quick verification query when relevant.