From pm-data-analytics
Generates optimized SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, Snowflake; reads schemas from files or docs. For data exploration, reports, and business analysis.
How this skill is triggered — by the user, by Claude, or both
Slash command
/pm-data-analytics:sql-queriesThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
将自然语言需求转化为经过优化的 SQL 查询,支持多种数据库平台。帮助产品经理、分析师和工程师准确生成查询语句,无需手动处理语法细节。
将自然语言需求转化为经过优化的 SQL 查询,支持多种数据库平台。帮助产品经理、分析师和工程师准确生成查询语句,无需手动处理语法细节。
示例一:基于结构文件生成查询
上传你的 database_schema.sql 文件,并输入:
"生成一个查询,找出过去 30 天内注册且至少有 5 次活跃会话的用户"
示例二:基于结构描述生成查询
"我的数据库结构如下:Users 表(id, email, created_at),Sessions 表
(id, user_id, timestamp, duration)。生成一个查询,
统计 2026 年 1 月每位用户的平均会话时长。"
示例三:复杂分析查询
"创建一个 BigQuery 查询,按地区和客户等级分析营收,
包含同比增长率。"
你将收到:
npx claudepluginhub killvxk/pm-skills-zh --plugin pm-data-analyticsGenerates optimized SQL queries from natural language for BigQuery, PostgreSQL, MySQL, Snowflake, SQL Server. Reads schemas from uploaded files, diagrams, docs for reporting, analysis, exploration.
Writes optimized SQL queries from natural language for dialects like PostgreSQL, Snowflake, BigQuery, MySQL. Builds multi-CTE queries with joins, aggregations; optimizes performance on large tables.
Guides complex SQL queries, performance tuning, and data modeling across cloud-native OLTP/OLAP databases. Useful when writing analytics or optimizing query plans.