This MCP server exposes ActiveCampaign data through a read-only MCP interface built on top of the CData JDBC Driver for ActiveCampaign. It wraps the JDBC driver so large language models can query live ActiveCampaign data using familiar MCP tools without writing SQL. The available tools are tied to the server name you configure in Claude Desktop or your MCP client. You can list tables with {servername}_get_tables, inspect columns with {servername}_get_columns for a given table, and run arbitrary SELECT queries with {servername}_run_query. Use the provided JSON-RPC examples to script queries against ActiveCampaign data via the MCP server running on your machine. Since this server operates over stdio, it is intended for local use with clients on the same host.

Prerequisites:

• Java Development Kit (JDK 8+)
• Apache Maven (for building the MCP server)
• Access to the CData JDBC Driver for ActiveCampaign and a valid license

Installation steps:

1. Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/activecampaign-mcp-server-by-cdata.git cd activecampaign-mcp-server-by-cdata

2. Build the MCP server JAR (includes dependencies): mvn clean install

   This produces CDataMCP-jar-with-dependencies.jar

3. Download and install the CData JDBC Driver for ActiveCampaign from: https://www.cdata.com/drivers/activecampaign/download/jdbc

4. License the JDBC Driver:

   • Locate the lib folder inside the driver installation
   • Run: java -jar cdata.jdbc.activecampaign.jar --license
   • Enter your name, email, and a TRIAL or license key

5. Create a .prp configuration file for your JDBC connection (example activecampaign.prp): Prefix=activecampaign ServerName=CDataActiveCampaign ServerVersion=1.0 DriverPath=/path/to/cdata.jdbc.activecampaign.jar DriverClass=cdata.jdbc.activecampaign.ActiveCampaignDriver JdbcUrl=jdbc:activecampaign:InitiateOAuth=GETANDREFRESH; Tables=

6. Run the MCP server using the generated JAR and the .prp file: java -jar /path/to/CDataMCP-jar-with-dependencies.jar /path/to/activecampaign.prp

7. In Claude Desktop or your MCP client, add the server entry with the appropriate command and arguments (example shown in the README).

Notes and tips:

• This MCP server is read-only by design. For full read/write capabilities, consider the broader MCP server variants from CData.
• The server uses STDIO, so it must be run on the same machine as the client (Claude Desktop, etc.).
• Ensure the JDBC driver is licensed and accessible via the DriverPath specified in the .prp file.
• If you update the .prp or driver, restart the MCP server so the changes take effect.
• When troubleshooting connections in Claude Desktop, fully quit and restart the client to refresh available MCP servers.
• The JSON-RPC examples show the structure for invoking tools like get_tables, get_columns, and run_query. Replace {servername} with the configured server name (e.g., CDataActiveCampaign) in your tool names and arguments.