Skip to main content
Glama

run_soql_query

Execute SOQL queries to retrieve Salesforce data for analysis, reporting, or integration purposes.

Instructions

Executes a SOQL query against Salesforce

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
queryYesThe SOQL query to execute

Implementation Reference

  • Handler logic for the run_soql_query tool: extracts query argument, executes sf_client.sf.query_all, formats results as JSON text content.
    if name == "run_soql_query":
        query = arguments.get("query")
        if not query:
            raise ValueError("Missing 'query' argument")
    
        results = sf_client.sf.query_all(query)
        return [
            types.TextContent(
                type="text",
                text=f"SOQL Query Results (JSON):\n{json.dumps(results, indent=2)}",
            )
        ]
  • Registration of run_soql_query tool in list_tools(), including name, description, and inputSchema.
    types.Tool(
        name="run_soql_query",
        description="Executes a SOQL query against Salesforce",
        inputSchema={
            "type": "object",
            "properties": {
                "query": {
                    "type": "string",
                    "description": "The SOQL query to execute",
                },
            },
            "required": ["query"],
        },
    ),
  • JSON Schema for run_soql_query input: requires 'query' string.
    inputSchema={
        "type": "object",
        "properties": {
            "query": {
                "type": "string",
                "description": "The SOQL query to execute",
            },
        },
        "required": ["query"],
    },

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/leilaabdel/MCP-Salesforce'

If you have feedback or need assistance with the MCP directory API, please join our Discord server