mcp-salesforce mcp

v1.0.0 · MCP Tool · crm · registry.pascalai.org

Salesforce REST API — SOQL queries, CRUD on any sObject, SOSL search and schema describe. Authenticates via OAuth2 Username-Password flow. Operations: query (SOQL), search (SOSL), get, create, update, delete, describe (sObject schema), list_objects.

salesforcecrmsoqlcloudenterprise

Input Parameters

ParameterTypeDescription
operationrequired string query: run SOQL; search: SOSL search; get: get record by ID; create: create record; update: update record; delete: delete record; describe: get sObject schema; list_objects: list all sObject types. One of: query, search, get, create, update, delete, describe, list_objects.
usernamerequired string Salesforce username.
passwordrequired string Salesforce password (append security token if required, e.g. passXXXXXXXX).
clientIdrequired string Connected App consumer key.
clientSecretrequired string Connected App consumer secret.
sandboxoptional boolean Use sandbox instance (login.salesforce.com vs test.salesforce.com). Default: false. Default: False.
sObject_optional string Salesforce object type (e.g. Account, Contact, Lead, Opportunity). Required for get/create/update/delete/describe.
recordIdoptional string Record ID for get, update, delete.
soqloptional string SOQL query string for query operation (e.g. SELECT Id, Name FROM Account LIMIT 10).
sosloptional string SOSL query string for search operation (e.g. FIND {Alice} IN ALL FIELDS).
bodyoptional string JSON object with field values for create/update operations.
fieldsoptional string Comma-separated field names to retrieve for get (default: all).

Output Fields

FieldTypeDescription
records array[object]
record object
id string
totalSize integer
schema object
ok boolean
error string

Examples

SOQL query

// Input
{
  "operation": "query",
  "username": "user@org.com",
  "password": "pass+token",
  "clientId": "xxx",
  "clientSecret": "yyy",
  "soql": "SELECT Id, Name FROM Account LIMIT 5"
}

// Output
{
  "totalSize": 5,
  "records": [
    {
      "Id": "001...",
      "Name": "Acme"
    }
  ]
}

Install & Discovery

Install

ppm install mcp-salesforce

Get JSON Schema

GET /v1/packages/mcp-salesforce/1.0.0/schema

Discover by keyword

GET /v1/mcp/discover?q=salesforce
Discovery hint: Install with ppm install mcp-salesforce or invoke remotely via POST /v1/invoke/mcp-salesforce on the MCP Service.

PascalAI Usage

uses toolslib;
var Tool := LoadTool('mcp-salesforce');
var R := Tool.Call(JsonObj(['operation','query','username','u@org.com','password','p','clientId','c','clientSecret','s','soql','SELECT Id,Name FROM Account LIMIT 5']));
Writeln(R.ToJSON);