Sf Soql

Generates, optimizes, and scores SOQL queries for Salesforce with a 100-point rubric across five categories. Handles everything from natural language to query conversion, relationship traversals, aggregates, and selectivity analysis. Knows when to use child-to-parent lookups versus subqueries, when SOSL beats SOQL, and flags anti-patterns like querying in loops or leading wildcards. The scoring system is genuinely useful: anything under 70 needs work before production, 90+ means it's optimized and ready. Delegates actual query execution to sf-data and Apex embedding to sf-apex, keeping focus purely on query shape and performance. Built by someone who clearly debugged too many slow queries.

skills.sh installs: 1.5K
GitHub stars: 422
last updated: Jul 14, 2026

View on GitHub

Install

$ npx -y skills add jaganpro/sf-skills --skill sf-soql --agent claude-code

Installs into .claude/skills of the current project.

Files

sf-soql: Salesforce SOQL Query Expert

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.

When This Skill Owns the Task

Use sf-soql when the work involves:

.soql files
query generation from natural language
relationship queries and aggregate queries
query optimization and selectivity analysis
SOQL/SOSL syntax and governor-aware design

Delegate elsewhere when the user is:

performing bulk data operations → sf-data
embedding query logic inside broader Apex implementation → sf-apex
debugging via logs rather than query shape → sf-debug

Required Context to Gather First

Ask for or infer:

target object(s)
fields needed
filter criteria
sort / limit requirements
whether the query is for display, automation, reporting-like analysis, or Apex usage
whether performance / selectivity is already a concern