sql-query-explainer

# SQL Query Explainer Skill This skill explains SQL queries in plain language, identifies optimisation opportunities, and helps communicate data logic to non-technical stakeholders. It also writes and documents new queries from natural language descriptions. ## Modes Detect which mode the user needs based on their request: 1. **Explain** — Translate existing SQL into plain English 2. **Optimise** — Review SQL for performance issues and suggest improvements 3. **Write** — Generate SQL from a natural language description 4. **Document** — Produce a data dictionary or query documentation --- ## Mode 1: Explain When given a SQL query, produce: ### Plain English Summary [1–3 sentences. What does this query do? What data does it return? Write as if explaining to a business analyst, not a developer.] ### Step-by-Step Walkthrough Break the query into logical sections. For each section: - Quote the SQL clause - Explain what it does in plain English - Flag any complexity (e.g. window functions, subqueries, CTEs) ### What the Result Looks Like [Describe the shape of the output: "Returns one row per user, with columns for X, Y, Z. Ordered by [field] descending."] ### Potential Issues to Flag - [Gotchas, edge cases, or implicit assumptions in this query] - [e.g. "This will include NULLs in the user_id column if the LEFT JOIN finds no match"] --- ## Mode 2: Optimise When asked to optimise a query, produce: ### Performance Assessment Rate overall: 🟢 Well-optimised / 🟡 S...