Does this skill handle complex relationship queries?

Yes, it supports both child-to-parent (dot notation) and parent-to-child (subqueries) traversals up to Salesforce's platform limits of 5 levels for parent relationships.

How does it help with Salesforce governor limits?

The skill applies a selectivity checklist, suggests appropriate LIMIT clauses, and provides efficient patterns to avoid common issues like the 101 SOQL queries error.

Can it ensure data security in queries?

Absolutely. It integrates security patterns such as WITH SECURITY_ENFORCED, USER_MODE, and explains how to use the stripInaccessible method for Apex-based security.

Does it support query performance analysis?

Yes, it includes a workflow to analyze query plans using the Salesforce CLI to interpret cardinality, cost, and index usage to ensure query selectivity.

Salesforce SOQL Expert

Name: Salesforce SOQL Expert
Author: Jaganpro

byJaganpro

•

Database Management

Generates, optimizes, and secures Salesforce Object Query Language (SOQL) queries using natural language and performance analysis.

The sf-soql skill empowers Claude Code to function as an expert database engineer for Salesforce environments. It specializes in converting natural language prompts into high-performance SOQL queries, handling complex parent-child relationship traversals, and ensuring all queries comply with Salesforce governor limits and security requirements like FLS and sharing rules. Whether you need to analyze query plans, aggregate data, or enforce field-level security, this skill provides a structured workflow for efficient and production-ready Salesforce data retrieval within the Claude Code environment.

Key Features

01Natural language to optimized SOQL generation

02Performance analysis and query plan interpretation

03Multi-level relationship traversal (parent-child and child-parent)

0432 GitHub stars

05Built-in security enforcement including WITH SECURITY_ENFORCED and USER_MODE

06Governor limit-aware query design and optimization patterns

Use Cases

01Converting plain English requirements into complex multi-object SOQL queries

02Generating secure, production-ready queries for Apex controllers and triggers

03Troubleshooting and optimizing slow-running queries using query plan analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jaganpro/sf-skills sf-soql

For use in Claude.ai and ChatGPT

Download Skill