microsoft-planner-mcp-server-by-cdata
Provides a local, read-only MCP server that wraps the CData JDBC Driver for Microsoft Planner and exposes Planner data via MCP tools (get tables/columns, run SELECT queries) to LLM clients such as Claude Desktop (stdio-based, same-machine).
Score Breakdown
⚙ Agent Friendliness
🔒 Security
Transport confidentiality depends on local stdio usage; remote network transport is not described. Authentication is delegated to the CData JDBC driver (OAuth initiation shown), but the README does not specify fine-grained scopes or MCP-layer access controls. Secrets/auth material are provided via JDBC URL and .prp configuration; guidance on secure handling (e.g., not logging, filesystem permissions) is not detailed in the provided content. Dependency hygiene and vulnerability posture cannot be determined from the supplied README/metadata.
⚡ Reliability
Best When
You want local, same-host LLM querying of Microsoft Planner data using MCP with minimal setup and you’re comfortable configuring a JDBC driver and running a local Java process.
Avoid When
You need secure multi-tenant remote access, strong built-in auth boundaries at the MCP layer, or high assurance that tool calls are restricted beyond basic read-only intent.
Use Cases
- • Ask questions over live Microsoft Planner data using an LLM without writing SQL
- • Retrieve available Planner tables/columns and run read-only SQL SELECT queries
- • Analytics/reporting on Planner entities using ad-hoc queries from an MCP client
Not For
- • Write/update/delete operations (server described as read-only)
- • Remote (networked) MCP access (stdio only, intended same machine)
- • Environments needing a documented HTTP/REST API or OpenAPI contract for agents
Interface
Authentication
Authentication is delegated to the CData JDBC driver via the JDBC URL/properties (example shows OAuth initiation). The MCP server itself is launched locally; the README does not describe MCP-level user/session auth or scope enforcement beyond what the JDBC driver supports.
Pricing
README indicates licensing for the CData JDBC driver; no MCP server pricing details or free tier are provided in the supplied content.
Agent Metadata
Known Gotchas
- ⚠ Server uses stdio; only works with MCP clients on the same machine.
- ⚠ The server is positioned as read-only; agents should avoid assumptions about write/update/delete tools.
- ⚠ Underlying access is SQL SELECT via run_query; agents may need to discover table/column names first using get_tables/get_columns to avoid query failures.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for microsoft-planner-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.