home / mcp / zuora mcp server

Zuora MCP Server

This read-only MCP Server allows you to connect to Zuora 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-zuora-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/zuora.prp"
      ]
    }
  }
}

You can run a local, read-only MCP server that exposes Zuora data through a simple, queryable interface. This lets you ask natural language questions and retrieve live Zuora information without writing SQL. The server wraps the CData JDBC Driver for Zuora and serves data via MCP, so conversational AI can access up-to-date data safely on your machine.

How to use

Start the MCP server on your machine and connect your client to the local stdio endpoint. You will run a local Java process that reads a configuration file (zuora.prp) describing how to connect to Zuora via the CData JDBC Driver. Once running, your MCP client can read data tables, list columns, and execute read-only queries through built-in tools. Use natural language prompts to ask questions like “What is the total revenue by product line for last quarter?” and the AI client will translate them into familiar MCP tool calls behind the scenes. The available tools enable you to discover tables, inspect columns, and run SELECT queries against the connected Zuora data source.

How to install

# Prerequisites
- Java runtime (JRE/JDK) installed on your machine
- Access to Zuora via the CData JDBC Driver for Zuora (see steps below)

# 1) Build the MCP server artifact
mvn clean install

# 2) Launch the MCP server with the Zuora config
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/zuora.prp

Additional configuration and notes

The MCP server operates locally (stdio) and runs a Java process that reads a .prp file describing the JDBC connection and exposed tables. You will typically start by building the server, provisioning the JDBC driver, and then launching the server with the zuora.prp configuration. The server exposes a consistent set of tools for interacting with the data source, including enumerating tables, listing columns, and running read-only queries.

Available tools

zuora_get_tables

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

zuora_get_columns

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

zuora_run_query

Executes a SQL SELECT query against the connected Zuora data source and returns the results.