home / mcp / microsoft project mcp server

Microsoft Project MCP Server

This read-only MCP Server allows you to connect to Microsoft Project data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-microsoft-project-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/microsoft-project.prp"
      ]
    }
  }
}

You run a local, read-only MCP server that lets you query live Microsoft Project data through a simple MCP interface. It connects via the CData JDBC Driver to expose Microsoft Project as relational data, so large language models and other clients can ask natural-language questions and receive up-to-date results without writing SQL.

How to use

Once the MCP server is running on your machine, you connect an MCP client to it. The server exposes read-only tools that let you discover available data and run read-only queries. You can ask questions like which projects are currently active, what tasks are due today, or how the calendar looks across projects. The built-in tools handle data discovery and query execution, so you don’t need to write SQL.

How to install

# Prerequisites: ensure Java is installed and available on your PATH
java -version
python3 --version 2>/dev/null || echo "Python not required for MCP server, but you may use it for tooling"

# 1) Build the MCP server JAR (from sources that include the MCP server)
# Clone the project and build
# git clone https://example.com/microsoft-project-mcp-server-by-cdata.git
# cd microsoft-project-mcp-server-by-cdata
mvn clean install

# This creates the JAR: CDataMCP-jar-with-dependencies.jar

# 2) Obtain and license the CData JDBC Driver for Microsoft Project
# Download the driver from the CData site and install it following the vendor's installer
# License the driver (adjust paths to your installation)
java -jar cdata.jdbc.microsoftproject.jar --license

# 3) Configure a JDBC connection string (interactively via the utility, or prepare a .prp file)
# Example interaction to test the connection
java -jar cdata.jdbc.microsoftproject.jar
# After testing, copy the connection string for later use

# 4) Create a .prp file for the MCP server (microsoft-project.prp) with your connection details
Prefix=microsoftproject
ServerName=CDataMicrosoftProject
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.microsoftproject.jar
DriverClass=cdata.jdbc.microsoftproject.MicrosoftProjectDriver
JdbcUrl=jdbc:microsoftproject:InitiateOAuth=GETANDREFRESH;
Tables=

# 5) Run the MCP server locally (stdio mode) using the JAR and your .prp file
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/microsoft-project.prp

Additional notes

The server runs in stdio mode, so it is intended to be used with clients running on the same machine. If you need to integrate with a remote client, consider using an appropriate MCP bridge or setup that supports your environment. You can explore tools for data discovery and query execution by invoking the server's built-in commands from your MCP client.

Available tools

microsoft_project_get_tables

Retrieves a list of tables available in the data source. The output is CSV with column headers in the first line.

microsoft_project_get_columns

Retrieves a list of columns for a specified table. The output is CSV with column headers in the first line.

microsoft_project_run_query

Executes a SQL SELECT query against the connected data source and returns the results.