Agent skill

Sf Soql

SOQL query generation, optimization, and analysis with 100-point scoring.

MITAuto-check passedDatabases

Install Sf Soql

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/sf-soql .claude/skills/sf-soql && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .claude/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/sf-soql .agents/skills/sf-soql && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .agents/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/sf-soql .cursor/skills/sf-soql && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .cursor/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/Jaganpro/sf-skills.git --path skills/sf-soql

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/sf-soql .gemini/skills/sf-soql && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .gemini/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/sf-soql .github/skills/sf-soql && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .github/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add Jaganpro/sf-skills --skill sf-soql -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install Jaganpro/sf-skills sf-soql --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/Jaganpro/sf-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/sf-soql .opencode/skills/sf-soql && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "sf-soql" agent skill from https://github.com/Jaganpro/sf-skills/tree/main/skills/sf-soql into .opencode/skills/sf-soql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sf-soql", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: sf-soql
GitHub stars: 424
Token cost: ~1.2k tokens
SKILL.md length: 399 words
Files: 17 (incl. references, assets)
Skills in repo: 36
Repo updated: Apr 27, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

SOQL query generation, optimization, and analysis with 100-point scoring.

Works in 4 steps: Generate the simplest correct query → Choose the right query shape → Optimize for selectivity and safety → …
Debugs SOQL/SOSL queries
SKILL.md covers When This Skill Owns the Task, Required Context to Gather First, Recommended Workflow and High-Signal Rules, plus 4 more sections
Runs Python scripts from its folder

What it does

Sf Soql is an agent skill from Jaganpro/sf-skills. 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.

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 20 other files, including reference files and assets (for example `CREDITS.md`, `README.md` and `hooks/scripts/post-tool-validate.py`).

It sits in Databases, covering Query optimization. The repository describes itself as: [ARCHIVED — migrated to forcedotcom/afv-library] Salesforce Skills for Agentic Coding Tools — Apex, Flow, LWC, SOQL, Agentforce, Data Cloud, OmniStudio. Read-only archive; active… The licence is MIT.

When your agent uses it

Debugs SOQL/SOSL queries
Touches .soql files
Asks about relationship queries
Query performance

Example prompts

“/sf-soql”

Requirements

Python 3

Workflow steps

4 steps, taken from the step headings in SKILL.md.

Generate the simplest correct query
Choose the right query shape
Optimize for selectivity and safety
Validate execution path if needed

What it can do on your machine

Read from SKILL.md and the folder at commit 53c9956. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships script files (Python), which the agent can run.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Sf Soql loads about 1.2k tokens when it runs, and up to ~16k if it reads all its reference files. Until then it costs about 89 tokens; SKILL.md has 399 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~89
When it runs · the whole SKILL.md, loaded when a task matches: ~1.2k
With references · SKILL.md plus every file in references/, read only if the agent opens them: ~16k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from Jaganpro/sf-skills at commit 53c9956, republished under its MIT licence (© Jaganpro). 399 words, ~1,151 tokens.

