Soql Query Optimization

Quality score: 70/100 · Category: General · Sub-category: general-misc

Use when a SOQL query is running slowly, causing timeouts, or returning UNABLE_TO_LOCK_ROW errors in large data volume orgs. Covers index-aware query writing, selectivity rules, the Query Plan tool, skinny tables, and dynamic field-set queries. Triggers: slow soql query, query timeout, non-selective query, query plan tool, index usage, soql optimization, large object performance. NOT for Apex CPU or heap governor limit issues (use apex-cpu-and-heap-optimization) or for writing basic SOQL (use soql-fundamentals).

What this skill does

Soql Query Optimization is a production-ready Claude Code skill (quality score 70/100) in the general-misc sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/soql-query-optimization/ and loads when your prompt matches the skill's trigger.

When to invoke it: Use when a SOQL query is running slowly, causing timeouts, or returning UNABLE_TO_LOCK_ROW errors in large data volume orgs. Covers index-aware query writing, selectivity rules, the Query Plan tool, skinny tables, and dynamic field-set queries.

Who uses this skill

The Soql Query Optimization skill is built for Claude Code users and developers across all disciplines looking for general-purpose AI assistance. It is part of the open ClaudSkills registry, a community-curated catalog of 15,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/soql-query-optimization
curl -L https://claudskills.com/skills/soql-query-optimization/SKILL.md \
  -o ~/.claude/skills/soql-query-optimization/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/soql-query-optimization/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/soql-query-optimization/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\soql-query-optimization\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

More General skills

Browse all General skills in the ClaudSkills registry, or explore these top-rated picks from the same category:

Browse all General skills → Top 100 skills

Part of ClaudSkills — the open registry for Claude Code skills. · What's New · Install guide · About · llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills