This MCP server provides a read-only interface to Microsoft Planner data via the CData JDBC Driver. It wraps the JDBC driver and exposes the data through the MCP API, allowing large language models and tooling to query live Planner information without writing SQL directly. After running the server, you can connect an MCP client (for example Claude Desktop or another MCP-compatible client) and use the built-in tools to discover data structures and run queries. The available tools follow a standard naming convention based on your configured server name, such as microsoft-planner_get_tables, microsoft-planner_get_columns, and microsoft-planner_run_query. These tools return results as CSV for tables and columns, and as result sets for queries. You don’t typically need to call tools explicitly; you can ask the client to explore the schema or fetch specific data, e.g., “list all tables in Microsoft Planner” or “show me open tasks.”

Prerequisites:

• Java (JDK) 8+ installed on your system
• Maven for building the MCP server
• Access to the CData JDBC Driver for Microsoft Planner (download and install per CData instructions)

Installation steps:

1. Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/microsoft-planner-mcp-server-by-cdata.git cd microsoft-planner-mcp-server-by-cdata

2. Build the MCP server JAR with dependencies: mvn clean install

   This produces CDataMCP-jar-with-dependencies.jar

3. Install the CData JDBC Driver for Microsoft Planner following CData's guidance:

   • Download the driver from https://www.cdata.com/drivers/msplanner/download/jdbc
   • Install it on your system according to the platform-specific instructions
   • License the driver as required (per CData instructions)

4. Create the MCP PRP (properties) file for Microsoft Planner (e.g., microsoft-planner.prp) with your connection details, such as: Prefix=msplanner ServerName=CDataMSPlanner ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.msplanner.jar DriverClass=cdata.jdbc.msplanner.MSPlannerDriver JdbcUrl=jdbc:msplanner:InitiateOAuth=GETANDREFRESH; Tables=

5. Run the MCP server: java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/microsoft-planner.prp

Notes:

• The server runs on stdio; it should be run on the same machine as the client unless you configure a different IPC method supported by your environment.
• Ensure the Java process has access to the JDBC driver and the.prp file path specified in the command arguments.

Tips and caveats:

• If Claude Desktop or your MCP client cannot show the server, fully quit and restart the client so it re-scans available MCP servers.
• Ensure the JDBC driver is licensed and accessible to the MCP server process (DriverPath in the .prp must be correct).
• The server is read-only by default in this package; if you need write/update/delete capabilities, use the full MCP Server for Microsoft Planner (as noted in the project notes).
• For connection strings and OAuth, you may need to complete authentication in a browser as prompted by the JDBC driver utility.
• When using Claude Desktop, you may need to copy the claude_desktop_config.json to the appropriate user directory for your OS, and then refresh the client.