SQL Queries
phuryn/pm-skills
Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills.
将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库，或将业务问题转化为查询语句。
Install SQL Queries
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install killvxk/pm-skills-zh sql-queries --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .claude/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .claude/skills/sql-queries && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .claude/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queriesType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install killvxk/pm-skills-zh sql-queries --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .agents/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .agents/skills/sql-queries && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .agents/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install killvxk/pm-skills-zh sql-queries --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .cursor/skills/sql-queries && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .cursor/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/killvxk/pm-skills-zh.git --path pm-data-analytics/skills/sql-queries--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install killvxk/pm-skills-zh sql-queries --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .gemini/skills/sql-queries && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .gemini/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install killvxk/pm-skills-zh sql-queriesInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .github/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .github/skills/sql-queries && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .github/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add killvxk/pm-skills-zh --skill sql-queries -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install killvxk/pm-skills-zh sql-queries --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/killvxk/pm-skills-zh.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/pm-data-analytics/skills/sql-queries .opencode/skills/sql-queries && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "sql-queries" agent skill from https://github.com/killvxk/pm-skills-zh/tree/master/pm-data-analytics/skills/sql-queries into .opencode/skills/sql-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sql-queries", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
sql-queries- GitHub stars
- 167
- Token cost
- ~423 tokens
- SKILL.md length
- 85 words
- Files
- 1
- Skills in repo
- 11
- Repo updated
- First seen
- Licence
- MIT
At a glance
将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库，或将业务问题转化为查询语句。
- Works in 5 steps: 提供背景信息：分享你的数据库结构或表结构 → 描述清晰：明确说明你需要的数据及过滤条件 → 注明数据库类型：指定你使用的 SQL 方言 → …
- Tasks that involve SQL
- SKILL.md covers 用途, 工作原理, 使用示例 and 核心能力, plus 2 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
SQL Queries is an agent skill from killvxk/pm-skills-zh. 将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库，或将业务问题转化为查询语句。
Its SKILL.md is about 420 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering SQL and Data warehousing. It works with SQL, Google BigQuery, MySQL and PostgreSQL. The repository describes itself as: PM Skills Marketplace 简体中文版 - 65个产品经理技能和36个工作流，翻译自 https://github.com/phuryn/pm-skills/. The licence is MIT.
When your agent uses it
- Tasks that involve SQL
- Tasks that involve Data warehousing
Example prompts
- “/sql-queries”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- 提供背景信息：分享你的数据库结构或表结构
- 描述清晰：明确说明你需要的数据及过滤条件
- 注明数据库类型：指定你使用的 SQL 方言
- 说明限制条件：提及数据量、时间范围和性能要求
- 明确输出格式：如需特定格式的查询结果，请提前说明
What it can do on your machine
Read from SKILL.md and the folder at commit 5179784. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
productcompass.pm
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
SQL Queries loads about 423 tokens when it runs. Until then it costs about 31 tokens; SKILL.md has 85 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from killvxk/pm-skills-zh at commit 5179784, republished under its MIT licence (© killvxk). 85 words, ~423 tokens.
Download SKILL.mdSave it as
.claude/skills/sql-queries/SKILL.md (or your agent's skills folder).- name
- sql-queries
- description
- 将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库，或将业务问题转化为查询语句。
SQL 查询生成器
用途
将自然语言需求转化为经过优化的 SQL 查询，支持多种数据库平台。帮助产品经理、分析师和工程师准确生成查询语句，无需手动处理语法细节。
工作原理
第一步：理解数据库结构
- 如果你提供了结构文件（SQL、文档或结构图描述），我将读取并分析
- 提取表名、字段定义、数据类型及关联关系
- 识别主键、外键和索引策略
第二步：处理查询需求
- 明确你需要检索或分析的具体数据
- 确认 SQL 方言（BigQuery、PostgreSQL、MySQL、Snowflake 等）
- 询问额外要求（过滤条件、聚合方式、排序规则）
第三步：生成优化查询
- 编写充分利用数据库结构的高效 SQL
- 添加注释，解释复杂逻辑
- 针对大数据集提供性能优化建议
- 如有适用，提供替代实现方案
第四步：解释与测试
- 用通俗语言解释查询逻辑
- 建议如何测试或验证结果
- 提供性能优化技巧
- 如有需要，生成测试脚本或示例数据
使用示例
示例一：基于结构文件生成查询
上传你的 database_schema.sql 文件，并输入：
"生成一个查询，找出过去 30 天内注册且至少有 5 次活跃会话的用户"示例二：基于结构描述生成查询
"我的数据库结构如下：Users 表（id, email, created_at），Sessions 表
（id, user_id, timestamp, duration）。生成一个查询，
统计 2026 年 1 月每位用户的平均会话时长。"示例三：复杂分析查询
"创建一个 BigQuery 查询，按地区和客户等级分析营收，
包含同比增长率。"核心能力
- 多方言支持：兼容 BigQuery、PostgreSQL、MySQL、Snowflake、SQL Server
- 文件读取：读取结构文件、SQL dump 及数据文档
- 查询优化：建议索引、分区及性能改进方案
- 解释说明：拆解查询逻辑，便于学习和文档化
- 测试支持：可生成测试查询和示例数据脚本
- 脚本执行：为你的数据库创建可执行的 SQL 脚本
最佳实践建议
- 提供背景信息：分享你的数据库结构或表结构
- 描述清晰：明确说明你需要的数据及过滤条件
- 注明数据库类型：指定你使用的 SQL 方言
- 说明限制条件：提及数据量、时间范围和性能要求
- 明确输出格式：如需特定格式的查询结果，请提前说明
输出格式
你将收到：
- SQL 查询：带注释的生产可用 SQL 代码
- 说明：查询的功能和运行逻辑
- 性能备注：优化建议和注意事项
- 测试脚本（如有需要）：示例数据和验证查询
延伸阅读
© killvxk, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in pm-data-analytics/skills/sql-queries of killvxk/pm-skills-zh.
Open the folder on GitHubat commit 5179784
Compare with similar skills
SQL Queries next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| SQL Queries this skillkillvxk/pm-skills-zh | 167 | — | ~423 | Automated safety check: Pass | MIT | |
| SQL Queriesphuryn/pm-skills | 27k | — | ~907 | Automated safety check: Pass | MIT | |
| SQL Query Explainermohitagw15856/pm-claude-skills | 1.4k | — | ~1.6k | Automated safety check: Pass | MIT | |
| Chdb SQLvemetric/vemetric | 394 | 1 repos | ~1.2k | Automated safety check: Pass | Apache-2.0 | |
| Semantic Analystsidequery/sidemantic | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | |
| SQL Queriesw95/awesome-claude-corporate-skills | 235 | 3 repos | ~2.8k | Automated safety check: Pass | MIT |
Similar skills
SQL Query Explainer
mohitagw15856/pm-claude-skills
Explains, optimises, writes, and documents SQL queries. An agent skill from mohitagw15856/pm-claude-skills.
Chdb SQL
vemetric/vemetric
A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…
Semantic Analyst
sidequery/sidemantic
Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.
SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
SQL Sentinel
sickn33/agentic-awesome-skills
Audit SQL for the cost & performance anti-patterns that burn warehouse credits.
More from killvxk/pm-skills-zh
All 11 skills in this repoAb Test Analysis
killvxk/pm-skills-zh
分析 A/B 测试结果，涵盖统计显著性检验、样本量验证、置信区间计算及上线/延长/停止的决策建议。适用于评估实验结果、判断测试是否达到显著性、解读分流测试数据，或决定是否上线某个实验组。
Brainstorm Okrs
killvxk/pm-skills-zh
集思广益制定团队级 OKR（目标与关键成果），对齐公司目标——定性目标与可量化关键成果。适用于制定季度 OKR、将团队目标与公司战略对齐、起草目标，或学习如何编写有效的 OKR。
Cohort Analysis
killvxk/pm-skills-zh
对用户参与度数据执行同期群分析——留存曲线、功能采用趋势及分层洞察。适用于按同期群分析用户留存、研究功能随时间的采用情况、调查流失规律，或识别参与度趋势。
Dummy Dataset
killvxk/pm-skills-zh
生成用于测试的逼真虚拟数据集，支持自定义列、约束条件及输出格式（CSV、JSON、SQL、Python 脚本）。适用于创建测试数据、构建模拟数据集，或为开发和演示生成示例数据。
Interview Script
killvxk/pm-skills-zh
创建结构化的用户访谈脚本，包含 JTBD（用户待办任务）探测问题、破冰环节、核心探索及收尾部分。遵循"老妈测试"原则——不引导、不推销，聚焦过去的实际行为。适用于准备用户访谈、创建访谈指南或规划探索性研究时使用。
Metrics Dashboard
killvxk/pm-skills-zh
定义并设计产品指标看板，包含核心指标、数据来源、可视化类型和告警阈值。适用于创建指标看板、定义 KPI（关键绩效指标）、搭建产品分析体系或制定数据监控计划时使用。
Related
Works with
Categories
Questions about SQL Queries
What does SQL Queries do?
将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库，或将业务问题转化为查询语句。. SQL Queries is an agent skill from killvxk/pm-skills-zh.
When should I use SQL Queries?
SQL Queries fits situations like: tasks that involve SQL; tasks that involve Data warehousing.
How do I install SQL Queries in Claude Code?
Run `npx skills add killvxk/pm-skills-zh --skill sql-queries -a claude-code`. Or copy the skill folder (pm-data-analytics/skills/sql-queries in killvxk/pm-skills-zh) into .claude/skills/sql-queries in your project. Claude Code loads it when a task matches its description.
How do I install SQL Queries in Codex?
Run `npx skills add killvxk/pm-skills-zh --skill sql-queries -a codex`. Or copy the skill folder (pm-data-analytics/skills/sql-queries in killvxk/pm-skills-zh) into .agents/skills/sql-queries in your project. Codex loads it when a task matches its description.
Can I use SQL Queries in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add killvxk/pm-skills-zh --skill sql-queries -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sql-queries, .gemini/skills/sql-queries, .github/skills/sql-queries and .opencode/skills/sql-queries in your project.
What does SQL Queries need to run?
SKILL.md names no scripts, command-line tools or credentials: SQL Queries is instructions for the agent only.
Does SQL Queries access the network?
SKILL.md names 1 domain. As links in the text: productcompass.pm. This is read from the text; nothing was executed.
Is SQL Queries safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does SQL Queries use?
SQL Queries is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does SQL Queries use?
About 423 tokens (SKILL.md is roughly 1.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to SQL Queries?
Skills that share tags, products or a category with SQL Queries: SQL Queries (phuryn/pm-skills, 27k stars), SQL Query Explainer (mohitagw15856/pm-claude-skills, 1.4k stars), Chdb SQL (vemetric/vemetric, 394 stars) and Semantic Analyst (sidequery/sidemantic, 129 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains SQL Queries?
killvxk (a GitHub user) maintains it in killvxk/pm-skills-zh, which has 167 GitHub stars. The repository holds 11 skills in this directory. The repository was last updated on March 16, 2026.
Source: killvxk/pm-skills-zh on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.