Salesforce Pardot MCP Server by CData
@CDataSoftware
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Salesforce Pardot (beta): https://www.cdata.com/download/download.aspx?sku=GPZK-V&type=beta
Overview
What is Salesforce Pardot MCP Server by CData?
A read-only MCP server that allows LLMs like Claude Desktop to query live Salesforce Pardot data using natural language. It wraps the CData JDBC Driver for Salesforce Pardot and exposes the data as relational SQL models via a simple MCP interface.
How to use Salesforce Pardot MCP Server by CData?
Clone the repository, build the JAR with Maven, install and license the CData JDBC Driver for Salesforce Pardot, create a .prp file with your connection string, and configure Claude Desktop (or another MCP client) to run the server. Ask natural language questions about your Pardot data; the server uses stdio transport and runs on the same machine as the client.
Key features of Salesforce Pardot MCP Server by CData
- Read-only queries via natural language or SQL SELECT
- Exposes live Salesforce Pardot data as SQL tables
- Tools: get tables, get columns, run queries
- Built on the CData JDBC Driver for Salesforce Pardot
- Works with any MCP client supporting stdio
Use cases of Salesforce Pardot MCP Server by CData
- Ask “How many prospects were created this week?” without writing SQL
- Retrieve live Pardot campaign performance data for AI analysis
- Let an LLM answer questions about lead scoring trends in Pardot
- Build a conversational interface for marketing dashboards
FAQ from Salesforce Pardot MCP Server by CData
Is this server read-only or can I write data?
This server is read-only. For full CRUD capabilities (create, update, delete), use the free CData MCP Server for Salesforce Pardot (beta).
What are the runtime dependencies?
Java, Maven (to build), and the CData JDBC Driver for Salesforce Pardot (requires a license; trial available). The driver must be installed and licensed on the same machine.
How does the server communicate with the client?
It uses stdio transport, so the MCP client (e.g., Claude Desktop) must run on the same machine as the server.
Where does the data live?
Data stays in Salesforce Pardot; the server queries it live via the JDBC driver. No data is stored locally by the server.
Do I need to write SQL to use it?
No. The LLM translates natural language questions into SQL queries automatically using the built-in tools.
