이 repo의 목적은 SQL을 사용하여 Dataverse 환경의 쿼리를 할 수 있습니다. GitHub Copilot 또는 Claude Desktop과 같은 인기있는 AI 도구를 사용하여 Dataverse를 쿼리하고 구성에이 MCP Server를 추가 할 수 있습니다.

이 프로젝트가 존재하지 않는 한 Sql4Cds를 만드는 Mark Carrington에게 큰 감사 합니다.

우선 순위

1. VSCode 월 (최소 월 2025 버전) 또는 Claude 데스크탑
2. Azure CLI는 DevContainer 옵션을 사용하지 않는 경우 로컬 머신에 설치 및 인증. Azure Identity Framework를 사용하여 대화형 브라우저 인증이 가능하지만, Azure CLI를 사용하여 인증이 조금 더 쉽게 관리할 수 있습니다.
3. DevContainer 내부 Dev Containers 또는 MCP Server를 실행하려면 Docker.
4. dotnet 9.0 SDK는 당신이 dotnet 공구를 설치하고 싶은 경우에.

모형 Context 의정서 (MCP) )

이것은 MCP 사양의 제작자 인 Anthropic이 모델 Context Protocol을 정의하는 방법입니다.

MCP는 애플리케이션이 LLMs에 컨텍스트를 제공하는 방법을 표준화하는 개방형 프로토콜입니다. AI 애플리케이션을 위한 USB-C 포트와 같은 MCP의 생각.

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 🔍

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.

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 🚀

[![Install as dotnet](https://img.shields.io/badge/VS_Code-Add_MCP_dotnet_tool_config-blue?logo=data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGQAAABkCAYAAABw4pVUAAAACXBIWXMAAAsTAAALEwEAmpwYAAAIGklEQVR4nO2dX2wcxRnAZ79NbIcEqqC2kKoUEVXCJrQSEi/wgAT9g1QUCakgaJHy1kpIjVJksnNOCGslsXfOTlz8EmS1eWiEhHS8Ud+liWd8Ma6NGi7O7NV2UBpVArkNCgTZhDujgL3oO/scJ3Xs+7Ozt+ubn/S9nbQ799N+Mzsz3ywhGo1Go9FoNBqNRqOpDW3vfQ9inILF7bt6J39Zo7vQFLDEDrDEx0CFh2FSMX/fX6f+9WAqt3PhB5rgiA08BlRcLcooxp3xc15LKu81p/Lnm5P5XSThmQHeVX1ixsSvwBK5W2VgbDo4WhBSjOZk7lJLMrfn/rTXVOv7XpfA3oGXgPLrK8lYSciSmFT+k5Zkrn37wOffqXUb1g1AxW6wxNztZKwmZCmSuZnmZL73of4v7611eyKMZxhUtK8momQhN8R81ZLM9z30bv5HtW5dtHg+YRoW7ytFRllCbvQx15tTuRMtJ6/tqHVTw8/uVKNBxTulyqhEyLInZr4llf/bg/35x2vd7HBip7cYVJwuR0ZVQm6Wc6Y5NatfMpdo4/eAJcbKleGbkKXIdd64qXql9dQDQMXFSmT4LwSHy7lXSN3Sln4YLDFVqYxFIXN+CsFh8k/6p7eSuoOKJ4CK6WpkYDS1j1z3VcjCSOwPpJ4wKd8JlOerlbEoZFaBkOOkXgAqdoHFv/ZDBkaj/Y8v/ReST5B6ACjfA5TP+yWjIOTA8IwWUjaeYVi8y08RxWg4MHxVCyl/KuS4ChkLQoauaCGlYr97h0F5vyoZGBtfG7ocLSFHRzeZcfdnEM++RBz5CAmK2PBWoGJYpYyCkP1npiIjBJh8EZj7P2CuVwzDkZx0n7ufqGTf0DawuFQtA2PDvvRH4RfieYbhuO3gyPnlMpbFtOnIXxMVxAa2A+WXgpBRENI2+J9wC7HHGwzHffs2Im6EI+cNR8aJnd7g27X3ph8Fi18JSgauJja1j/wpvELs8S0GkwNryrg5hglzf1jtpc29/EmwxExwMvgV0xp8GheawinE9sBw3MEyZRTjisnk01XIeBYsPhugjCGy9/QP8NqhFWIy97kKZSyGnDOYPEQSibL2NQEVL6+1EcG/4PMG5b3k95mNxeuHVojB3GPVCSmOwtxBcjizrSQZMU4D7C8+w/1Zt95DmIW86YeQxQ7/sunIp9aYCukJUMZZXMha6U5CKwQ65Qu+CSlIcb8BJg9g33TThexEg0HF24GmKDvRcLt2h1YI5n5w5IivUhZeJE+Tbvn9wjVaT202LHEyoKdixrT4c2s1O7xCkKPjd6uQAsydIoczz4AlRoORwTP4gllKk8MtBLEzdxhMJhVImQf7fQ/