README

mcp-tools-salesforce

Custom MCP Server that Connects to Salesforce Scratch Orgs — and Lets AI Generate Test Data

📝 Read the full write-up on Medium

A custom MCP server built with FastMCP that connects to a Salesforce scratch org via JWT Bearer Flow. It uses MCP Sampling to let an LLM autonomously look up the data model, generate realistic nested test records, and insert them via the Composite Tree REST API. You describe the scenario in plain English. The server does the rest.

notes

Tools

Tool	Description
`query_salesforce(soql_query)`	Runs a SOQL query against the connected scratch org and returns matching records
`describe_sobject(sobject_name)`	Returns createable fields for an sObject (name, type, nillable)
`get_basic_datamodel()`	Returns a lightweight field map for Account, Contact, Case, User
`generate_nested_record(request)`	Uses LLM sampling to draft a Composite Tree compatible nested record from a natural-language request
`insert_record(root_sobject, record)`	Posts the payload to `composite/tree/{root_sobject}`

Note: generate_nested_record uses MCP Sampling with tools + structured output. Authentication via JWT Bearer Flow.

Resources

https://help.salesforce.com/s/articleView?id=xcloud.jwt_connectedapp_enable.htm&type=5
https://generect.com/blog/salesforce-mcp-integration/
https://www.jlowin.dev/blog/the-inverted-agent

Interesting discussion by awesome Pamela Fox:

"Can VS Code skills be a replacement for MCP servers?":

https://github.com/orgs/microsoft-foundry/discussions/280#discussioncomment-16338085

https://youtu.be/Uufh7cPUnmQ?si=GuBGanruQCn0gDYT&t=885

mcp-tools-salesforce

README

mcp-tools-salesforce

Custom MCP Server that Connects to Salesforce Scratch Orgs — and Lets AI Generate Test Data

Tools

Resources

Recommended Servers