salesforce-mcp-server-by-cdata

What is salesforce-mcp-server-by-cdata?

salesforce-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live Salesforce data using natural language. It wraps the CData JDBC Driver for Salesforce, which exposes Salesforce data as relational SQL models.

How to use salesforce-mcp-server-by-cdata?

Clone the repository, build with Maven (mvn clean install), install and license the CData JDBC Driver for Salesforce, create a .prp configuration file with your JDBC connection string, then add the server to your Claude Desktop config (claude_desktop_config.json) using a java -jar command. Run or refresh Claude Desktop to access the tools.

Key features of salesforce-mcp-server-by-cdata

• Read-only querying of live Salesforce data via MCP
• Supports natural language questions—no SQL required
• Uses CData JDBC Driver for Salesforce as backend
• Provides tools: get_tables, get_columns, run_query (SQL SELECT)
• MIT licensed open-source project

Use cases of salesforce-mcp-server-by-cdata

• Ask LLMs to correlate closed won opportunities with account industry
• Query number of open tickets in a specific project
• Retrieve upcoming calendar events from Salesforce

FAQ from salesforce-mcp-server-by-cdata

Is this server read-only or can it write data?

This MCP server is read-only. For full read, write, update, delete, and action capabilities, CData offers a free beta MCP Server for Salesforce with simplified setup.

What are the dependencies and runtime requirements?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Salesforce installed and licensed on your machine.

How does the server communicate with clients?

The server uses stdio transport, so it can only be used with clients running on the same machine as the server.

Where does the data live? Does it store anything locally?

No local data storage. The server queries live Salesforce data directly through the JDBC driver; all data remains in Salesforce.

How do I authenticate to Salesforce?

Authentication is handled via the JDBC connection string builder. For OAuth-based sources, you will need to authenticate in your browser during connection setup.