marketo -by-cdata

This MCP server exposes Marketo data through a read-only MCP interface by wrapping the CData JDBC Driver for Marketo. It allows LLMs and clients on the same machine to query live Marketo data using simple MCP tools without writing SQL directly. The built-in tools include marketo_get_tables to list available tables, marketo_get_columns to list columns for a given table, and marketo_run_query to execute a SQL SELECT-like query against the Marketo data source. When used with Claude Desktop or a compatible client, you configure the MCP server in a JSON-based config (claude_desktop_config.json or similar), then invoke the appropriate tool via JSON-RPC calls. The server runs locally via standard input/output, so clients on the same host can interact with it directly. The catalog of tools is exposed with the {servername} prefix, for example marketo_get_tables, marketo_get_columns, and marketo_run_query, with outputs typically returned in CSV format where applicable.

Prerequisites:

• Java Runtime Environment (JRE/JDK) 8+ installed on your machine
• Maven (for building the MCP JAR)
• Access to the CData JDBC Driver for Marketo (download and install as described below)

1. Build the MCP server:

git clone https://github.com/cdatasoftware/marketo-mcp-server-by-cdata.git
cd marketo-mcp-server-by-cdata
mvn clean install

This should produce the JAR named something like CDataMCP-jar-with-dependencies.jar.

2. Download and install the CData JDBC Driver for Marketo:

• Visit: https://www.cdata.com/drivers/marketo/download/jdbc
• Follow the installer instructions for your OS.

3. License the JDBC Driver (example steps):

• Open a terminal and navigate to the JDBC driver lib folder (adjust for your OS):
  • Windows: C:\Program Files\CData\CData JDBC Driver for Marketo\lib
  • macOS/Linux: /Applications/CData JDBC Driver for Marketo/
• Run: java -jar cdata.jdbc.marketo.jar --license
• Enter your name, email, and a license key or TRIAL as prompted.

4. Create the MCP PRP configuration file (marketo.prp) to connect via JDBC:

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=

5. Run the MCP server:

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/marketo.prp

Note: The server uses stdio, so it should be run on the same machine as any clients that connect to it.

Tips and troubleshooting:

• Ensure the JDBC driver is licensed and correctly installed; the MCP server reads the .prp file to connect to Marketo.
• The server runs via stdio, so clients (like Claude Desktop) on the same host can connect directly using the provided config.
• If you don’t see the MCP server in Claude Desktop, fully quit and re-launch Claude Desktop after starting the server.
• If a connection fails, re-check the JdbcUrl and ensure OAuth authentication (if used) completes in your browser as part of the driver setup.
• The outputs for get_tables and get_columns are CSV-formatted; get_queries return the result set per your SQL query.
• Since this is a read-only server, write/update/delete capabilities are not exposed via this MCP server by design.