execute_soql
Executes SOQL queries on Salesforce objects, supporting standard and custom fields.
Instructions
Execute a SOQL query. Supports both standard and custom fields (custom fields end with __c in their API names). To see which fields this org actually populates on an object, read the salesforce://field-catalog/{objectName} resource — it is ranked, far smaller than a full schema, and works for any object. That catalog is a usage filter rather than a field list: standard fields remain queryable whether or not they appear in it. Use describe_object when you want an object's complete schema.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SOQL query to execute. For custom fields, use the API name (e.g., Project_Status__c) | |
| detail | No | Response detail level (default: summary) | |
| pageSize | No | Number of records per page (default: 25) | |
| pageNumber | No | Page number to retrieve (default: 1) |