ActiveCampaign

Provides a local MCP server that exposes ActiveCampaign data for live, read-only queries by AI clients.

other

1

GitHub Stars

other

Language

6 months ago

First Indexed

2 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-activecampaign-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/activecampaign.prp"
      ]
    }
  }
}

You can query live ActiveCampaign data using a local MCP server that wraps the CData JDBC Driver. This read-only MCP server lets you ask natural language questions and retrieve up-to-date information from ActiveCampaign without writing SQL. It’s designed for use with MCP clients on the same machine, such as Claude Desktop, to access live data securely and conveniently.

How to use

After you have the MCP server running, you interact with it through your MCP client. You can ask questions like which accounts have open opportunities, how many tickets are in a given status, or when events are scheduled. The server exposes data through tools that the client can call under the hood, so you don’t need to craft SQL queries. Simply request the information you need in natural language and the MCP client translates that into the appropriate data operations for you.

How to install

Follow these concrete steps to set up the ActiveCampaign MCP Server locally.

Additional setup and notes

Prerequisites include having a Java development environment and Maven to build the MCP server. You will also need the CData JDBC Driver for ActiveCampaign installed to connect to your data source. The setup process includes licensing the driver, configuring a JDBC connection, and creating a .prp file that describes your JDBC connection for the MCP server. Finally, you run the MCP server via a Java command that launches the MCP JAR with your .prp file.

Available tools

activecampaign_mcp_get_tables

Retrieves a list of tables available in the ActiveCampaign data source. The output is returned as CSV with a header row.

activecampaign_mcp_get_columns

Retrieves the list of columns for a specified table. The output is returned as CSV with a header row.

activecampaign_mcp_run_query

Executes a SQL SELECT query against the exposed data.