跳转到主要内容
此内容尚未提供您的语言版本,正在以英文显示。

Sf Soql

技能 已验证 活跃

SOQL query generation, optimization, and analysis with 100-point scoring. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use sf-data), Apex DML logic (use sf-apex), or report/dashboard queries.

目的

To enable users to efficiently write, optimize, and understand Salesforce SOQL/SOSL queries, ensuring performance, security, and adherence to governor limits.

功能

  • Natural language to SOQL/SOSL generation
  • SOQL query optimization and selectivity analysis
  • Guidance on relationship queries and aggregate queries
  • Security and governor-aware design principles
  • 100-point scoring for query quality

使用场景

  • Generating SOQL/SOSL from plain English requirements
  • Optimizing slow or non-selective SOQL queries
  • Building complex relationship or aggregate queries
  • Validating SOQL queries for security and performance before deployment

非目标

  • Performing bulk data operations
  • Embedding query logic within broader Apex DML
  • Debugging slow query symptoms directly from logs (delegated to sf-debug)
  • Handling report or dashboard query generation

实践

  • SOQL Optimization
  • Query Security
  • Governor Limit Awareness
  • Apex Selector Patterns

安装

npx skills add jaganpro/sf-skills

通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。

质量评分

已验证
97 /100
1 day ago 分析

信任信号

最近提交17 days ago
星标409
许可证MIT
状态
查看源代码

类似扩展

Salesforce Developer

100

Writes and debugs Apex code, builds Lightning Web Components, optimizes SOQL queries, implements triggers, batch jobs, platform events, and integrations on the Salesforce platform. Use when developing Salesforce applications, customizing CRM workflows, managing governor limits, bulk processing, or setting up Salesforce DX and CI/CD pipelines.

技能
jeffallan

Sf Data

99

Salesforce data operations with 130-point scoring. TRIGGER when: user creates test data, performs bulk import/export, uses sf data CLI commands, or needs data factory patterns for Apex tests. DO NOT TRIGGER when: SOQL query writing only (use sf-soql), Apex test execution (use sf-testing), or metadata deployment (use sf-deploy).

技能
jaganpro

Sf Testing

98

Apex test execution, coverage analysis, and test-fix loops with 120-point scoring. TRIGGER when: user runs Apex tests, checks code coverage, fixes failing tests, or touches *Test.cls / *_Test.cls files. DO NOT TRIGGER when: writing Apex production code (use sf-apex), Agentforce agent testing (use sf-ai-agentforce-testing), or Jest/LWC tests (use sf-lwc).

技能
jaganpro

Sf Integration

98

Salesforce integration architecture with 120-point scoring. TRIGGER when: user sets up Named Credentials, External Services, REST/SOAP callouts, Platform Events, CDC, or touches .namedCredential-meta.xml files. DO NOT TRIGGER when: Connected App/OAuth config (use sf-connected-apps), Apex-only logic (use sf-apex), or data import/export (use sf-data).

技能
jaganpro

Sf Industry Commoncore Callable Apex

98

Salesforce Industries Common Core (OmniStudio/Vlocity) Apex callable generation and review with 120-point scoring. TRIGGER when: user creates or reviews System.Callable classes, migrates `VlocityOpenInterface` / `VlocityOpenInterface2`, or builds Industries callable extensions used by OmniStudio, Integration Procedures, or DataRaptors. DO NOT TRIGGER when: generic Apex classes/triggers (use sf-apex), building Integration Procedures (use sf-industry-commoncore-integration-procedure), authoring OmniScripts (use sf-industry-commoncore-omniscript), configuring Data Mappers (use sf-industry-commoncore-datamapper), or analyzing namespace/dependency issues (use sf-industry-commoncore-omnistudio-analyze).

技能
jaganpro

Performance Analysis

100

Comprehensive performance analysis, bottleneck detection, and optimization recommendations for Claude Flow swarms

技能
ruvnet