Microsoft Dataverse MCP Server by CData
@CDataSoftware
About Microsoft Dataverse MCP Server by CData
This read-only MCP Server allows you to connect to Microsoft Dataverse 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/).
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\microsoft-dataverse.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Microsoft Dataverse MCP Server by CData?
This read-only MCP server enables LLMs like Claude Desktop to query live Microsoft Dataverse data using natural language. It wraps the CData JDBC Driver for Microsoft Dataverse, exposing Dataverse tables as relational SQL models through a simple MCP interface.
How to use Microsoft Dataverse MCP Server by CData?
Clone the repository, build with Maven to produce the JAR, install and license the CData JDBC Driver for Microsoft Dataverse, generate a JDBC connection string using the provided utility, then create a .prp file with connection properties. Configure the client (e.g., Claude Desktop) by adding the server entry to claude_desktop_config.json, pointing to the Java executable and the JAR with the .prp file.
Key features of Microsoft Dataverse MCP Server by CData
- Query live Microsoft Dataverse data with natural language.
- Exposes get_tables, get_columns, and run_query tools.
- Based on the CData JDBC Driver for Microsoft Dataverse.
- Local, read-only MCP server using stdio transport.
- Supports all tables; optionally restrict to specific tables via config.
Use cases of Microsoft Dataverse MCP Server by CData
- Ask an LLM to summarize recent opportunities or accounts from Dataverse.
- Retrieve live calendar events or support tickets without writing SQL.
- Explore Dataverse table schema through natural language questions.
FAQ from Microsoft Dataverse MCP Server by CData
Is this server read-only?
Yes, this build provides a read-only MCP server. For full read, write, update, delete, and action capabilities, refer to CData’s managed MCP platform or the CData MCP Server for Microsoft Dataverse.
What dependencies are required?
You need the Java Runtime Environment, the CData JDBC Driver for Microsoft Dataverse (with a valid license or trial key), and Maven to build the JAR.
How does data access work?
The server uses the CData JDBC Driver to connect to Microsoft Dataverse via OAuth. The connection string is configured in a .prp file. The server runs locally and uses stdio transport, so it only works with clients on the same machine.
What transport protocol does the server use?
The server uses stdio transport. It cannot be accessed remotely.
How do I authenticate to Microsoft Dataverse?
Authentication is handled by the CData JDBC Driver. When generating the connection string, OAuth will prompt you to authenticate in your browser. The connection string (e.g., jdbc:cds:InitiateOAuth=GETANDREFRESH;) is stored in the .prp file.
Frequently asked questions
Is this server read-only?
Yes, this build provides a read-only MCP server. For full read, write, update, delete, and action capabilities, refer to CData’s managed MCP platform or the CData MCP Server for Microsoft Dataverse.
What dependencies are required?
You need the Java Runtime Environment, the CData JDBC Driver for Microsoft Dataverse (with a valid license or trial key), and Maven to build the JAR.
How does data access work?
The server uses the CData JDBC Driver to connect to Microsoft Dataverse via OAuth. The connection string is configured in a `.prp` file. The server runs locally and uses stdio transport, so it only works with clients on the same machine.
What transport protocol does the server use?
The server uses `stdio` transport. It cannot be accessed remotely.
How do I authenticate to Microsoft Dataverse?
Authentication is handled by the CData JDBC Driver. When generating the connection string, OAuth will prompt you to authenticate in your browser. The connection string (e.g., `jdbc:cds:InitiateOAuth=GETANDREFRESH;`) is stored in the `.prp` file.
Basic information
More Other MCP servers
MCP Registry
modelcontextprotocolA community driven registry service for Model Context Protocol (MCP) servers.
Sequential Thinking
modelcontextprotocolModel Context Protocol Servers
🪟 Windows-MCP
CursorTouchMCP Server for Computer Use in Windows
Unity MCP ✨
justinpbarnettUnity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.
Reactive Resume
amruthpillaiA one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!
Comments