MCP Server for querying Dataverse using SQL
概览
The objective of this repo is to enable querying of Dataverse environment using SQL. You can use popular AI tools such as GitHub Copilot or Claude Desktop to query Dataverse, provided you add this MCP Server in the configuration. A big thank you to Mark Carrington for creating Sql4Cds, without whom this project would not exist. 🙏 1. VSCode March (minimum March 2025 version) or Claude Desktop 2. Azure CLI installed and authenticated on your local machine, if you are not using the DevContainer option. While interactive browser authentication is possible using Azure Identity framework, using Azure CLI to manage the authentication is little easier. 3. Docker, if you want to run Dev Containers or the MCP Server inside DevContainer. 4. dotnet 9.0 SDK if you want to install the dotnet tool. This is how Anthropic, the creators of MCP specification, defines Model Context Protocol MCP is an open protocol that standardizes how applications provide context to LLMs.
README
以下为原文 README 节选，完整内容请查看原文。
Overview
The objective of this repo is to enable querying of Dataverse environment using SQL. You can use popular AI tools such as GitHub Copilot or Claude Desktop to query Dataverse, provided you add this MCP Server in the configuration.
A big thank you to Mark Carrington for creating Sql4Cds, without whom this project would not exist. 🙏
Prerequisites 🔍
- VSCode March (minimum March 2025 version) or Claude Desktop
- Azure CLI installed and authenticated on your local machine, if you are not using the DevContainer option. While interactive browser authentication is possible using Azure Identity framework, using Azure CLI to manage the authentication is little easier.
- Docker, if you want to run Dev Containers or the MCP Server inside DevContainer.
- dotnet 9.0 SDK if you want to install the dotnet tool.
Model Context Protocol (MCP) 📋
This is how Anthropic, the creators of MCP specification, defines Model Context Protocol
MCP is an open protocol that standardizes how applications provide context to LLMs. Think of MCP like a USB-C port for AI applications. Just as USB-C provides a standardized way to connect your devices to various peripherals and accessories, MCP provides a standardized way to connect AI models to different data sources and tools.
Installation 🚀
安装
This server does not publish a one-line install command.
Open the repository installation guide 新手？先看 mcpskill.org 教程 →