microsoft-project -by-cdata

This MCP server wraps the CData JDBC Driver for Microsoft Project to expose live Microsoft Project data through the MCP interface in read-only mode. After you start the server, clients (such as Claude Desktop) can use the built-in tools to inspect the available data sources, list tables, view columns, and run read-only SQL queries against your Microsoft Project data via MCP. The available tools follow a naming convention based on your configured server name (for example, microsoft_project_by_cdata_get_tables, microsoft_project_by_cdata_get_columns, and microsoft_project_by_cdata_run_query). Use these tools to discover data structures and retrieve results in CSV or JSON formats, without writing SQL against the underlying data store directly. This approach enables LLMs to answer questions about projects, tasks, assignments, calendars, and other Microsoft Project data by querying live sources through natural language prompts.

Prerequisites:

• Java runtime (or JDK) installed on the machine where the MCP server will run
• Maven (for building the MCP server Jar)
• Access to the CData JDBC Driver for Microsoft Project (installation and license steps as described by CData)

Installation steps:

1. Clone the repository and install: git clone https://github.com/cdatasoftware/microsoft-project-mcp-server-by-cdata.git cd microsoft-project-mcp-server-by-cdata mvn clean install This builds CDataMCP-jar-with-dependencies.jar in the target directory.
2. Download and install the CData JDBC Driver for Microsoft Project from the CData website and license the driver as described in the driver documentation (including running the license step in the appropriate lib directory).
3. Create the MCP connection properties file (e.g., microsoft-project.prp) with your JDBC connection details, driver path, and other required properties as shown in the README (Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables).
4. Start the MCP server: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/microsoft-project.prp Note: The server uses stdio for communication, so it must be on the same machine as the client.
5. If using Claude Desktop or another client, configure the mcpServers entry with the appropriate command and arguments as shown in the mcp_config example above.

Tips and considerations:

• This server is read-only by design; write/update/delete operations are not exposed for the Microsoft Project data source via this MCP server.
• The MCP server relies on the CData JDBC Driver; ensure the driver is properly installed and licensed before starting the server.
• The server expects a .prp file that defines how to connect to Microsoft Project through JDBC; keep this file secure and point the server to the correct DriverPath and JdbcUrl.
• If you modify the .prp file or the JDBC driver configuration, restart the MCP server to apply changes.
• When integrating with Claude Desktop, you may need to restart Claude Desktop after adding or updating the MCP server configuration so that the client detects the new server entries.
• Example JSON-RPC methods provided in the README show how to call get_tables, get_columns, and run_query safely using the server name prefix (e.g., microsoft_project_get_tables, microsoft_project_get_columns, microsoft_project_run_query).