Stats
Actions
Tags
From salesforce-soql
Common SOQL query patterns and examples for typical use cases. Use when building queries for common scenarios.
How this skill is triggered — by the user, by Claude, or both
Slash command
/salesforce-soql:query-patternsThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Common query patterns organized by use case.
Common 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'
npx claudepluginhub grailautomation/claude-plugins --plugin salesforce-soqlGenerates, optimizes, and analyzes Salesforce SOQL/SOSL queries from natural language. Automatically activates when working with .soql files, relationship queries, aggregates, or query performance.
Generates production-ready SOQL queries from natural-language requirements with selectivity analysis and governor-limit guidance. Does not execute queries.
Executes CRUD operations on Salesforce Accounts, Contacts, Leads, Opportunities using SOQL queries and jsforce/REST API. For Node.js apps needing Salesforce data manipulation.