Common SOQL query patterns and examples for typical use cases. Use when building queries for common scenarios.
From salesforce-soqlnpx claudepluginhub grailautomation/claude-plugins --plugin salesforce-soqlThis skill uses the workspace's default tool permissions.
aggregate-queries.mdbasic-queries.mddate-queries.mdrelationship-queries.mdCommon query patterns organized by use case.
SELECT Id, Name, Industry FROM Account WHERE Name LIKE '%Acme%'
SELECT Id, Name, (SELECT Id, FirstName, LastName FROM Contacts) FROM Account WHERE Id = '001xxx'
SELECT Status, COUNT(Id) FROM Case GROUP BY Status
SELECT Id, Name, CreatedDate FROM Lead WHERE CreatedDate >= LAST_N_DAYS:7 ORDER BY CreatedDate DESC
SELECT Id, Name, Email FROM Contact WHERE Email LIKE '%@acme.com'
SELECT Id, Name FROM Account WHERE Id NOT IN (SELECT AccountId FROM Opportunity)
SELECT Id, Name, Amount, CloseDate FROM Opportunity
WHERE IsWon = true AND CloseDate = THIS_QUARTER
ORDER BY Amount DESC
SELECT Id, DeveloperName, Name FROM RecordType WHERE SObjectType = 'Opportunity'