Azure Active Directory MCP Server by CData

What is Azure Active Directory MCP Server by CData?

Azure Active Directory MCP Server by CData is a read-only MCP server that allows LLMs like Claude Desktop to query live Azure Active Directory data using natural language questions. It wraps the CData JDBC Driver for Azure Active Directory, which exposes Azure AD as relational SQL models, and serves the data through a simple MCP interface—no SQL required.

How to use Azure Active Directory MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Azure Active Directory, then create a .prp file with your JDBC connection string. Configure the MCP server in your client (e.g., Claude Desktop) using claude_desktop_config.json, pointing to java.exe and the built JAR with the .prp file as an argument. The server uses stdio transport and must run on the same machine as the client.

Key features of Azure Active Directory MCP Server by CData

• Read-only access to live Azure Active Directory data
• Exposes Azure AD as relational SQL tables via MCP tools
• LLMs query data in natural language – no SQL needed
• Built on the CData JDBC Driver for Azure Active Directory
• Local deployment; runs on the same machine as the client
• Three MCP tools: get_tables, get_columns, run_query

Use cases of Azure Active Directory MCP Server by CData

• A helpdesk LLM answering questions about user directory membership
• An analytics chatbot summarizing Azure AD user activity or groups
• A compliance assistant retrieving identity data for audit reviews
• A developer testing or prototyping MCP integrations with Azure AD

FAQ from Azure Active Directory MCP Server by CData

What dependencies does the server require?

Java (to run the JAR), the CData JDBC Driver for Azure Active Directory (installed and licensed), and Maven (to build the project). The connection is configured via a .prp properties file.

Is the server read-only or can it write/update/delete?

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate locally hosted MCP Server for Azure Active Directory.

What transport protocol does the server use?

The server uses stdio transport, so it can only be used with clients that run on the same machine (e.g., Claude Desktop locally). It does not support remote network connections.

How is data accessed and where is it stored?

Data is queried in real time from Azure Active Directory via the JDBC driver; no data is cached or stored locally by the server. The connection string (including OAuth credentials) is configured in the .prp file.

Does the server support OAuth authentication?

Yes. If the data source uses OAuth, the JDBC Driver’s Connection String utility will prompt you to authenticate in your browser during setup. The resulting connection string is then used in the .prp file.