zoho-creator -by-cdata

This MCP server provides a read-only interface to Zoho Creator data via the CData JDBC Driver. It wraps the driver with a lightweight MCP layer so that large language models and tools can query live Zoho Creator data through standard MCP tools like get_tables, get_columns, and run_query. Once configured, Claude Desktop or any compatible MCP client will discover the server and expose a set of tools named after the server (e.g., zoho-creator-cdata_mcp_get_tables, zoho-creator-cdata_mcp_get_columns, zoho-creator-cdata_mcp_run_query). Use these tools to retrieve table lists, inspect column metadata, and execute SQL SELECT queries against your Zoho Creator data. The server runs via standard input/output (stdio) and is intended for local use.

Prerequisites:

• Java Development Kit (JDK) 8+ installed on your machine
• Maven installed for building the MCP server
• Access to the CData JDBC Driver for Zoho Creator and a valid license

Step-by-step:

1. Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/zoho-creator-mcp-server-by-cdata.git cd zoho-creator-mcp-server-by-cdata

2. Build the MCP server JAR with dependencies: mvn clean install This will produce a file named CDataMCP-jar-with-dependencies.jar in the target directory or project root.

3. Install and license the CData JDBC Driver for Zoho Creator:

   • Download the driver from https://www.cdata.com/drivers/zohocreator/download/jdbc
   • Install it following the vendor instructions
   • License the driver by running: java -jar path/to/cdata.jdbc.zohocreator.jar --license and entering your name, email, and TRIAL/license key as prompted

4. Create a connection file (.prp) describing your JDBC data source. Example zoho-creator.prp: Prefix=zohocreator ServerName=CDataZohoCreator ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.zohocreator.jar DriverClass=cdata.jdbc.zohocreator.ZohoCreatorDriver JdbcUrl=jdbc:zohocreator:InitiateOAuth=GETANDREFRESH; Tables=

5. Run the MCP server: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/zoho-creator.prp

   This server uses stdio; connect via a local MCP client on the same machine.

6. In Claude Desktop or your MCP client, add the new server entry matching the generated config and start querying.

Notes and tips:

• This MCP server is read-only by design in this setup. Writes/updates require a differently configured server or permissions via the underlying driver.
• The server runs via stdio, so it must be accessed from a client on the same machine.
• Ensure the path to the zoho-creator.prp file is absolute in your run configuration.
• You may need to restart Claude Desktop or your MCP client after starting the server for it to appear.
• If the connection string or driver license is invalid, verify the DriverPath, DriverClass, and JdbcUrl in your .prp file and re-run the server.
• For troubleshooting, confirm the Java process is actively running and that the MCP client can access the local TCP/stdio channel as required by your client.