Provides standardized SOQL query templates and best practices for efficient Salesforce data retrieval.
The Salesforce SOQL Query Patterns skill equips Claude with a comprehensive library of common Salesforce Object Query Language (SOQL) patterns. It covers everything from basic filtering and sorting to complex parent-child relationship queries, aggregate functions, and sophisticated date-based filtering. This skill is essential for developers looking to build performant, governor-limit-conscious queries for Apex development, integration middleware, or data analysis tasks within the Salesforce ecosystem.
Key Features
01Aggregate function patterns including COUNT, SUM, and GROUP BY
020 GitHub stars
03Subquery patterns for identifying records without related data
04Relationship queries for parent-to-child and child-to-parent data
05Optimized search templates using wildcards and RecordType filtering
06Advanced date filtering using Salesforce-specific date literals
Use Cases
01Generating data extraction queries for Salesforce integration and ETL tasks
02Optimizing database performance by using standardized query patterns
03Drafting complex SOQL statements for Apex controllers and triggers