Download SKILL.mdSave it as .claude/skills/sf-soql/SKILL.md (or your agent's skills folder). This skill also uses 16 other files; get the full folder from GitHub.

name: sf-soql
description: 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.
license: MIT
metadata.version: 1.1.0
metadata.author: Jag Valaiyapathy
metadata.scoring: 100 points across 5 categories

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

Recommended Workflow

1. Generate the simplest correct query

Prefer:

only needed fields
clear WHERE criteria
reasonable LIMIT when appropriate
relationship depth only as deep as necessary

2. Choose the right query shape

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

3. Optimize for selectivity and safety

Check:

indexed / selective filters
no unnecessary fields
no avoidable wildcard or scan-heavy patterns
security enforcement expectations

4. Validate execution path if needed

If the user wants runtime verification, hand off execution to:

sf-data

Show full SKILL.md (171 more words)Show less

High-Signal Rules

never use SELECT * style thinking; query only required fields
do not query inside loops in Apex contexts
prefer filtering in SOQL rather than post-filtering in Apex
use aggregates for counts and grouped summaries instead of loading unnecessary records
evaluate wildcard usage carefully; leading wildcards often defeat indexes
account for security mode / field access requirements when queries move into Apex

Output Format

When finishing, report in this order:

Query purpose
Final SOQL/SOSL
Why this shape was chosen
Optimization or security notes
Execution suggestion if needed

Suggested shape:

text

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>

Cross-Skill Integration

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

Reference Map

Start here

Specialized guidance

Score Guide

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

Files

SKILL.md and 16 other files (references, assets) in skills/sf-soql of Jaganpro/sf-skills.

SKILL.md
CREDITS.md
README.md
assets/aggregate-queries.soql
assets/basic-queries.soql
assets/bulkified-query-pattern.cls
assets/optimization-patterns.soql
assets/relationship-queries.soql
assets/selector-class.cls
hooks/scripts/post-tool-validate.py
references/anti-patterns.md
references/cli-commands.md
references/field-coverage-rules.md
references/query-optimization.md
references/selector-patterns.md
references/soql-reference.md
references/soql-syntax-reference.md

Open the folder on GitHubat commit 53c9956

Compare with similar skills

Sf Soql next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Sf Soql compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Sf Soql this skillJaganpro/sf-skills	424	—	~1.2k	Automated safety check: Pass	MIT	5 mo ago
SQL Optimization Patternsynulihao/AgentSkillOS	617	11 repos	~3.3k	Automated safety check: Pass	None	7 mo ago
Cloud Trace Queryinggoogle/skills	21k	—	~1.7k	Automated safety check: Pass	Apache-2.0	yesterday
Query Engine Designrevfactory/claude-code-harness	120	—	~474	Automated safety check: Pass	None	7 mo ago
Query Plan Snapshot CLIeclipse-rdf4j/rdf4j	420	—	~1.5k	Automated safety check: Pass	BSD-3-Clause	yesterday
Wp Acf And Content Modelingjorgerosal/wordpress-skills	102	—	~3.2k	Automated safety check: Pass	MIT	4 mo ago

Similar skills

SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
617 GitHub starsUsed in 11 repos~3.3k tokens
DatabasesAuto-check passed
Cloud Trace Querying
google/skills
Official
Query Cloud Trace spans, filter by latency thresholds or error status, correlate distributed traces with Cloud Logging, and diagnose latency bottlenecks across Google Cloud services.
21k GitHub stars~1.7k tokensUpdated yesterday
DatabasesAuto-check passed
Query Engine Design
revfactory/claude-code-harness
SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.
120 GitHub stars~474 tokensUpdated 7 mo ago
DatabasesAuto-check passed
Query Plan Snapshot CLI
eclipse-rdf4j/rdf4j
Use QueryPlanSnapshotCli to capture and compare RDF4J query plans, then assess likely performance improvements/regressions from execution verification and semantic plan diffs.
420 GitHub stars~1.5k tokensUpdated yesterday
DatabasesAuto-check passed
Wp Acf And Content Modeling
jorgerosal/wordpress-skills
WordPress ACF and content modeling review. An agent skill from jorgerosal/wordpress-skills.
102 GitHub stars~3.2k tokensUpdated 4 mo ago
DatabasesAuto-check passed
Jpa Patterns
affaan-m/ECC
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
276k GitHub starsUsed in 5 repos~1.2k tokens
DatabasesAuto-check passed

Questions about Sf Soql

What does Sf Soql do?

SOQL query generation, optimization, and analysis with 100-point scoring. Sf Soql is an agent skill from Jaganpro/sf-skills. SOQL query generation, optimization, and analysis with 100-point scoring.

When should I use Sf Soql?

Sf Soql fits situations like: debugs SOQL/SOSL queries; touches .soql files; asks about relationship queries; query performance.

How do I install Sf Soql in Claude Code?

Run `npx skills add Jaganpro/sf-skills --skill sf-soql -a claude-code`. Or copy the skill folder (skills/sf-soql in Jaganpro/sf-skills) into .claude/skills/sf-soql in your project. Claude Code loads it when a task matches its description.

How do I install Sf Soql in Codex?

Run `npx skills add Jaganpro/sf-skills --skill sf-soql -a codex`. Or copy the skill folder (skills/sf-soql in Jaganpro/sf-skills) into .agents/skills/sf-soql in your project. Codex loads it when a task matches its description.

Can I use Sf Soql in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add Jaganpro/sf-skills --skill sf-soql -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sf-soql, .gemini/skills/sf-soql, .github/skills/sf-soql and .opencode/skills/sf-soql in your project.

What does Sf Soql need to run?

Going by SKILL.md and its folder, Sf Soql needs Python for the scripts in its folder. Our summary lists: Python 3.

Does Sf Soql access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Sf Soql safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Sf Soql use?

Sf Soql is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Sf Soql use?

About 1.2k tokens (SKILL.md is roughly 4.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 15k tokens, read only when the agent opens those files.

What are the alternatives to Sf Soql?

Skills that share tags, products or a category with Sf Soql: SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), Cloud Trace Querying (google/skills, 21k stars), Query Engine Design (revfactory/claude-code-harness, 120 stars) and Query Plan Snapshot CLI (eclipse-rdf4j/rdf4j, 420 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Sf Soql?

Jaganpro (a GitHub user) maintains it in Jaganpro/sf-skills, which has 424 GitHub stars. The repository holds 36 skills in this directory. The repository was last updated on April 27, 2026.

Source: Jaganpro/sf-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Sf Soql

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

sf-soql: Salesforce SOQL Query Expert

When This Skill Owns the Task

Required Context to Gather First

Recommended Workflow

1. Generate the simplest correct query

2. Choose the right query shape

3. Optimize for selectivity and safety

4. Validate execution path if needed

High-Signal Rules

Output Format

Cross-Skill Integration

Reference Map

Start here

Specialized guidance

Score Guide

Files

Compare with similar skills

Similar skills

More from Jaganpro/sf-skills

Related

Questions about Sf Soql