{"id":"cdatasoftware-sugar-crm-mcp-server-by-cdata","name":"sugar-crm-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sugar-crm-mcp-server-by-cdata","category":"ai-ml","subcategories":[],"tags":["mcp","sugarcrm","jdbc","llm","desktop-integration","data-access","read-only","cdata"],"what_it_does":"Provides a local, read-only MCP server that exposes Sugar CRM data to AI clients (e.g., Claude Desktop) by wrapping the CData JDBC Driver for Sugar CRM and presenting a small set of MCP tools (get tables, get columns, run read-only queries).","use_cases":["Answer natural-language questions about live Sugar CRM data (no SQL required)","Explore available Sugar CRM tables/columns via AI tool calls","Run read-only SQL SELECT queries against Sugar CRM data through an MCP client","Support local analyst/CRM data Q&A workflows in an LLM desktop environment"],"not_for":["Full CRUD operations (writes/updates/deletes) via this specific server variant","Remote/hosted MCP access where stdio-only local operation is not suitable","Use cases requiring strict query sandboxing or prevention of expensive queries (not described)"],"best_when":"You want a local MCP integration to query Sugar CRM read-only data from an AI desktop client on the same machine.","avoid_when":"You need write access, remote connectivity, strict operational controls (timeouts, pagination, query cost limits), or a documented HTTP/REST/SDK interface.","alternatives":["CData managed MCP offering mentioned in README (CData Connect AI)","CData MCP Server for Sugar CRM with full read/write/update/delete (per README)","Direct usage of the CData JDBC driver from your own application rather than MCP","Other MCP servers or connectors for SugarCRM (community/third-party)"],"af_score":50.2,"security_score":39.8,"reliability_score":27.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:21.569001+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 authentication via JDBC connection string; may use OAuth in browser (per README note)","License activation for the CData JDBC driver via `java -jar cdata.jdbc.sugarcrm.jar --license`"],"oauth":true,"scopes":false,"notes":"The MCP server itself is local; authentication is handled by the underlying CData JDBC Driver using the JDBC connection string properties (README notes OAuth may require browser authentication). Tool/permission scopes specific to MCP are not described."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for Sugar CRM (requires licensing; README mentions trial/license key)","Potentially CData managed MCP platform (CData Connect AI) for remote/full capabilities per README"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README indicates the underlying JDBC driver must be licensed (trial or license key), but no pricing tiers or costs are included in the provided content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":50.2,"security_score":39.8,"reliability_score":27.5,"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":10.0,"tls_enforcement":50.0,"auth_strength":65.0,"scope_granularity":20.0,"dependency_hygiene":30.0,"secret_handling":25.0,"security_notes":"The MCP server is local (stdio) which reduces exposure over the network, but security controls are largely delegated to the underlying CData JDBC driver and SugarCRM/OAuth. The README instructs licensing and connection configuration but does not document transport security for internal connections, credential storage practices (e.g., whether secrets in the .prp/JdbcUrl may be logged), or any fine-grained permission scopes for MCP tools. Query execution is SQL-based (SELECT), but there is no described sandboxing, query cost limiting, or result redaction guidance.","uptime_documented":0.0,"version_stability":50.0,"breaking_changes_history":40.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it must run on the same machine as the MCP client (e.g., Claude Desktop).","This repository variant is explicitly read-only; agents should not assume write/update/delete tools exist.","Long-running or complex queries are not documented with any retry/pagination/timeouts guidance; agents may need to keep queries bounded.","Tool descriptions exist (tables/columns/run_query), but full MCP schema and error formats are not documented in the provided README."]}}