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.
Test report
- Verdict
- Tested · Works
- Score
- 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-queriesPrompt-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.