office-365-mcp-server-by-cdata

Provides a local, read-only MCP server that wraps CData’s Office 365 JDBC driver. The MCP server exposes Office 365 entities as tools (get_tables/get_columns/run_query) so an MCP-capable client (e.g., Claude Desktop) can query live Office 365 data without manually writing SQL.

Evaluated Apr 04, 2026 (16d ago)
Repo ↗ Infrastructure mcp office-365 cdata jdbc stdio read-only local-agent-tools
⚙ Agent Friendliness
47
/ 100
Can an agent use this?
🔒 Security
42
/ 100
Is it safe for agents?
⚡ Reliability
24
/ 100
Does it work consistently?

Score Breakdown

⚙ Agent Friendliness

MCP Quality
62
Documentation
70
Error Messages
0
Auth Simplicity
60
Rate Limits
0

🔒 Security

TLS Enforcement
60
Auth Strength
55
Scope Granularity
20
Dep. Hygiene
30
Secret Handling
40

Transport security is not directly controlled by this MCP server (stdio local), but the underlying JDBC/OAuth interactions with Microsoft should use TLS; not documented here. Auth strength is mediated by CData’s JDBC driver and OAuth, but scope granularity and secure storage/handling of tokens and secrets are not described. The README includes a JDBC URL example containing OAuth parameters, but does not document secret-handling practices (e.g., where tokens are stored, redaction in logs). No dependency/vulnerability hygiene information is provided in the provided content.

⚡ Reliability

Uptime/SLA
0
Version Stability
45
Breaking Changes
30
Error Recovery
20
AF Security Reliability

Best When

You want a local Office 365 data querying capability inside a desktop MCP client on the same machine as the MCP server process.

Avoid When

You need remote multi-tenant access, server-side HTTP APIs, or robust built-in rate limiting/pagination semantics at the MCP layer.

Use Cases

  • Ask natural-language questions about Office 365 data in an MCP client
  • Explore available Office 365 “tables” and columns via MCP tools
  • Run SELECT-style queries against Office 365 data through an MCP tool interface

Not For

  • Public/remote MCP access over the network (server uses stdio and is intended for same-machine clients)
  • Unrestricted CRUD/write operations (README describes this project as read-only; tool examples are for queries)
  • Production services that require webhooks, REST endpoints, or centralized API management

Interface

REST API
No
GraphQL
No
gRPC
No
MCP Server
Yes
SDK
No
Webhooks
No

Authentication

Methods: CData JDBC driver licensing (java -jar ... --license) Office 365 OAuth flow via the JDBC driver connection string utility (InitiateOAuth=GETANDREFRESH is shown)
OAuth: Yes Scopes: No

Authentication is delegated to the CData JDBC driver. README indicates OAuth may be required and that users must authenticate in a browser; OAuth scopes and their granularity are not specified in this MCP server README.

Pricing

Free tier: No
Requires CC: No

Pricing is not described for the MCP server itself; it depends on CData JDBC driver licensing and potentially Office 365 tenant configuration.

Agent Metadata

Pagination
none
Idempotent
False
Retry Guidance
Not documented

Known Gotchas

  • Server uses stdio, so it must run on the same machine as the MCP client
  • The README claims write/update/delete availability elsewhere, but also states this project is read-only; agents may attempt unsupported tool actions depending on client assumptions
  • Tooling exposes SQL execution via run_query; agents may generate expensive/large queries without guardrails (no limits described in README)

Alternatives

Full Evaluation Report

Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for office-365-mcp-server-by-cdata.

AI-powered analysis · PDF + markdown · Delivered within 30 minutes

$99

Package Brief

Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.

Delivered within 10 minutes

$3

Score Monitoring

Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.

Continuous monitoring

$3/mo

Scores are editorial opinions as of 2026-04-04.

8642
Packages Evaluated
17761
Need Evaluation
586
Need Re-evaluation
Community Powered