Zoho Creator MCP Server by CData

What is Zoho Creator MCP Server by CData?

Zoho Creator MCP Server by CData is a local, read-only Model Context Protocol (MCP) server that enables LLMs like Claude Desktop to query live data from Zoho Creator using natural language, powered by the CData JDBC Driver for Zoho Creator.

How to use Zoho Creator MCP Server by CData?

Clone the repository, build the JAR with Maven, install and license the CData JDBC Driver for Zoho Creator, create a .prp configuration file with JDBC connection details, then add the server to your Claude Desktop config (claude_desktop_config.json). Run the server using java -jar CDataMCP-jar-with-dependencies.jar path/to/your.prp. The server communicates over stdio.

Key features of Zoho Creator MCP Server by CData

• Read-only live access to Zoho Creator data via MCP.
• Exposes Zoho Creator as relational SQL tables.
• Natural language querying – no SQL required from the user.
• Tools: get_tables, get_columns, and run_query.
• Local, self-hosted deployment.
• Uses standard CData JDBC Driver licensing.

Use cases of Zoho Creator MCP Server by CData

• Ask Claude Desktop about correlations in Zoho Creator records.
• Query open tickets or calendar events directly from Zoho Creator.
• Retrieve filtered data from Zoho Creator without writing SQL.
• Embed Zoho Creator data into AI workflows on the same machine.

FAQ from Zoho Creator MCP Server by CData

Does this server support writing, updating, or deleting data?

No – this build is a read-only MCP server. For full read, write, update, delete, and action capabilities, use the CData MCP Server for Zoho Creator (separate product) or the fully remote CData Connect AI platform.

What are the runtime requirements?

Java (to run the JAR), Maven (for building), and the CData JDBC Driver for Zoho Creator installed and licensed. The server runs locally and uses stdio transport.

Where does my data reside?

All data stays on your local machine because the server connects directly to Zoho Creator via the JDBC driver. No data is sent to CData or third parties beyond the Zoho Creator API.

What transport does the server use?

The server uses stdio transport. It can only be used with clients that run on the same machine as the server.

How do I authenticate to Zoho Creator?

Authentication is handled via the JDBC connection string, typically using OAuth. The connection string utility provided with the driver allows you to configure and test the connection (including browser-based OAuth).