Salesforce MCP服务器

Microsoft Copilot Studio
    → Custom MCP Connector (Streamable HTTP)
        → Azure App Service / Container App
            → This MCP Server (HTTP transport)
                → Salesforce REST API (via jsforce)

git clone <this-repo>
cd mcp-server-salesforce
npm install

cp .env.example .env

SALESFORCE_CONNECTION_TYPE=User_Password
SALESFORCE_USERNAME=your-username@salesforce.com
SALESFORCE_PASSWORD=your-password
SALESFORCE_TOKEN=your-security-token
SALESFORCE_INSTANCE_URL=https://login.salesforce.com
PORT=3000

npm run build
node dist/http-server.js

# Health check
curl http://localhost:3000/health

# Initialize MCP session
curl -X POST http://localhost:3000/ \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{"protocolVersion":"2025-03-26","capabilities":{},"clientInfo":{"name":"test","version":"1.0"}}}'

# Login to Azure
az login

# Create resource group
az group create --name rg-sf-mcp --location uksouth

# Create App Service plan
az appservice plan create --name plan-sf-mcp --resource-group rg-sf-mcp --sku B1 --is-linux

# Create web app
az webapp create --name sf-mcp-server --resource-group rg-sf-mcp --plan plan-sf-mcp --runtime "NODE:18-lts"

# Configure environment variables
az webapp config appsettings set --name sf-mcp-server --resource-group rg-sf-mcp --settings \
  SALESFORCE_CONNECTION_TYPE=User_Password \
  SALESFORCE_USERNAME=your-username@salesforce.com \
  SALESFORCE_PASSWORD=your-password \
  SALESFORCE_TOKEN=your-security-token \
  SALESFORCE_INSTANCE_URL=https://login.salesforce.com \
  PORT=8080

# Deploy
az webapp deploy --name sf-mcp-server --resource-group rg-sf-mcp --src-path ./deploy.zip

az webapp config appsettings set --name <your-app-name> --resource-group <your-rg> --settings 'SALESFORCE_PASSWORD=<current-password>' 'SALESFORCE_TOKEN=<new-token>'

$base = 'https://<your-app-name>.azurewebsites.net/'
$h  = @{ 'Content-Type' = 'application/json'; 'Accept' = 'application/json, text/event-stream' }
$init = Invoke-WebRequest -Uri $base -Method Post -Headers $h -UseBasicParsing -Body '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{"protocolVersion":"2024-11-05","capabilities":{},"clientInfo":{"name":"diag","version":"1.0"}}}'
$sid = $init.Headers['Mcp-Session-Id']
$h2 = $h + @{ 'Mcp-Session-Id' = "$sid" }
Invoke-WebRequest -Uri $base -Method Post -Headers $h2 -UseBasicParsing -Body '{"jsonrpc":"2.0","method":"notifications/initialized"}' | Out-Null
$call = Invoke-WebRequest -Uri $base -Method Post -Headers $h2 -UseBasicParsing -Body '{"jsonrpc":"2.0","id":2,"method":"tools/call","params":{"name":"salesforce_query_records","arguments":{"objectName":"Account","fields":["Id","Name"],"limit":3}}}'
$call.Content

az webapp log tail --name <your-app-name> --resource-group <your-rg>

├── src/
│   ├── index.ts              # Original STDIO MCP server (from tsmztech)
│   ├── http-server.ts        # Streamable HTTP wrapper (added for Copilot Studio)
│   ├── tools/                # Tool implementations
│   │   ├── query.ts          # SOQL queries
│   │   ├── dml.ts            # Insert/Update/Delete/Upsert
│   │   ├── search.ts         # Object search
│   │   ├── searchAll.ts      # SOSL search
│   │   ├── describe.ts       # Schema metadata
│   │   ├── aggregateQuery.ts # Aggregate queries
│   │   ├── manageObject.ts   # Custom object management
│   │   ├── manageField.ts    # Custom field management
│   │   ├── readApex.ts       # Read Apex source
│   │   ├── writeApex.ts      # Write Apex source
│   │   └── ...
│   ├── types/                # TypeScript type definitions
│   └── utils/
│       └── connection.ts     # Salesforce connection factory
├── .env.example              # Example environment config
├── package.json
├── tsconfig.json
└── swagger.yaml              # OpenAPI spec for custom connector