List all available Salesforce objects.

Returns: List of dictionaries containing object metadata including name, label, whether it's custom, and other attributes.

Get all fields for a specific Salesforce object.

Args: object_name: The API name of the Salesforce object (e.g., 'Account', 'Contact')

Returns: Dictionary containing object name and list of field definitions.

Get comprehensive help documentation for SOQL (Salesforce Object Query Language).

Returns: Dictionary containing SOQL syntax guide, examples, best practices, and common patterns.

Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sosl_intro.htm

Execute a SOQL query against Salesforce.

Args: query: The SOQL query string (e.g., 'SELECT Id, Name FROM Account LIMIT 10')

Returns: Dictionary containing query, rows, row_count, and columns.

IMPORTANT: Before constructing SOQL queries, use the get_soql_help() tool to understand: - Basic SOQL syntax and structure - How to write WHERE clauses and filters - Relationship queries (child-to-parent and parent-to-child) - Aggregate functions and GROUP BY - Common patterns and best practices

Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm

Important SOQL Rules: 1. CANNOT use SELECT * - You MUST specify column names explicitly 2. Aggregate queries (using COUNT, SUM, AVG, etc.) CANNOT use LIMIT