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.

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