zohocreator_get_tablesLABSCO SUMMARY
Three tools, because SQL is the interface.
Rather than modelling every Zoho Creator object as its own tool, this hands the assistant a schema and a query executor and lets SQL do the rest — which is why an unfamiliar question does not need a new tool. The trade is setup: a licensed JDBC driver, a Maven build and a hand-written properties file stand between you and the first query. Two limits worth naming: this build is read-only, and it can query every table the connection reaches — the tables property does not narrow that, so limit the connection or the account it signs in with.
What it is
A local, read-only MCP server built by CData that wraps their JDBC driver for Zoho Creator. The driver presents Zoho Creator as relational SQL models; the server puts a small tool surface in front of it so an assistant can find the tables, inspect their columns, and answer questions in natural language without you writing the query.
What you get
- The list of tables available in the data source, returned as CSV with a header row —
get_tables - The columns of one table, so a query can be built against the real schema rather than a guessed one —
get_columns - SQL SELECT execution against the connected source —
run_query - All three carry the prefix you set in the connection properties file, so several CData servers can run side by side without their tool names colliding
Requirements
A Zoho Creator account and the CData JDBC Driver for Zoho Creator, downloaded and licensed separately — the driver JAR is run once with --license and takes your name, email and either TRIAL or a license key. Java, plus Maven to build the server JAR from a clone. Connection details go in a properties file listing the tool prefix, the server name and version, the driver JAR path, the driver class, and the JDBC URL — you generate that URL with the driver's own connection-string utility, authenticating in the browser when the source uses OAuth. The tables property only picks which tables also get a ready-made description; the tools can query every table the connection reaches, so limit the connection or the account it signs in with. The client entry runs java with the built JAR and your properties file. Transport is stdio, so client and server must be on the same machine.
Setup effort
Build from source — git clone https://github.com/cdatasoftware/zoho-creator-mcp-server-by-cdata.git
USE CASES
01
Answering a data question without writing SQL
Ask in plain language and let the assistant discover the tables and columns first, then compose the SELECT itself.
02
Getting oriented in an unfamiliar Zoho Creator account
List the tables and read the columns of the ones that look relevant, instead of clicking through the app to find where a field lives.
03
Limiting what an assistant can see
Name the specific tables in the connection properties file so the server only ever exposes those, rather than the whole account.
3 tools
Listed in project docs. Your client may show a different list.
zohocreator_get_columnszohocreator_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Tool names start with the Prefix in the .prp file, so the sample Prefix=zohocreator gives zohocreator_get_tables, zohocreator_get_columns and zohocreator_run_query.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone and build this one yourself.
Server setup
TERMINAL
git clone https://github.com/cdatasoftware/zoho-creator-mcp-server-by-cdata.git
cd zoho-creator-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for Zoho Creator from https://www.cdata.com/drivers/zohocreator/download/jdbc
License the driver: in the driver's lib folder run java -jar cdata.jdbc.zohocreator.jar --license and enter your name, email, and "TRIAL" (or your license key)
Run java -jar cdata.jdbc.zohocreator.jar to open the Connection String utility, configure and test the connection, then copy the connection string
Create zoho-creator.prp with:
FILE · zoho-creator.prp
Prefix=zohocreator
ServerName=CDataZohoCreator
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.zohocreator.ZohoCreatorDriver
JdbcUrl=<YOUR_JDBC_URL>
Tables=Tables only picks which tables also get a ready-made description for your assistant, and empty means none; the server can still list and query every table your connection string reaches, so to keep data out of reach, limit that connection or the account it signs in with.
Add the mcpServers entry below to claude_desktop_config.json and restart the client
(optional, to run standalone) java -jar <YOUR_PATH_TO_CDATA_MCP_JAR_WITH> <YOUR_PATH_TO_ZOHO_CREATOR>
MCP Clients
Claude Desktop — macOS, Linux
CLAUDE DESKTOP — MACOS, LINUX · JSON
{
"mcpServers": {
"zoho-creator": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_ZOHO_CREATOR>"
]
}
}
}