sf-soql: Salesforce SOQL Query Expert Agent Skill
Advanced SOQL skill with natural language to query generation, query optimization, relationship traversal, aggregate functions, and…
- Context cost
- 18k tokensestimated from the bundle, loaded when it triggers
- Bundle
- 10 of 16 fileshanded out here; the rest is at its source
- Licence
- MITthe author’s own terms
- Last change
- —v1.0.0
- Servers it uses
- Noneruns standalone
What it does
Advanced SOQL skill with natural language to query generation, query optimization, relationship traversal, aggregate functions, and performance analysis. Build efficient queries that respect governor limits and security requirements.
Installed, it changes the agent in these ways.
What this skill changes about the agent has not been set out here as a list. Its SKILL.md, shown below, says it in the author’s own words.
And these are the jobs people reach for it for.
The skill itself
A skill is instructions the model reads, so you can see what you are getting: below is the start of its SKILL.md. The front matter loads with every session, the body loads when the skill triggers, and the whole file comes with the install.
Nothing in a skill executes. The client loads the text and the model follows it, so a skill can be audited the way a runbook is — by reading it.
What it costs in context
Skills are not billed by the call. They are paid for in context: every token the instructions occupy is a token your code, your diff and your conversation cannot use. Here is what this one takes and when it takes it.
18k tokens, estimated from the bundle at four bytes to the token, held for the rest of the session once it triggers. Heavy. Teams tend to install this one per project rather than globally, and load it only when the job comes up.
A server charges by the month. A skill charges once per session, in context, and then keeps charging it for as long as the session lives.
Before and after
The same question, put to the same model twice: once as it comes, and once with these instructions loaded.
No worked example has been published for this skill yet.
The procedure it runs
The procedure has not been set out here step by step. It is in the body of its SKILL.md: the start of it is shown above, and the whole file comes with the install.
These steps are written for a model to follow, not executed by a runtime. It can still be told to skip one, and it will say so when it does.
Servers it uses
None. This skill calls no MCP servers at all.
Everything it needs is in the instructions, so it works in a project with nothing connected — the model reads the file and changes how it works with what it can already reach.
Its SKILL.md does not declare which tools it asks the agent for, so what it touches is whatever the instructions themselves ask for — read them before you install it.
This SKILL.md carries no allowed-tools line, so neither is declared. A skill grants no permissions of its own — it can only ask for tools your client already has.
What it will not do
Every skill is narrow, and the useful ones say where they stop. These are the jobs this one is the wrong tool for.
What this skill is not for has not been published here. Nothing is implied by that: it is a section the author has not filled in.
What is in the bundle
The download carries 10 of the 16 files in its source folder; the list here names 10 files, 84.1 kB on disk. Mostly text — the instructions the model reads — with 1 script in it that your client would run only if the instructions tell it to. The other 6 are not in the download — listed after these, with why.
- SKILL.md15.2 kB
- CREDITS.md3.6 kB
- .claude-plugin/plugin.json0.5 kB
- docs/anti-patterns.md9.1 kB
- docs/cli-commands.md6.8 kB
- docs/field-coverage-rules.md15.0 kB
- docs/selector-patterns.md14.4 kB
- docs/soql-reference.md6.4 kB
- hooks/hooks.json1.0 kB
- hooks/scripts/post-tool-validate.py12.1 kB
Not in the download
Not carried is a type a skill download does not hold. Marked read: its SKILL.md or scripts name the file, so without it the skill works only in part. Take them from its source.
- templates/aggregate-queries.soqlread · not carried
- templates/basic-queries.soqlread · not carried
- templates/bulkified-query-pattern.clsread · not carried
- templates/optimization-patterns.soqlread · not carried
- templates/relationship-queries.soqlread · not carried
- templates/selector-class.clsread · not carried
A skill installs nothing and depends on nothing: it is a folder your client reads. This one carries 1 script beside the text, so the download is 10 files — not the whole of its source: 6 files are left out, and the skill reads 6 of them. They are listed under the files, with why. The MIT licence covers the templates and examples as well as the instructions.
Install
Installing copies the bundle into your project. Nothing runs at install time — the files sit on disk until the model reads them.
# sf-soql: Salesforce SOQL Query Expert · 18k tokens when loaded · macOS, Linux
mkdir -p .claude/skills && t=$(mktemp -d) &&
curl -fsSL -o "$t/bundle.tar.gz" https://mcprush.com/api/skills/sf-soql-salesforce-soql-query-expert/bundle.tar.gz &&
tar -xzf "$t/bundle.tar.gz" -C "$t" && [ -d "$t/sf-soql-salesforce-soql-query-expert" ] &&
{ [ ! -e .claude/skills/sf-soql-salesforce-soql-query-expert ] || { mv .claude/skills/sf-soql-salesforce-soql-query-expert "$t/.previous" && echo "Previous copy moved to $t/.previous"; }; } &&
mv "$t/sf-soql-salesforce-soql-query-expert" .claude/skills/ && echo "Installed .claude/skills/sf-soql-salesforce-soql-query-expert"npx mcprush@latest skill add jaganpro/sf-soql-salesforce-soql-query-expertWindows PowerShell says 'running scripts is disabled on this system'? Run Set-ExecutionPolicy -Scope CurrentUser RemoteSigned once, or type npx.cmd instead of npx (codex.cmd, gemini.cmd, grok.cmd likewise). PowerShell 7 needs neither. Writes to .claude/skills/sf-soql-salesforce-soql-query-expert/ in the current project. For every project instead, run mkdir -p ~/.claude/skills && t=$(mktemp -d) && curl -fsSL -o "$t/bundle.tar.gz" https://mcprush.com/api/skills/sf-soql-salesforce-soql-query-expert/bundle.tar.gz && tar -xzf "$t/bundle.tar.gz" -C "$t" && [ -d "$t/sf-soql-salesforce-soql-query-expert" ] && { [ ! -e ~/.claude/skills/sf-soql-salesforce-soql-query-expert ] || { mv ~/.claude/skills/sf-soql-salesforce-soql-query-expert "$t/.previous" && echo "Previous copy moved to $t/.previous"; }; } && mv "$t/sf-soql-salesforce-soql-query-expert" ~/.claude/skills/ && echo "Installed ~/.claude/skills/sf-soql-salesforce-soql-query-expert" (macOS, Linux) — or add --global to the npx line. The curl line replaces .claude/skills/sf-soql-salesforce-soql-query-expert/ only after the download succeeds, so files left there by another skill of the same name, or by an older release, do not mix in. A copy already there is moved aside, not deleted, and the line prints where. It appears as sf-soql in Gemini CLI, Codex, Copilot and Grok (its own name); Claude Code lists it by the folder name, sf-soql-salesforce-soql-query-expert. Not in this download: 6 files of its source, 6 of them read by its SKILL.md or scripts (the full list, and why). Take them from its source.
Which clients pick it up on their own
A skill is a folder of text. Most of these read a skills folder and pick it up without being told; the rest take the same folder another way — an upload in the app, a parameter on an API call — and then choose it by its description just the same.
Versions
v1.0.0 is what is on the shelf; no release here carries a date. Instructions change more often than APIs do — a skill can be rewritten entirely without anything it depends on moving.
- No earlier releases have been published to the marketplace.
The install command always fetches the release that is current the day you run it — v1.0.0 today — and cannot ask for an earlier one. The copy on your disk does not change until you run it again.
Reviews
Nobody has reviewed this skill yet. The rating is the mean of the reviews written here, so there is none until somebody writes the first.
A review is tied to an account so it can be answered, edited and taken down by the person who wrote it.
Sign inAnybody with an account, one review each. It carries the version that was current when you wrote it, and the publisher may reply once.