salesforce-data-cloud -by-cdata

This MCP server provides a read-only interface to Salesforce Data Cloud data via the CData JDBC Driver. After configuring and running the server, clients (such as Claude Desktop or any MCP-compatible client) can query live Salesforce Data Cloud data without writing SQL. The server exposes tools that let you discover available tables and columns and then run read-only queries against them. Use the built-in tools to list tables, inspect columns, and execute SELECT queries, receiving results in CSV format for easy consumption by the AI or client UI. The setup is designed to be straightforward: configure a JDBC connection to Salesforce Data Cloud, create a .prp file describing the connection, run the MCP JAR with that PRP, and then point your MCP client to the server via a Claude Desktop-style configuration. The main tools are named based on the server prefix you configure (for example, if your server prefix is salesforcedatacloud, you will see salesforcedatacloud_get_tables, salesforcedatacloud_get_columns, and salesforcedatacloud_run_query).

Prerequisites:\n- Java Runtime Environment (JRE) or JDK installed and available on the PATH.\n- Maven (optional, for building from source).\n- The CData JDBC Driver for Salesforce Data Cloud installed and licensed on your machine.\n\nSteps:\n1) Build the MCP server (if starting from source):\nbash\ngit clone https://github.com/cdatasoftware/salesforce-data-cloud-mcp-server-by-cdata.git\ncd salesforce-data-cloud-mcp-server-by-cdata\nmvn clean install\n\nThis should produce a JAR similar to CDataMCP-jar-with-dependencies.jar.\n\n2) Download and install the CData JDBC Driver for Salesforce Data Cloud:\n- Visit https://www.cdata.com/drivers/salesforcedc/download/jdbc\n- Follow install instructions for your OS.\n- License the driver as required (see next step).\n\n3) License the CData JDBC Driver:\n- Navigate to the Driver's lib folder (examples):\n - Windows: C:\Program Files\CData\CData JDBC Driver for Salesforce Data Cloud\\n - Mac/Linux: /Applications/CData JDBC Driver for Salesforce Data Cloud/\n- Run:\nbash\njava -jar cdata.jdbc.salesforcedatacloud.jar --license\n\n- Enter your name, email, and a license key (TRIAL or purchased key).\n\n4) Create the PRP configuration file (e.g., salesforce-data-cloud.prp) with your connection details:\nenv\nPrefix=salesforcedatacloud\nServerName=CDataSalesforceDataCloud\nServerVersion=1.0\nDriverPath=PATH\\TO\\cdata.jdbc.salesforcedatacloud.jar\nDriverClass=cdata.jdbc.salesforcedatacloud.SalesforceDataCloudDriver\nJdbcUrl=jdbc:salesforcedatacloud:InitiateOAuth=GETANDREFRESH;\nTables=\n\nReplace PATH with the actual paths on your system, and customize the JdbcUrl as needed.\n\n5) Run the MCP server:\nbash\njava -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/salesforce-data-cloud.prp\n\nNote: The server uses standard I/O and is intended to run on the same machine as the MCP client.\n\n6) If using Claude Desktop or another client, add the server to your config as described in the documentation.\n

Tips and notes:\n- This is a read-only MCP server by default. To enable write/update/delete functionality, refer to the full MCP Server for Salesforce Data Cloud from CData.\n- If you cannot see the MCP server in Claude Desktop, ensure Claude Desktop is fully restarted after adding the new server.\n- OAuth connections may require browser authentication during connection setup.\n- The PRP file (salesforce-data-cloud.prp) must correctly reference the JDBC driver path and JDBC URL.\n- Since the server uses stdio, client and server must run on the same machine, or you must use a suitable IPC-compatible client.\n- For troubleshooting, verify that the Java process has access to the driver JAR and that the license has been applied correctly.