Microsoft Planner by CData

Microsoft Planner by CData is an MCP server that enables Large Language Models to inspect and retrieve live project management data from Microsoft Planner. Built as a Java application wrapping the CData JDBC Driver for Microsoft Planner, it exposes Planner tables and task structures as relational SQL models. It is designed for project managers, enterprise analysts, and developers using MCP-compliant clients such as Claude Desktop who need quick access to plan metrics without writing manual SQL or switching between project tabs. By leveraging standard Model Context Protocol tooling, the server allows natural language querying of tasks, project buckets, assignment states, and plan timelines. The server functions over standard input and output (stdio), querying your live Microsoft Planner instance through standard JDBC connections while enforcing read-only data access for safe, non-destructive enterprise task inspection and reporting.

Category: CRM, ERP & E-commerce

Tags: cdata, jdbc, microsoft-planner, tasks

Visit Microsoft Planner by CData

How to install and configure Microsoft Planner by CData

1. Clone the repository and build the project: bash git clone https://github.com/cdatasoftware/microsoft-planner-mcp-server-by-cdata.git cd microsoft-planner-mcp-server-by-cdata mvn clean install 2. Download and install the CData JDBC Driver for Microsoft Planner, then license it using java -jar cdata.jdbc.msplanner.jar --license. 3. Configure your connection by launching the connection utility via java -jar cdata.jdbc.msplanner.jar and generating your JDBC connection string. 4. Create a .prp configuration file (e.g., microsoft-planner.prp) defining Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl. 5. Register the server in your claude_desktop_config.json under mcpServers: json { "mcpServers": { "msplanner": { "command": "PATH\\TO\\java.exe", "args": [ "-jar", "PATH\\TO\\CDataMCP-jar-with-dependencies.jar", "PATH\\TO\\microsoft-planner.prp" ] } } } 6. Restart Claude Desktop completely to load the new server.

What you can do with Microsoft Planner by CData

• Listing all active tasks across specific Microsoft Planner boards using natural language prompts in Claude. - Inspecting task assignment details, upcoming deadlines, and overdue items across enterprise project buckets. - Executing SQL SELECT queries through LLM tools to generate cross-project progress and status summaries. - Discovering database table schemas and column layouts for custom Microsoft Planner reporting workflows.

Key facts

• https://github.com/CDataSoftware/microsoft-planner-mcp-server-by-cdata
• CRM, ERP & E-commerce, Project & Task Management
• cdata, jdbc, microsoft-planner, tasks

Part of MCP Servers

What can Microsoft Planner by CData do?

It allows compatible AI clients to discover available Microsoft Planner tables, inspect column schemas, and execute read-only SQL queries. Users can ask conversational questions about active tasks, assignees, and project plans to receive direct information pulled from the underlying CData JDBC connection.

Which MCP clients work with Microsoft Planner by CData?

The server runs locally over standard input/output (stdio) and works with any MCP client supporting local Java process execution, including Claude Desktop on Windows, macOS, or Linux.

Can Microsoft Planner by CData create or edit tasks?

No, this repository builds a read-only MCP server limited to executing SQL SELECT statements. Full read, write, update, and delete actions require commercial CData tooling.

Is Microsoft Planner by CData open source?

Yes, the MCP server wrapper code is licensed under the MIT License. However, running it requires the commercial CData JDBC Driver for Microsoft Planner, which requires a separate trial or commercial license.