skills.rest
Collabalist
CollabalistCOMMUNITY
Explore all skills by this author →
GitHub

querying-soql

Convert natural language queries into optimized SOQL for Salesforce objects.

Updated Jun 1, 2026
Search Tags:#query optimization#Salesforce#SOQL#query authoring#Apex development
One-click install
npx skills add https://github.com/Collabalist/SFDC --skill querying-soql-collabalist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: querying-soql
Source: https://github.com/Collabalist/SFDC/tree/main/.agents/skills/querying-soql
Command: npx skills add https://github.com/Collabalist/SFDC --skill querying-soql-collabalist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill empowers Apex developers to write efficient, maintainable SOQL using vanilla Apex patterns, reducing query load times and ensuring optimal performance.

Core Features & Use Cases

  • Natural Language to SOQL: Convert plain-English requirements into performant SOQL.
  • Query Optimization: Improve selectivity, LIMIT usage, and field selection.
  • Security Guidance: Provide best practices for secure SOQL usage.
  • 100-Point Scoring: Evaluate query performance, correctness, security, and readability.

Quick Start

Skill: querying-soql Request: "Find Accounts with open Opportunities created this quarter"

Frequently Asked Questions about querying-soql

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

FAQPage Schema
How do I write optimized SOQL queries for Salesforce from plain English?▼

You can convert natural language requirements directly into performant SOQL for Salesforce objects. This handles relationship queries, aggregates, and query plan analysis while ensuring compliance with governor limits and security best practices.

What is the best way to analyze SOQL query plans for Salesforce governor limits?▼

Analyzing SOQL query plans involves evaluating query performance, correctness, security, and readability through a 100-point scoring system. This ensures queries comply with Salesforce governor limits and follow best practices for secure usage.

How do I handle SOQL relationship queries and aggregates in Apex development?▼

SOQL relationship queries and aggregates are handled by transforming natural language inputs into structured Salesforce queries. This approach ensures maintainable vanilla Apex patterns that reduce query load times and adhere to governor limits.

Can I optimize Salesforce SOQL selectivity and field selection automatically?▼

Yes, query optimization improves SOQL selectivity, LIMIT usage, and field selection automatically. This ensures Apex developers write efficient, maintainable SOQL using vanilla Apex patterns, reducing query load times and ensuring optimal performance.

Why does my SOQL query fail Salesforce governor limits and how can I fix it?▼

SOQL queries fail Salesforce governor limits due to inefficient selectivity or unoptimized field selection. Fixing them involves analyzing query plans and applying best practices for secure SOQL usage to ensure compliance and optimal performance.

Related Skills

Explore More Software Engineering Skills→
AstorYHAstorYH
15

salesforce-object-fetch

Retrieve Salesforce object records using SOQL queries with dynamic filtering.

Community
Intermediate
jiten-singh-shahijiten-singh-shahi
13

sf-soql-optimization

Identify and optimize inefficient SOQL queries in Salesforce Apex code.

Community
Advanced
pingqLINpingqLIN

apex

Guide Salesforce Apex development with best practices for bulkification, governor limits, and SOQL optimization.

Community
Advanced
bhanu91221bhanu91221
2

sosl-patterns

Document SOSL FIND syntax, RETURNING clauses, and search groups for Salesforce objects.

Community
Advanced