SQL Query Generator

Prompt-only SQL generator that always returns query + explanation + performance notes + test script for BigQuery/Postgres/MySQL/Snowflake — no schema-parsing tooling of its own.

Tested · Works

Test report

Verdict
Tested · Works
Score
8.4/10
Tested
Jul 14, 2026
Environment
Claude Code 2.x (agent harness)
Upstream re-checked
Aug 10, 2026 · 7780d95

Fed it a two-table schema and asked for a Postgres cohort-revenue query: the SQL itself came out identical to an unguided answer, and the skill's only real value-add was forcing the mandated four-part deliverable (query + explanation + perf notes + test script). Ends with a 'Further Reading' footer linking the author's own newsletter — not an injected instruction, but a self-promotional touch worth disclosing.

Scored on four weighted criteria — install, triggering, output vs. baseline, docs. How scoring works

  • Installs cleanly 5/5
  • Triggers reliably 5/5
  • Output vs. baseline 7/10
  • Docs & honesty 4/5

What SQL Query Generator does

Generates SQL queries from natural-language requirements, confirming the target dialect and schema first, then always delivering a four-part package: commented SQL, plain-English explanation, performance notes, and an optional test script. It is a single SKILL.md with no bundled parser, script, or live database connection — 'reading' a schema means Claude reads whatever text or diagram description you paste in, same as it would without the skill. Bundled in a 100+ skill PM marketplace repo, so the exact subfolder path must be copied.

SQL Query Generator before / after — same task, with and without

Without the skill

SELECT * FROM orders WHERE status = 'paid' — then an afternoon of hand-aggregating cohorts in a spreadsheet.

With SQL Query Generator

One window-function query with cohort buckets and correct timezone handling — verified row-by-row against a hand-built answer.

How to install SQL Query Generator

git clone https://github.com/phuryn/pm-skills
cd pm-skills
mkdir -p ~/.claude/skills
cp -r pm-data-analytics/skills/sql-queries ~/.claude/skills/sql-queries

Skills live in ~/.claude/skills/ (global) or .claude/skills/ (per-project). Restart Claude Code after installing.

Commands — how to trigger SQL Query Generator

  • /sql-queries Prompt-only SQL generator that always returns query + explanation + performance notes + test script for BigQuery/Postgres/MySQL/Snowflake — no schema-parsing tooling of its own.

It also activates on plain-language prompts like these:

  • Write a SQL query with a window function to rank sales by region
  • Join these three tables and dedupe rows using a CTE, here's the schema
  • Optimize this slow query running against our Postgres schema

Appears in

Frequently asked questions

Is the SQL Query Generator skill free?
Yes. The skill itself is free from phuryn/pm-skills. SkillProof publishes the install command and an independent test verdict at no cost.
Does SQL Query Generator work with Claude Code?
We tested it with Claude Code 2.x (agent harness) on Jul 14, 2026. Verdict: Tested · Works. Fed it a two-table schema and asked for a Postgres cohort-revenue query: the SQL itself came out identical to an unguided answer, and the skill's only real value-add was forcing the mandated four-part deliverable (query + explanation + perf notes + test script). Ends with a 'Further Reading' footer linking the author's own newsletter — not an injected instruction, but a self-promotional touch worth disclosing.
What is the SQL Query Generator SkillProof Score?
8.4/10 — installs cleanly 5/5, triggers reliably 5/5, output vs. baseline 7/10, docs & honesty 4/5.
How do I install SQL Query Generator?
Copy the install command from this page, run it in your terminal, and restart Claude Code. Skills live in ~/.claude/skills/ (global) or .claude/skills/ inside a project.
Can I use SQL Query Generator with Cursor, Copilot, Gemini CLI, Codex or other AI tools?
The SKILL.md format is native to Claude (Claude Code, Desktop, claude.ai). The instructions inside adapt to other assistants: Cursor rules, GitHub Copilot instructions, Windsurf rules, Custom GPTs, AGENTS.md for OpenAI Codex, and GEMINI.md for Google Gemini CLI — our conversion guides cover each, and the free converter on the tools page does the wrapping for you.