Active Directory MCP Server by CData

What is Active Directory MCP Server by CData?

A read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live Active Directory data. It wraps the CData JDBC Driver for Active Directory, exposing directory data as relational tables that can be accessed through natural language questions.

How to use Active Directory MCP Server by CData?

Clone the repository, build with mvn clean install, download and install the CData JDBC Driver for Active Directory, license the driver, configure the connection string using the driver’s utility, and create a .prp file with JDBC details. Configure the server in Claude Desktop’s claude_desktop_config.json to start querying.

Key features of Active Directory MCP Server by CData

• Read-only querying of live Active Directory data via MCP
• Uses natural language instead of SQL to retrieve information
• Built on the CData JDBC Driver for Active Directory
• Provides get_tables, get_columns, and run_query tools
• Communicates over stdio transport

Use cases of Active Directory MCP Server by CData

• Query Active Directory user attributes with natural language prompts
• List available Active Directory tables and columns via LLM-driven exploration
• Run custom SQL SELECT queries against Active Directory through an AI client
• Integrate directory data into chatbot or assistant workflows

FAQ from Active Directory MCP Server by CData

What runtime dependencies are required?

Java (to run the JAR), Apache Maven (to build), and the CData JDBC Driver for Active Directory (must be downloaded and licensed separately).

How do I configure the server to connect to my Active Directory instance?

Create a .prp file with the JDBC connection string obtained from the CData JDBC Driver’s Connection String utility, along with the required properties (Prefix, ServerName, DriverPath, DriverClass, JdbcUrl, etc.).

Is the server read-only?

Yes. The README explicitly states that this project builds a read-only MCP server.

What transport protocol does the server use?

The server uses stdio transport and can only be used with clients running on the same machine as the server.

Can I use this server with clients other than Claude Desktop?

Yes, any MCP-compatible client that supports stdio transport can be used. The setup guide uses Claude Desktop as an example.