sf-soql

Translate natural language requests into optimized SOQL queries for Salesforce.

423|97|Updated Nov 30, 2025
One-click install
npx skills add https://github.com/Jaganpro/sf-skills --skill sf-soql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sf-soql
Source: https://github.com/Jaganpro/sf-skills/tree/main/sf-soql
Command: npx skills add https://github.com/Jaganpro/sf-skills --skill sf-soql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers rapidly generate and optimize Salesforce SOQL queries from plain language, ensuring performance and security under governor limits.

Core Features & Use Cases

  • NL → SOQL: Convert natural language requests into precise SOQL queries
  • Optimization: Filter by indexed fields, avoid non-selective queries, and plan query performance
  • Relationship queries & Aggregates: Child-to-parent and parent-to-child queries; aggregate functions with GROUP BY

Quick Start

Ask Claude for a query like: 'Show accounts with their contacts created this quarter' and receive a ready-to-run SOQL.

Frequently Asked Questions about sf-soql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert natural language into SOQL queries?

SOQL query generation translates plain language requests into optimized Salesforce queries. Describe what data you need—such as 'accounts with contacts created this quarter'—and receive syntactically correct, performance-tuned SOQL ready to execute.

Can I query Salesforce relationships and aggregates in a single query?

Yes. SOQL supports child-to-parent and parent-to-child relationship traversals alongside aggregate functions like COUNT, SUM, and MAX with GROUP BY clauses, enabling complex data retrieval without multiple round trips.

How do I optimize SOQL queries to avoid governor limits?

Query optimization filters by indexed fields, enforces selective WHERE conditions, applies proper LIMIT and ORDER BY clauses, and validates performance under Salesforce governor constraints before execution.

Does SOQL query generation enforce field-level security and sharing rules?

Yes. Generated queries apply FLS (Field-Level Security) and sharing enforcement automatically, ensuring returned data respects Salesforce security constraints and user permissions.

What's the best way to plan query performance before running SOQL?

Query planning validates syntax, identifies non-selective filters, tests execution against governor limits, and provides performance analysis tooling so you catch inefficiencies before production deployment.