Azure DevOps MCP Server by CData
@CDataSoftware
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Azure DevOps (beta): https://www.cdata.com/download/download.aspx?sku=HNZK-V&type=beta
Overview
What is Azure DevOps MCP Server by CData?
Azure DevOps MCP Server by CData is a read-only Model Context Protocol (MCP) server that enables LLMs (such as Claude Desktop) to query live Azure DevOps data. It wraps the CData JDBC Driver for Azure DevOps, which exposes Azure DevOps as relational SQL models, allowing natural language questions without writing SQL.
How to use Azure DevOps MCP Server by CData?
Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Azure DevOps, configure a connection string using the provided utility, and create a .prp file with driver and JDBC URL parameters. Then configure Claude Desktop by adding the server to claude_desktop_config.json with the path to Java, the JAR, and the .prp file. Alternatively, run the server standalone with java -jar. The server exposes three tools: {servername}_get_tables, {servername}_get_columns, and {servername}_run_query. The server uses stdio transport, so the client must run on the same machine.
Key features of Azure DevOps MCP Server by CData
- Read-only MCP server for querying live Azure DevOps data
- Powered by CData JDBC Driver for Azure DevOps
- Exposes Azure DevOps as relational SQL tables
- Supports natural language queries via LLM clients
- Provides tools for listing tables, columns, and running SQL SELECT queries
- Uses stdio transport (client must be on the same machine)
Use cases of Azure DevOps MCP Server by CData
- Ask an LLM to correlate closed won opportunities with account industry
- Query the number of open tickets in a specific project
- Retrieve calendar events for today from Azure DevOps
FAQ from Azure DevOps MCP Server by CData
Is Azure DevOps MCP Server by CData read-only?
Yes, this project builds a read-only MCP server. For full read/write/update/delete capabilities, CData offers a separate beta server.
What transport does Azure DevOps MCP Server by CData use?
The server uses stdio transport, so it can only be used with clients running on the same machine.
Do I need to install additional software?
Yes, you need Java, Maven, and a licensed copy of the CData JDBC Driver for Azure DevOps.
How do I configure the connection to Azure DevOps?
Create a .prp file with a Prefix, ServerName, DriverPath, DriverClass, and JdbcUrl (obtained from the CData Connection String utility). OAuth is handled automatically if required.
What license is Azure DevOps MCP Server by CData under?
This MCP server is licensed under the MIT License. The CData JDBC Driver requires a separate license (TRIAL or purchased key).
