zoho-creator-mcp-server-by-cdata
Provides a local MCP (Model Context Protocol) server that exposes Zoho Creator data as tools to an AI desktop client. It uses the CData JDBC Driver to translate Zoho Creator into relational tables, and offers MCP tools to list tables/columns and run read-only SQL SELECT queries over stdio.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
The MCP server is local (stdio), reducing exposure to remote interception. However, secrets/credentials handling specifics (e.g., how .prp files store OAuth tokens, whether logs might include connection details, and whether the server restricts what queries can do) are not described. Query execution via a 'run_query' tool implies the agent may be able to craft potentially expensive or unsafe SELECTs depending on JDBC driver behavior; no explicit guardrails, query timeouts, or row limits/pagination are documented.
⚡ Reliability
Best When
You want an on-device MCP integration with Zoho Creator for read-focused data Q&A and schema discovery, using an AI desktop client on the same machine.
Avoid When
You need remote network access to the MCP server, fine-grained rate-limit/pagination controls, or strict guarantees about safe query execution beyond what the underlying JDBC driver provides.
Use Cases
- • Ask an AI assistant natural-language questions about Zoho Creator data (live reads).
- • Explore schema: list available tables and columns.
- • Run parameter-free SELECT queries to compute counts/aggregates and join-like analysis via the underlying JDBC driver.
- • Enable local retrieval for reporting/Q&A without writing SQL manually.
Not For
- • Production multi-tenant deployments (stdio local-only).
- • High-frequency or latency-sensitive workloads without tuning (no guidance on performance controls).
- • Cases needing robust server-side pagination, filtering, or cursor-based retrieval in the MCP layer (only tools for schema and raw SELECT).
- • Strong transactional write workflows (the project is explicitly read-only in this MCP server).
Interface
Authentication
Authentication is handled by the underlying CData JDBC driver and Zoho Creator via the JDBC connection string (the README notes OAuth flows may be required). The MCP server itself relies on the .prp configuration pointing to the licensed driver and the provided JDBC URL; no MCP-layer auth or scopes are described.
Pricing
The repository/license is MIT, but access to Zoho Creator data depends on CData JDBC Driver licensing and Zoho Creator credentials. README instructs running the CData driver with a trial or license key.
Agent Metadata
Known Gotchas
- ⚠ Server uses stdio; it can only be used by clients on the same machine as the server.
- ⚠ The README contains examples where 'Salesforce.prp' is used in the run command for Zoho Creator; ensure the correct .prp file is used for your source.
- ⚠ OAuth/auth failures are likely to surface from the JDBC driver; MCP-layer troubleshooting guidance is limited.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for zoho-creator-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.