{"id":"cdatasoftware-zoho-creator-mcp-server-by-cdata","name":"zoho-creator-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/zoho-creator-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","zoho-creator","jdbc","data-access","local-stdio","ai-desktop","read-only","schema-discovery"],"what_it_does":"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.","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)."],"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.","alternatives":["Use CData’s managed MCP offering (CData Connect AI / CData MCP Server for Zoho Creator) if available for remote access and broader CRUD needs.","Call the Zoho Creator APIs directly (with your own integration) instead of going through MCP.","Use other data-access frameworks that support GraphQL/REST with typed schemas and safer query constraints."],"af_score":51.0,"security_score":48.2,"reliability_score":20.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:34.306685+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["CData JDBC driver connection string (may use OAuth via InitiateOAuth=GETANDREFRESH in JdbcUrl, per README example)","JDBC driver licensing via --license (TRIAL or license key)"],"oauth":true,"scopes":false,"notes":"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":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"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."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":51.0,"security_score":48.2,"reliability_score":20.0,"mcp_server_quality":78.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":0.0,"tls_enforcement":60.0,"auth_strength":65.0,"scope_granularity":30.0,"dependency_hygiene":40.0,"secret_handling":40.0,"security_notes":"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.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":20.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"The tools shown are read-only (schema introspection and SELECT). Idempotency is likely fine for reads, but the MCP server does not document idempotency semantics or retry-safe behavior.","pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}