MailChimp

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/).

java

GitHub Stars

java

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

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.

How to use

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.

How to install

# Prerequisites: ensure you have a Java Runtime Environment installed
# and a build tool to compile the MCP server

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

Build the server

mvn clean install

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.
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=

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.)

Additional configuration notes

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.

Troubleshooting

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.

Notes on usage with Claude Desktop

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.

License

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.

Available tools

mailchimp_get_tables

Retrieves a list of tables available in the data source. The output is in CSV format with column headers on the first line.

mailchimp_get_columns

Retrieves a list of columns for a specified table. The output is in CSV format with column headers on the first line.

mailchimp_run_query

Executes a SQL SELECT query against the available tables to fetch data matching the query criteria.

Built by

VeilStrat

AI signals for GTM teams