sf-soql-optimization
CommunityOptimize SOQL queries for speed and scalability.
Authorjiten-singh-shahi
Version1.0.0
Installs0
System Documentation
What problem does it solve?
SOQL queries are often written without proper selectivity, leading to governor limit exceptions and slow performance. This skill guides you through identifying non-selective queries, analyzing query plans, and applying index strategies to improve efficiency.
Core Features & Use Cases
- Query plan analysis and index guidance to improve selectivity and reduce heap usage.
- Best practices for avoiding SOQL-in-loops, optimizing relationship queries, and handling large data volumes.
- Use cases include apex triggers, batch jobs, and service classes that read or manipulate large data sets.
Quick Start
Analyze a sample Apex class to find non-selective SOQL and apply the recommended refactorings.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sf-soql-optimization Download link: https://github.com/jiten-singh-shahi/salesforce-claude-code/archive/main.zip#sf-soql-optimization Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.