playbooks

home / mcp / marketo mcp server

Marketo MCP Server

This read-only MCP Server allows you to connect to Marketo 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/).

Installation
Add the following to your MCP client configuration file.

Configuration

View docs
{
  "mcpServers": {
    "cdatasoftware-marketo-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/marketo.prp"
      ]
    }
  }
}

You can query live Marketo data with a lightweight MCP server that exposes Marketo data through a simple MCP interface. This enables LLMs and client tools to read data from Marketo without writing SQL, while keeping data access read-only and centralized for easy querying.

How to use

You will connect your MCP client (such as Claude Desktop or another MCP-enabled assistant) to this server to read live Marketo data. After the server is running, you can ask questions like which opportunities are open, which accounts are associated with a given campaign, or how many records exist in a specific data set. The client will discover what tables exist, fetch column information, and run read-only queries against Marketo through the MCP endpoints. No SQL is required from your side; your questions are translated into the appropriate read operations by the MCP client.

Typical usage pattern: - Start the MCP server on the same machine as your MCP client. - In your MCP client, add the MARKETO MCP server configuration (details below). - Use built-in tools to list tables, inspect columns, and run read-only queries as natural-language questions.

How to install

Prerequisites you need before installing: - Java Runtime Environment (JRE) or JDK installed on your machine. - A Java build tool (Maven) if you choose to build from source. - Access to the Marketo data via the CData JDBC Driver for Marketo (download and license steps are included in the setup). - Administrative rights on the machine where you will run the MCP server.

Step-by-step installation workflow 1) Clone the project `` git clone https://github.com/cdatasoftware/marketo-mcp-server-by-cdata.git cd marketo-mcp-server-by-cdata ` 2) Build the server ` mvn clean install ` This creates the JAR file: CDataMCP-jar-with-dependencies.jar 3) Download and install the CData JDBC Driver for Marketo from the official site. 4) License the CData JDBC Driver: ` java -jar cdata.jdbc.marketo.jar --license ` Enter your name, email, and your license key or TRIAL as prompted. 5) Configure your connection to Marketo (or other data sources) using the driver’s Connection String utility: ` java -jar cdata.jdbc.marketo.jar ` Test the connection and copy the resulting JDBC URL for later. 6) Create a .prp file for your JDBC connection (example name: marketo.prp) with the following properties: ` Prefix=marketo ServerName=CDataMarketo ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.marketo.jar DriverClass=cdata.jdbc.marketo.MarketoDriver JdbcUrl=jdbc:marketo:InitiateOAuth=GETANDREFRESH; Tables= ` Replace PATH\TO with the actual paths on your system and use the JDBC URL you obtained in step 5. 7) Run the MCP server using the PRP file: ` java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/marketo.prp `` > Note: This server runs in stdio mode and is intended for use with clients running on the same machine.

Additional notes and setup details

Claude Desktop configuration (example) shows how to register the MCP server so the client can launch and query it. You place a JSON configuration entry under the mcpServers key with the appropriate command and arguments, pointing to the MCP JAR and the marketo.prp file.

If you encounter issues, ensure you have fully closed and reopened your MCP client after changes to the server configuration. Verify that the marketo.prp file contains the correct JDBC URL and that the CData JDBC Driver is properly licensed.

Tools exposed by the MCP server include: - marketo_get_tables: Retrieves a list of tables available in the data source. - marketo_get_columns: Retrieves the columns for a specific table. - marketo_run_query: Executes a SQL SELECT query against the data source.

Available tools

marketo_get_tables

Retrieves a list of tables available in the Marketo data source. Output is CSV with column headers.

marketo_get_columns

Retrieves a list of columns for a specified table. Output is CSV with column headers.

marketo_run_query

Executes a SQL SELECT query against the Marketo data source via the MCP server.