microsoft-onedrive-mcp-server-by-cdata
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.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
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.
⚡ Reliability
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.
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
Interface
Authentication
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
MCP wrapper is MIT-licensed, but the README requires licensing the CData JDBC driver; pricing details are not included.
Agent Metadata
Known 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.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for microsoft-onedrive-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.