Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From salesforce-soql
Common SOQL query patterns and examples for typical use cases. Use when building queries for common scenarios.
npx claudepluginhub grailautomation/claude-plugins --plugin salesforce-soqlHow 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.
Generates, 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.
Share bugs, ideas, or general feedback.
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'