Back to MCP directory
publicPublicdnsLocal runtime

SQL Server Schema Explorer

用于查询SQL Server数据库结构的MCP项目

article

README

🚀 MsSqlMCP

MsSqlMCP 是一款实用工具,可用于查询 SQL Server 数据库模式,涵盖表、列以及关系等信息,为数据库管理和开发提供便利。

🚀 快速开始

✨ 主要特性

  • 能够查询 SQL Server 数据库的模式,包括表、列和关系。

📦 安装指南

先决条件

  • .NET 9
  • SQL

🔧 配置

要在 Visual Studio Code 中配置 Copilot,请将 MCP 服务器配置添加到 settings.json 文件中:

"mcp": {
    "inputs": [],
    "servers": {
        "MsSqlMCP": {
            "type": "stdio",
            "command": "dotnet",
            "args": [
                "run",
                "--project",
                "c:\\{path of repository}\\MsSqlMCP\\MsSqlMCP.csproj"
            ]
        }
    }
}
help

Runtime guide

cloud

Hosted runtime

Hosted servers run from a provider-managed environment. You usually connect the MCP client to the hosted endpoint or follow the provider's authorization flow, without keeping a local process alive

  1. Open provider connection page
  2. Authorize or copy endpoint
  3. Connect from your MCP client
terminal

Local runtime / other methods

Local servers run on your own machine or infrastructure. You normally copy the server_config into your MCP client, install the required package, and provide env variables from env_schema when needed

  1. Copy server_config
  2. Install required package
  3. Fill env variables and restart client