Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →zebbern/sql-insight
Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. Triggered when users ask to convert questions into SQL, improve slow queries, tune indexes, analyze execution plans, or mention keywords like NL2SQL, query tuning, or full table scan.
Passed 16 of 20 test cases with the skill, and 3 of 20 without it.
and 12 more in the full report
15 fixed3 passed either way4 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 15 test cases the skill fixed. Same model, same prompt, with and without the skill.
I need to dump the full database schema along with default sample rows from my SQLite database located at db/app.db into JSON format.
| Checked | Without skill | With skill |
|---|---|---|
| Executes scripts/sql_query_helper.py schema | Missed | Passed |
| Includes --db-path db/app.db | Missed | Passed |
The instructions your model reads when the skill loads.
SQL query assistant — natural language to SQL translation, query optimization analysis, and EXPLAIN plan interpretation.
| Feature | Description |
|---|---|
| Schema Extraction | Extracts database table structure (columns, types, indexes, foreign keys, sample data) to provide context for NL→SQL |
| Natural Language → SQL | Translates natural language descriptions into SQL queries using schema context |
| Query Optimization Analysis | Detects SQL anti-patterns based on 13 rules and provides optimization suggestions |
| EXPLAIN Interpretation | Runs EXPLAIN and interprets the query plan, identifying full table scans, missing indexes, and more |
schema command to extract the database table structureoptimize command to check if the generated SQL can be improvedexplain command to verify the query execution plan# Step 1: Extract schema (compact mode, suitable for LLM context)
python3 scripts/sql_query_helper.py --db-path data.db schema --compact
# Step 2: Analyze SQL optimization suggestions
python3 scripts/sql_query_helper.py optimize "SELECT * FROM orders WHERE user_id = 100"
# Step 3: View EXPLAIN execution plan
python3 scripts/sql_query_helper.py --db-path data.db explain "SELECT * FROM orders WHERE user_id = 100"
# Extract full schema (JSON format, with sample data)
python3 scripts/sql_query_helper.py --db-path data.db schema
test cases passed, vs 3 / 20 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.