Question 1

What is an MCP Server?

Accepted Answer

MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. An MCP server acts as a bridge, allowing AI models to access and interact with external data sources and tools.

Question 2

What is the CData MCP Server for Active Directory?

Accepted Answer

It's a read-only MCP server that allows you to connect to Active Directory data from Claude Desktop through CData JDBC Drivers, enabling natural language querying.

Question 3

Where can I find a read/write version of the MCP Server?

Accepted Answer

Free (beta) read/write servers are available at [https://www.cdata.com/solutions/mcp](https://www.cdata.com/solutions/mcp).

Question 4

What JDBC driver does this MCP Server use?

Accepted Answer

This server uses the CData JDBC Driver for Active Directory, which exposes Active Directory data as a relational SQL model.

Question 5

Do I need SQL knowledge to use this server?

Accepted Answer

No, the MCP interface allows LLMs to retrieve live information by asking natural language questions, eliminating the need for SQL.

Question 6

How do I set up the CData MCP Server for Active Directory?

Accepted Answer

The setup involves cloning the repository, building the server, downloading and licensing the CData JDBC Driver, configuring the connection, creating a `.prp` file, and configuring Claude Desktop.

Question 7

What is a `.prp` file and what should it contain?

Accepted Answer

A `.prp` file is a configuration file that contains connection details for the JDBC driver. It includes properties like Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables.

Question 8

How do I add the MCP server to Claude Desktop?

Accepted Answer

You need to create or modify the `claude_desktop_config.json` file to add the new MCP server configuration, including the command and arguments for running the server.

Question 9

What are the available tools exposed by the server?

Accepted Answer

The server exposes tools like `{servername}_get_tables` (to list tables), `{servername}_get_columns` (to list columns for a table), and `{servername}_run_query` (to execute SQL queries).

Question 10

Can I script requests to the MCP server instead of using an AI Client?

Accepted Answer

Yes, you can use JSON-RPC to call the available tools. Example JSON payloads are provided in the documentation.

Question 11

What should I do if I cannot see my CData MCP Server in Claude Desktop?

Accepted Answer

Ensure that you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Question 12

What if Claude Desktop is unable to retrieve data?

Accepted Answer

Verify that you have configured your connection properly. Use the Connection String builder to create the connection string and copy it into the `.prp` file.

Question 13

Where can I get help if I'm having trouble connecting to my data source?

Accepted Answer

Contact the CData Support Team at [https://www.cdata.com/support/submit.aspx](https://www.cdata.com/support/submit.aspx).

Question 14

Where can I get help if I'm having trouble using the MCP server?

Accepted Answer

Join the CData Community at [https://community.cdata.com](https://community.cdata.com).

Question 15

What is UBOS and how does it relate to this MCP Server?

Accepted Answer

UBOS is a full-stack AI Agent Development Platform that helps you orchestrate AI Agents, connect them with your enterprise data, and build custom AI Agents with your LLM model and Multi-Agent Systems. Using this server with UBOS allows for centralized management, enhanced security, scalability, and customization.

Question 16

What license is the MCP server released under?

Accepted Answer

This MCP server is licensed under the MIT License.

Active Directory MCP Server by CData

Resources

Project Details

Recomended MCP Servers

Featured Templates

AI-Powered Product List Manager

AI-Powered Essay Outline Generator

Python Bug Fixer

AI Voice Assistant (Voice-Text-Voice)

Image to text with Claude 3

AI Video Generator

Start your free trial