{"id":"cdatasoftware-microsoft-onedrive-mcp-server-by-cdata","name":"microsoft-onedrive-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/microsoft-onedrive-mcp-server-by-cdata","category":"api-gateway","subcategories":[],"tags":["mcp","onedrive","cdata","stdio","jdbc","read-only","claude-desktop"],"what_it_does":"Provides an MCP (Model Context Protocol) server that exposes Microsoft OneDrive data as relational tables by wrapping CData's JDBC Driver for Microsoft OneDrive. The MCP server is described as read-only and supports tool-based table/column discovery and running SQL SELECT queries via stdio.","use_cases":["Letting an AI client query live OneDrive-backed data using natural language (without writing SQL)","Schema discovery for OneDrive-related datasets (list tables and columns)","Retrieving filtered subsets of OneDrive data via SQL SELECT through MCP tools","Local/offline-style MCP integration where the client runs on the same machine (stdio transport)"],"not_for":["Full CRUD operations (create/update/delete) are not provided by this server per README","Use cases requiring network-accessible MCP over HTTP (this server uses stdio only)","Environments that need strong, explicit API-level security controls and rate-limit guarantees from this MCP wrapper itself"],"best_when":"You want an MCP tool interface for OneDrive data in a local desktop client (e.g., Claude Desktop) and are already using/able to license and configure CData's OneDrive JDBC driver.","avoid_when":"You need write/delete capabilities, remote access over the network, or you cannot manage the security implications of running a local MCP process with configured JDBC/OAuth credentials.","alternatives":["Use CData's MCP Server for Microsoft OneDrive with full CRUD capabilities (mentioned as a separate product in README)","Directly integrate CData's JDBC driver into your own application without MCP","Use Microsoft Graph APIs directly (custom integration)"],"af_score":53.2,"security_score":47.0,"reliability_score":16.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:08.798362+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 (OAuth if required by the OneDrive connector) configured via JDBC URL / Connection String","CData JDBC driver licensing via java -jar cdata.jdbc.onedrive.jar --license"],"oauth":true,"scopes":false,"notes":"README indicates that if the underlying data source uses OAuth, authentication is performed in a browser while building the connection string, then the resulting JDBC URL is placed in a .prp file."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["Requires licensing of the CData JDBC Driver for Microsoft OneDrive (pricing not specified in README)"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"MCP wrapper is MIT-licensed, but the README requires licensing the CData JDBC driver; pricing details are not included."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":53.2,"security_score":47.0,"reliability_score":16.2,"mcp_server_quality":72.0,"documentation_accuracy":75.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":60.0,"auth_strength":65.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":40.0,"security_notes":"README does not describe how tokens/credentials are stored or redacted by the MCP process/logging behavior. Authentication appears to rely on OAuth via the CData JDBC driver's connection string workflow; authorization scope granularity is not documented here. Because the MCP server runs locally via stdio and depends on a separately licensed JDBC driver, operational security depends heavily on how that driver handles OAuth tokens and how the hosting environment protects the .prp configuration.","uptime_documented":0.0,"version_stability":35.0,"breaking_changes_history":0.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"Tools described are read-oriented (get_tables/get_columns/run_query). Idempotency is effectively about re-running SELECT queries; no explicit guidance is provided.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio transport, so it can only be used by clients running on the same machine.","Claude Desktop may require fully quitting and restarting to show the MCP server.","Server exposes a SQL SELECT tool; agents may need to craft safe/efficient queries and avoid overly broad SELECTs if dataset sizes are large."]}}