home / mcp / zendesk mcp server

Zendesk MCP Server

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

You can query Zendesk data live using a local, read-only MCP (Model Context Protocol) server. It wraps the CData JDBC Driver for Zendesk and exposes Zendesk data through a simple MCP interface so you can ask natural-language questions and receive up-to-date results without writing SQL.

How to use

Once you have the MCP server running, you can connect from an MCP client to access live Zendesk data. You will use the built-in tools to discover data structure, read data, and run read-only queries. Typical usage patterns include asking questions like which tickets are open, what is the correlation between tickets and accounts, and what events are scheduled today. The server operates locally via stdio, so your client runs on the same machine and communicates through standard input/output channels.

How to install

Prerequisites you need before installation:

- Java Runtime: Ensure you have a compatible JRE/JDK installed on your machine.

Follow these concrete steps to set up the MCP server locally:

# Step 1: Prepare your working directory
mkdir -p ~/mcp Zendesk
cd ~/mcp Zendesk

# Step 2: Prepare the runtime JAR and configuration
# You will build or obtain CDataMCP-jar-with-dependencies.jar and zendesk.prp for your environment.
# The runtime command will reference these paths accordingly.

Configuration and running notes

The server is designed for local, read-only access. You run it as a local stdio process using Java and a prepared .prp configuration file that points to your Zendesk data source.

Command to start the MCP server (example):
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/zendesk.prp

Troubleshooting

If you do not see the MCP server appear in your client, ensure you have fully quit and restarted the client to refresh the MCP server list. If the client cannot retrieve data, verify that your Zendesk connection string in zendesk.prp is correct and that the JAR and PRP paths are valid. For further help, contact support or check community forums for guidance on MCP setup and troubleshooting.

License and notes

This MCP server is provided under the MIT License. You are free to use, modify, and distribute the software, subject to the terms of the MIT License. Ensure you comply with the license terms when distributing modified versions.

Tools & descriptions

The MCP server exposes tools to discover and query the Zendesk data source. The available tools include the following:

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

- zendesk_get_columns - Retrieves a list of columns for a specific table. The output is in CSV format with column headers on the first line.

- zendesk_run_query - Executes a SQL SELECT query against the data source.

Available tools

zendesk_get_tables

Retrieves a list of available tables in the Zendesk data source. The output is CSV with column headers in the first row.

zendesk_get_columns

Retrieves the columns for a specified table. The output is CSV with column headers in the first row.

zendesk_run_query

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