home / mcp / mailchimp mcp server
This read-only MCP Server allows you to connect to MailChimp data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).
Configuration
View docs{
"mcpServers": {
"cdatasoftware-mailchimp-mcp-server-by-cdata": {
"command": "java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/mailchimp.prp"
]
}
}
}You can run a local, read-only MCP server that exposes MailChimp data through a simple MCP interface. This lets you ask natural-language questions and receive live results from MailChimp without writing SQL. The server is built on the CData JDBC Driver for MailChimp and runs on your machine, returning data to your MCP client.
Once the server is running, you connect to it with your MCP client. You don’t need to call individual tools manually; simply ask questions about MailChimp data and the client will use the built‑in tools under the hood to retrieve the relevant information. Typical questions include identifying the tables available, inspecting column details, and running queries to fetch specific records.
# Prerequisites: ensure you have a Java Runtime Environment installed
# and a build tool to compile the MCP server
```
1) Clone the project and navigate to the project directory
```
git clone https://github.com/cdatasoftware/mailchimp-mcp-server-by-cdata.git
cd mailchimp-mcp-server-by-cdata
```
2) Build the server
```
mvn clean install
```
3) Obtain and install the CData JDBC Driver for MailChimp from the official download page and license it as required by your environment. Follow the license steps in the driver installation guide.
4) Prepare a properties file for your JDBC connection. Create a file named `mailchimp.prp` with the following properties, filling in your paths and connection details:
```
Prefix=mailchimp
ServerName=CDataMailChimp
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.mailchimp.jar
DriverClass=cdata.jdbc.mailchimp.MailChimpDriver
JdbcUrl=jdbc:mailchimp:InitiateOAuth=GETANDREFRESH;
Tables=
```
5) Run the MCP server using the built JAR and your `.prp` file
```
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/mailchimp.prp
```
```
(Note: The server runs in stdio mode, so your MCP client must run on the same machine as the server.)The server uses the CData JDBC Driver to connect to MailChimp. Make sure you license the driver, configure the connection string, and supply the path to the driver JAR in the .prp file. The example above shows a complete structure for mailchimp.prp with the required fields.
If you cannot see or connect to the MCP server, ensure you have fully stopped and restarted the client after starting the server. Verify that the JDBC connection string is correct and that the driver JAR path in the .prp file is valid. Check that the server process is running on the local machine and that no firewall rules block local IPC.
To use this MCP server with Claude Desktop, register the server in your Claude configuration by adding a new MCP entry that points to the local Java process and your .prp file as shown in the setup steps. The server is designed for local, read-only access, so you can query MailChimp data without modifying it.
This MCP server is licensed under the MIT License. You are free to use, modify, and distribute the software in accordance with the terms of that license.
Retrieves a list of tables available in the data source. The output is in CSV format with column headers on the first line.
Retrieves a list of columns for a specified table. The output is in CSV format with column headers on the first line.
Executes a SQL SELECT query against the available tables to fetch data matching the query criteria.