{"id":"cdatasoftware-zoho-crm-mcp-server-by-cdata","name":"zoho-crm-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/zoho-crm-mcp-server-by-cdata","category":"api-gateway","subcategories":[],"tags":["mcp","zoho-crm","jdbc","ai-agents","data-integration","stdio"],"what_it_does":"Provides a local read-only MCP server that exposes Zoho CRM data through CData JDBC Drivers, wrapping the driver into MCP tools (get tables, get columns, run SELECT queries) usable by local MCP clients via stdio.","use_cases":["Let LLM clients query live Zoho CRM data without writing SQL","Retrieve table/column metadata for CRM reporting and data exploration","Run read-only analytics-style SELECT queries against CRM objects"],"not_for":["Writing, updating, or deleting Zoho CRM data (server is described as read-only)","Remote (network) MCP access from another machine (uses stdio, same-host only)","Use cases requiring documented pagination, query limits, or strong agent-facing safety controls"],"best_when":"You need local, interactive read-only CRM data exploration/QA in an MCP-capable desktop environment (e.g., Claude Desktop).","avoid_when":"You need secure multi-tenant/remote access, fine-grained authorization enforcement at the MCP layer, or strict guardrails to prevent heavy/expensive queries.","alternatives":["Use the CData-managed MCP platform mentioned in the README (CData Connect AI / managed MCP server)","Directly connect from your application to Zoho CRM using the CData JDBC driver (bypassing MCP)","Use Zoho CRM APIs via a purpose-built integration instead of MCP"],"af_score":46.8,"security_score":40.0,"reliability_score":28.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:00.835645+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":["Uses CData JDBC driver OAuth flow if required by the Zoho CRM source (configured via JDBC connection string / InitiateOAuth=GETANDREFRESH)"],"oauth":true,"scopes":false,"notes":"Authentication is not shown as MCP-layer auth; it is delegated to the underlying CData JDBC driver via the JDBC connection string and the configured OAuth mechanism."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Pricing is not described for the MCP server itself; CData JDBC driver licensing is required per README, implying additional cost depending on the driver/license plan."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":46.8,"security_score":40.0,"reliability_score":28.8,"mcp_server_quality":65.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":45.0,"rate_limit_clarity":10.0,"tls_enforcement":50.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":35.0,"secret_handling":35.0,"security_notes":"MCP layer appears to rely on the underlying JDBC/OAuth configuration rather than MCP-native auth with fine-grained scopes. The README does not describe secret-handling practices for .prp contents, nor does it mention query sandboxing, SQL injection protections (agent-generated SQL), or rate limit/header handling. Because stdio is local-only, network exposure is reduced, but the local process could still access configured Zoho data with the credentials granted to the JDBC driver.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":50.0,"error_recovery":25.0,"idempotency_support":"false","idempotency_notes":"Server is read-only (get tables/columns, run SELECT), so idempotency concerns are mostly irrelevant, though query retries could still be repeated without caching.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Uses stdio; MCP client and server must run on the same machine.","Claude Desktop may require fully quitting and reopening to make the MCP server appear.","No documented limits/guardrails on SQL query size/complexity; agents could generate expensive SELECTs.","Requires correct .prp configuration and CData JDBC driver licensing/OAuth setup."]}}