CData Zoho Projects Server

What it is

A Java MCP server that puts CData's JDBC Driver for Zoho Projects behind three read-only tools: list the tables, list a table's columns, and run a SQL SELECT. The driver is what does the work — it exposes Zoho Projects as relational SQL models — and the server hands those models to your client so you can ask questions in plain language instead of writing SQL yourself.

What you get

• get_tables returns the tables available in the data source, as CSV with a header row
• get_columns returns the columns of one table, in the same CSV shape
• run_query executes a SQL SELECT and returns the rows
• Every tool name starts with the Prefix value from your .prp file, so several CData servers can run side by side without colliding
• Ask in plain language — which tasks are still open in a project, say — and the client picks the tools and writes the SQL

Requirements

Build the server with mvn clean install, which produces CDataMCP-jar-with-dependencies.jar. Separately download the CData JDBC Driver for Zoho Projects and license it: run java -jar cdata.jdbc.zohoprojects.jar --license and enter your name, email and either TRIAL or a licence key. Then write a .prp file naming DriverClass=cdata.jdbc.zohoprojects.ZohoProjectsDriver plus the JdbcUrl you build in the driver's connection-string utility, and point your client at java -jar with the jar and that file. Transport is stdio, so the server has to run on the same machine as the client.

Setup effort

Build from source — git clone https://github.com/cdatasoftware/zoho-projects-mcp-server-by-cdata.git

Tools you get

3 tools named in the project's documentation. Tool names take the Prefix in the .prp file, so the sample Prefix=zohoprojects gives zohoprojects_get_tables, zohoprojects_get_columns and zohoprojects_run_query. All three are read-only (run_query accepts only SELECT). Writes need CData's separate MCP Server for Zoho Projects.

Where it runs

The documented client runs the server on your machine.