{"id":"cdatasoftware-microsoft-planner-mcp-server-by-cdata","name":"microsoft-planner-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/microsoft-planner-mcp-server-by-cdata","category":"devtools","subcategories":[],"tags":["mcp","microsoft-planner","jdbc","local-stdio","read-only","llm-integration"],"what_it_does":"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).","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"],"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.","alternatives":["CData managed/hosted MCP platform mentioned in README (CData Connect AI)","CData JDBC driver used directly by an application (bypassing MCP)","Any direct Microsoft Graph-based integration with a bespoke API/tooling layer"],"af_score":53.8,"security_score":56.5,"reliability_score":31.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:20.261394+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 authentication (OAuth mentioned via InitiateOAuth=GETANDREFRESH in JdbcUrl template; license step via java -jar ... --license)"],"oauth":true,"scopes":false,"notes":"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":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README indicates licensing for the CData JDBC driver; no MCP server pricing details or free tier are provided in the supplied content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":53.8,"security_score":56.5,"reliability_score":31.2,"mcp_server_quality":75.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":90.0,"auth_strength":60.0,"scope_granularity":40.0,"dependency_hygiene":50.0,"secret_handling":40.0,"security_notes":"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.","uptime_documented":0.0,"version_stability":55.0,"breaking_changes_history":40.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}