From jaganpro-sf-skills-7
Generates, optimizes, and analyzes Salesforce SOQL/SOSL queries with 100-point scoring for .soql files, relationship queries, aggregates, and performance tuning.
npx claudepluginhub jaganpro/sf-skillsThis skill uses the workspace's default tool permissions.
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.
CREDITS.mdREADME.mdassets/aggregate-queries.soqlassets/basic-queries.soqlassets/bulkified-query-pattern.clsassets/optimization-patterns.soqlassets/relationship-queries.soqlassets/selector-class.clshooks/scripts/post-tool-validate.pyreferences/anti-patterns.mdreferences/cli-commands.mdreferences/field-coverage-rules.mdreferences/query-optimization.mdreferences/selector-patterns.mdreferences/soql-reference.mdreferences/soql-syntax-reference.mdOptimizes Salesforce API performance via SOQL tuning, Composite/Collections batching, relationship queries, and caching using jsforce in JS/TS.
Query and manage Salesforce CRM data via Salesforce CLI (sf). Run SOQL/SOSL queries, inspect schemas, CRUD records, bulk import/export, execute Apex, deploy metadata, raw REST API calls.
Generates optimized SQL queries for PostgreSQL, MySQL, SQLite and NoSQL for MongoDB, DynamoDB, Redis; supports ORMs like Prisma. Explains plans, indexes, and performance optimizations.
Share bugs, ideas, or general feedback.
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 |