Microsoft Planner MCP Server by CData

What is Microsoft Planner MCP Server by CData?

A read-only MCP server that lets LLMs like Claude Desktop query live Microsoft Planner data through natural language. It wraps the CData JDBC Driver for Microsoft Planner, which exposes Planner data as relational SQL models, so no SQL is required.

How to use Microsoft Planner MCP Server by CData?

Clone the repository, build with Maven, download and license the CData JDBC Driver for Microsoft Planner, configure the connection string using the provided utility, create a .prp file with connection properties, then configure Claude Desktop or run the server directly with java -jar. The server communicates via stdio.

Key features of Microsoft Planner MCP Server by CData

• Read-only access to Microsoft Planner data
• Provides get_tables, get_columns, and run_query tools
• Natural language queries via any MCP client
• Uses stdio transport (same machine as client)
• Built on the CData JDBC Driver for Microsoft Planner

Use cases of Microsoft Planner MCP Server by CData

• Ask Claude Desktop about Planner tasks, plans, or buckets
• Explore Planner schema and columns without writing SQL
• Get live answers about planner data through conversation

FAQ from Microsoft Planner MCP Server by CData

Is this server read-only?

Yes. This project builds a read-only MCP server. For full create, update, and delete capabilities, CData offers a separate MCP Server for Microsoft Planner (beta).

What transport protocol does it use?

The server uses stdio, so it can only be used with clients that run on the same machine as the server.

What tools are available?

Three tools: {servername}_get_tables (list available tables), {servername}_get_columns (list columns for a table), and {servername}_run_query (execute a SQL SELECT query).

What dependencies are required?

You need the CData JDBC Driver for Microsoft Planner installed and licensed, Java installed, and Maven to build the project.

How do I troubleshoot connection issues?

Use the Connection String utility to test the connection, then copy the resulting string into your `.prp