home / mcp / freshdesk mcp server

Freshdesk MCP Server

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

You can run a local, read-only MCP server that lets you query live Freshdesk data through natural language without writing SQL. This server wraps the CData JDBC driver for Freshdesk and exposes a simple MCP interface so you can ask questions like what tickets exist today or how many open issues you have by project.

How to use

You will run a local MCP client that connects to the Freshdesk data source via a prepared .prp connection file. Once the server is running, your AI client can use the built-in tools to list available tables, inspect columns, and run queries. You do not need to write SQL for common questions. Examples of what you can ask include: finding counts of open tickets, identifying trends across ticket categories, or querying calendar events and related activities if exposed by the data source.

How to install

Prerequisites you need before starting: a Java runtime (JDK 11+ recommended) and Maven for building the bundled MCP JAR.

1. Clone the project repository and enter the directory.

git clone https://github.com/cdatasoftware/freshdesk-mcp-server-by-cdata.git
cd freshdesk-mcp-server-by-cdata

Install and configure the data connection

2. Build the server to produce the JAR file used to run the MCP server.

mvn clean install

Obtain and prepare the JDBC driver

3. Download and install the CData JDBC Driver for Freshdesk from the official site.

4. License the driver by running the license command from the driver’s lib folder and entering your name, email, and a license key (TRIAL or your key).

Create a JDBC connection profile

5. Run the JDBC driver’s connection string utility to create and test a connection. Copy the resulting JDBC URL for later use.

Create the MCP profile file

6. Create a .prp file (for example freshdesk.prp) with these required properties. Populate the fields with your actual paths and connection details.

Prefix=freshdesk
ServerName=CDataFreshDesk
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.freshdesk.jar
DriverClass=cdata.jdbc.freshdesk.FreshDeskDriver
JdbcUrl=jdbc:freshdesk:InitiateOAuth=GETANDREFRESH;
Tables=

Run the MCP server

7. Start the MCP server using the Java runtime and point it at your Freshdesk PRP file.

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

Optional Claude Desktop integration

If you use Claude Desktop or another MCP client, configure the client to load your MCP server as a local stdio server. The client will discover the server when it is running on the same machine.

Available tools

freshdesk_get_tables

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

freshdesk_get_columns

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

freshdesk_run_query

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