SQL Query Explainer

НачальныйdataМинимальный контекст: 8K

Explains what a SQL query does in plain language and how it executes. Breaks down joins, subqueries, CTEs, and window functions step by step, describes the result set, reads EXPLAIN/EXPLAIN ANALYZE output to identify slow scans and missing indexes, and flags correctness pitfalls. Helps developers understand, review, and trust unfamiliar SQL.

sqldatabasesquery-planexplainlearning

Варианты использования

  • Explaining a complex query with CTEs and window functions
  • Walking through an unfamiliar query during code review
  • Interpreting EXPLAIN ANALYZE output to find bottlenecks
  • Flagging subtle correctness issues like fan-out joins

Пример промпта

Explain this SQL query and how it runs.

1. Describe in plain language what it returns, step by step
2. Explain each join, CTE, and window function
3. Point out any correctness risks (duplicate rows from joins, NULL handling)
4. If I paste EXPLAIN ANALYZE output, identify the slowest steps and suggest indexes

Query:
```sql
[paste query here]
```

Рекомендуемые модели

claude-opus-4-6gpt-5deepseek-v4qwen3-coder

Совместимые инструменты

claude-codecursorkiroany

Модальности

Вход: text, code
→
Выход: text

Похожие Skills

sql-generationdatabase-query-optimizercode-explainer

Автор

OpenModels Community

@openmodelsrun