npx skills add https://github.com/jaganpro/sf-skills --skill sf-soql当用户需要 SOQL/SOSL 编写或优化时使用此技能:自然语言到查询生成、关系查询、聚合查询、查询计划分析,以及 Salesforce 查询的性能/安全性改进。
当工作涉及以下内容时,使用 sf-soql:
.soql 文件在以下情况下,请委托给其他技能:
询问或推断:
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
优先考虑:
| 需求 | 默认模式 |
|---|---|
| 从子记录获取父记录数据 | 子到父遍历 |
| 从父记录获取子记录行 | 子查询 |
| 计数 / 汇总 | 聚合查询 |
| 具有 / 没有相关行的记录 | 半连接 / 反连接 |
| 跨对象文本搜索 | SOSL |
检查:
如果用户需要运行时验证,将执行交给:
SELECT * 风格;仅查询所需字段完成时,按以下顺序报告:
建议格式:
Query goal: <摘要>
Query: <soql 或 sosl>
Design: <关系 / 聚合 / 筛选选择>
Notes: <选择性、限制、安全性、限制器意识>
Next step: <在 sf-data 中运行或嵌入到 Apex 中>
| 分数 | 含义 |
|---|---|
| 90+ | 生产环境优化的查询 |
| 80–89 | 良好的查询,可能有小的改进空间 |
| 70–79 | 功能正常,但存在性能问题 |
| < 70 | 在生产使用前需要修改 |
每周安装次数
275
代码仓库
GitHub 星标数
219
首次出现
2026年1月22日
安全审计
安装于
codex263
opencode262
cursor261
gemini-cli260
github-copilot258
amp255
Use this skill when the user needs SOQL/SOSL authoring or optimization : natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance/safety improvements for Salesforce queries.
Use sf-soql when the work involves:
.soql filesDelegate elsewhere when the user is:
Ask for or infer:
Prefer:
| Need | Default pattern |
|---|---|
| parent data from child | child-to-parent traversal |
| child rows from parent | subquery |
| counts / rollups | aggregate query |
| records with / without related rows | semi-join / anti-join |
| text search across objects | SOSL |
Check:
If the user wants runtime verification, hand off execution to:
SELECT * style thinking; query only required fieldsWhen finishing, report in this order:
Suggested shape:
Query goal: <summary>
Query: <soql or sosl>
Design: <relationship / aggregate / filter choices>
Notes: <selectivity, limits, security, governor awareness>
Next step: <run in sf-data or embed in Apex>
| Need | Delegate to | Reason |
|---|---|---|
| run the query against an org | sf-data | execution and export |
| embed the query in services/selectors | sf-apex | implementation context |
| analyze slow-query symptoms from logs | sf-debug | runtime evidence |
| wire query-backed UI | sf-lwc | frontend integration |
| Score | Meaning |
|---|---|
| 90+ | production-optimized query |
| 80–89 | good query with minor improvements possible |
| 70–79 | functional but performance concerns remain |
| < 70 | needs revision before production use |
Weekly Installs
275
Repository
GitHub Stars
219
First Seen
Jan 22, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
codex263
opencode262
cursor261
gemini-cli260
github-copilot258
amp255
React 组合模式指南:Vercel 组件架构最佳实践,提升代码可维护性
106,200 周安装