SQL Query Explainer

The problem

Legacy queries and complex joins often become black boxes that are difficult to audit or explain to non-technical stakeholders. Developers frequently waste time manually tracing logic in deeply nested SQL just to understand what a report or feature is actually doing.

What it does

• Deconstructs complex SQL statements into plain-English summaries of intent.
• Maps all tables, join conditions, and relationships within the query.
• Breaks down filters, groupings, and ordering logic into sequential steps.
• Identifies the final result set shape and the meaning of returned columns.
• Flags risky patterns like missing WHERE clauses on deletions or accidental Cartesian products.

Frameworks & tools

Works with all SQL dialects including PostgreSQL, MySQL, T-SQL, Snowflake, and BigQuery.

Why this beats prompting it yourself

This skill follows a strict structural analysis process that ensures no clause is overlooked. It enforces a standardized output format that identifies risks and schema assumptions that generic prompts often miss.

Use cases

• Audit legacy SQL scripts before refactoring or migration.
• Generate plain-language documentation for internal data catalogs.
• Verify business logic in complex reporting queries with stakeholders.
• Onboard new developers to unfamiliar database schemas and query patterns.

Known limitations

Does not execute queries or validate syntax against live databases. Cannot infer column meanings beyond what is explicitly provided in names or schema notes.