sql-explain

Explain SQL queries in plain language and suggest optimizations.

11|Updated Apr 16, 2026
One-click install
npx skills add https://github.com/berkcangumusisik/claude-code-practices --skill sql-explain-berkcangumusisik
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sql-explain
Source: https://github.com/berkcangumusisik/claude-code-practices/tree/main/skills/sql-explain
Command: npx skills add https://github.com/berkcangumusisik/claude-code-practices --skill sql-explain-berkcangumusisik

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill translates complex SQL queries into plain language explanations and provides concrete optimization recommendations to improve performance and correctness.

Core Features & Use Cases

  • Plain-English explanations: Breaks down involved tables, filters, joins, and result sets.
  • Optimization suggestions: Recommends indexing, query rewrites, and execution plans to improve performance.
  • Use Case: When reviewing a slow query, paste it or load it from a file to receive an actionable explanation and a concrete optimization plan.

Quick Start

Paste a SQL query or load a file to immediately get a plain-language explanation and optimization recommendations.

Frequently Asked Questions about sql-explain

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I explain a slow SQL query in plain English?

To explain a SQL query in plain English, paste the query string or load a multi-statement block from a file. The system outputs a structured explanation of involved tables, filters, joins, and result sets.

What's the best way to optimize SQL queries for PostgreSQL and MySQL?

The best way to optimize SQL queries for PostgreSQL and MySQL is to analyze the execution plan. This system provides concrete optimization recommendations like indexing and query rewrites to improve performance and correctness.

Can I analyze multiple SQL statements loaded from a file?

Yes, you can analyze multiple SQL statements loaded from a file. The system accepts a file path to process multi-statement blocks, providing explanations and optimization suggestions for performance analysis.

Does this tool provide SQL execution plan analysis and indexing recommendations?

Yes, this tool provides SQL execution plan analysis and indexing recommendations. It translates complex queries into structured explanations and offers concrete optimization suggestions to resolve potential performance issues.

Why does my SQL query have potential issues and how can I find them?

Your SQL query may have potential issues due to inefficient joins or missing indexes. Submit your query string to receive a structured explanation highlighting potential issues and actionable optimization suggestions.

Are there limitations when explaining SQL queries for databases other than PostgreSQL and MySQL?

The system is applicable to PostgreSQL, MySQL, and other databases for explaining SQL queries. It accepts query strings or file paths to output structured explanations, potential issues, and optimization suggestions.