home / mcp / azure ad mcp server

Azure AD MCP Server

This read-only MCP Server allows you to connect to Azure Active Directory 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-azure-active-directory-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/azure-active-directory.prp"
      ]
    }
  }
}

You can query live Azure Active Directory data through a local, read-only MCP server that wraps the CData JDBC Driver. This lets you ask natural-language questions and get up-to-date results without writing SQL. It exposes Azure AD data as relational models you can access via the MCP interface.

How to use

After you configure the MCP server, use your MCP client to interact with Azure Active Directory data. Ask questions like, “What is the current number of active users?” or “Show me the list of users in a specific group.” The built-in tools will retrieve tables, columns, and query results from the Azure Active Directory data source. You do not need to craft SQL queries; the client translates your natural-language requests into the appropriate data operations.

How to install

{
  "mcpServers": {
    "azuread_mcp": {
      "type": "stdio",
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/azure-active-directory.prp"
      ]
    }
  }
}

Prerequisites you need before starting: - Java Runtime Environment (JRE) 8 or higher - Maven for building the MCP server (if you change or rebuild the project) - The CData JDBC Driver for Azure Active Directory downloaded and licensed - A prepared Azure Active Directory connection string in a .prp file

Additional sections

Configuration and runtime notes: - The MCP server runs locally and uses stdio, so it can be started on the same machine as your client. The runtime command is the Java launcher followed by the MCP jar and the path to your .prp file. - The .prp file must include the JDBC connection details your data source requires. Example content of the .prp includes keys such as Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl. Use the exact values shown by your setup to enable the connection.

Security and access: - Keep your .prp file secure, since it contains connection details and possibly OAuth-related information used to authenticate to Azure Active Directory. - If OAuth is used, you may be prompted to authenticate in a browser during the connection test phase.

Troubleshooting: - If the MCP server does not appear in your MCP client, fully quit the client and restart it so it can load new servers. - If you cannot retrieve data, verify the connection string in the .prp file and test the connection using the driver’s tooling before starting the MCP server. - If you encounter licensing issues with the CData JDBC Driver, re-run the license command in the driver’s lib folder and provide your details as prompted.

License: - This MCP server is provided under the MIT License. You can use, modify, and distribute it according to MIT terms.

Available tools

azure_active_directory_get_tables

Retrieves a list of tables available in the Azure Active Directory data source. The output is returned in CSV format with column headers as the first line.

azure_active_directory_get_columns

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

azure_active_directory_run_query

Executes a SQL SELECT query against the Azure Active Directory data source through the MCP server.