广告合作
MCP.so
登录

Microsoft Dataverse MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 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/).

#microsoft-dataverse#mcp-server#cdata

Microsoft Dataverse MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\microsoft-dataverse.prp"
      ]
    }
  }
}

Microsoft Dataverse MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

常见问题

1

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.

2

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.

3

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.

4

What transport protocol does the server use?

The server uses `stdio` transport. It cannot be accessed remotely.

5

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.

评论

其他 分类下的更多 MCP 服务器

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

广告合作