{"id":"cdatasoftware-office-365-mcp-server-by-cdata","name":"office-365-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/office-365-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","office-365","cdata","jdbc","stdio","read-only","local-agent-tools"],"what_it_does":"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.","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"],"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.","alternatives":["CData managed MCP platform (CData Connect AI) mentioned in README","A direct integration using the CData JDBC driver with your own query layer","Any Office 365 Graph API integration built for your specific data needs"],"af_score":46.8,"security_score":42.2,"reliability_score":23.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:15.366586+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":["Java"],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["CData JDBC driver licensing (java -jar ... --license)","Office 365 OAuth flow via the JDBC driver connection string utility (InitiateOAuth=GETANDREFRESH is shown)"],"oauth":true,"scopes":false,"notes":"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":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Pricing is not described for the MCP server itself; it depends on CData JDBC driver licensing and potentially Office 365 tenant configuration."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":46.8,"security_score":42.2,"reliability_score":23.8,"mcp_server_quality":62.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":0.0,"tls_enforcement":60.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":30.0,"secret_handling":40.0,"security_notes":"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.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":30.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Read/query operations are naturally idempotent, but the README does not state idempotency guarantees for MCP calls or how retries are handled.","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","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)"]}}