{"id":"cdatasoftware-excel-online-mcp-server-by-cdata","name":"excel-online-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/excel-online-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","excel-online","cdata","jdbc","stdio","read-only","local-integration","data-access"],"what_it_does":"Provides a local, read-only MCP server that wraps CData’s JDBC Driver for Excel Online, exposing Excel Online content as relational tables/columns and allowing tool-based SQL SELECT queries via an MCP (stdio) interface for AI clients like Claude Desktop.","use_cases":["Let an AI assistant answer questions about live Excel Online data using natural language (no manual SQL).","Explore available Excel Online tables and columns via MCP tools.","Run read-only SQL SELECT queries against Excel Online tables through an MCP client."],"not_for":["Use as a standalone remote service (stdio limits it to local clients on the same machine).","Applications requiring write/update/delete capabilities (the project is explicitly read-only).","Teams needing a managed hosted MCP endpoint with built-in scaling/observability."],"best_when":"You want a local MCP integration to query Excel Online data for an on-device desktop client, and you are willing to install/configure the CData JDBC driver plus a local MCP server jar.","avoid_when":"You need fine-grained security controls, audited access logs, or robust network exposure (since it’s local stdio and credentials/config are handled via a local .prp file).","alternatives":["CData’s managed/hosted MCP option (CData Connect AI / CData MCP Server for Excel Online).","Direct use of the CData JDBC driver (without MCP) from your application or scripts.","Use an intermediate API layer (your own service) that exposes specific read-only endpoints with strong auth and auditing."],"af_score":47.5,"security_score":30.8,"reliability_score":21.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:59.195428+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 as configured in the JDBC connection/JdbcUrl (may involve OAuth via browser per README note).","License activation for the CData JDBC driver via java -jar ... --license."],"oauth":true,"scopes":false,"notes":"Authentication is delegated to the CData JDBC driver; the README notes OAuth may be required and is performed in a browser. No additional MCP-level auth is described."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for Excel Online licensing required (per README license step).","CData MCP Server option mentioned for managed/remote capabilities is implied to be part of CData’s paid offerings (exact pricing not provided)."],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing for this repo itself is provided; it requires CData JDBC driver licensing to function."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":47.5,"security_score":30.8,"reliability_score":21.2,"mcp_server_quality":78.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":5.0,"tls_enforcement":20.0,"auth_strength":45.0,"scope_granularity":20.0,"dependency_hygiene":30.0,"secret_handling":35.0,"security_notes":"Security controls are largely delegated to the local CData JDBC driver configuration (.prp with JdbcUrl and possibly OAuth tokens). The MCP server is local stdio (reducing network exposure), but the README provides no details on token storage, logging redaction, transport security within the MCP layer, or any MCP-level authorization/role scoping. Arbitrary SQL via run_query increases risk of data overreach if the agent has broad access to tools and tables.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":30.0,"error_recovery":25.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server is stdio-based and can only be used with clients running on the same machine as the server.","It is described as a read-only MCP server; attempts to perform write/update/delete may fail or be unsupported.","The README example SQL includes direct SELECT; agents should avoid injecting unsafe SQL patterns and should be mindful that tool accepts an arbitrary SQL string (query results may depend on driver table/column naming and quoting).","OAuth flows (if used) happen during CData JDBC connection configuration; the MCP server itself does not appear to manage auth renewal explicitly in this README."]}}