# 安装 Microsoft SQL Server

- 类型: MCP 工具
- 说明: Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
- 仓库: https://github.com/alyiox/mcp-mssql

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "Microsoft SQL Server" MCP 服务：
执行：claude mcp add 'io-github-alyiox-mcp-mssql' -- npx -y Alyio.McpMssql
```

### Codex
```
请帮我安装 askskill 上的 "Microsoft SQL Server" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-alyiox-mcp-mssql]
command = "npx"
args = ["-y","Alyio.McpMssql"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "Microsoft SQL Server" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-alyiox-mcp-mssql": { "command": "npx", "args": ["-y","Alyio.McpMssql"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env MCPMSSQL_CONNECTION_STRING=YOUR_VALUE --env MCPMSSQL_DESCRIPTION=YOUR_VALUE --env MCPMSSQL_QUERY_MAX_ROWS=YOUR_VALUE --env MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=YOUR_VALUE --env MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env DOTNET_ENVIRONMENT=YOUR_VALUE --transport stdio io-github-alyiox-mcp-mssql -- npx -y Alyio.McpMssql
```
需要环境变量：MCPMSSQL_CONNECTION_STRING, MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, DOTNET_ENVIRONMENT

### Codex
```bash
codex mcp add --env MCPMSSQL_CONNECTION_STRING=YOUR_VALUE --env MCPMSSQL_DESCRIPTION=YOUR_VALUE --env MCPMSSQL_QUERY_MAX_ROWS=YOUR_VALUE --env MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=YOUR_VALUE --env MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS=YOUR_VALUE --env DOTNET_ENVIRONMENT=YOUR_VALUE io-github-alyiox-mcp-mssql -- npx -y Alyio.McpMssql
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-alyiox-mcp-mssql]
command = "npx"
args = ["-y","Alyio.McpMssql"]

[mcp_servers.io-github-alyiox-mcp-mssql.env]
MCPMSSQL_CONNECTION_STRING = "YOUR_VALUE"
MCPMSSQL_DESCRIPTION = "YOUR_VALUE"
MCPMSSQL_QUERY_MAX_ROWS = "YOUR_VALUE"
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS = "YOUR_VALUE"
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS = "YOUR_VALUE"
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS = "YOUR_VALUE"
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS = "YOUR_VALUE"
DOTNET_ENVIRONMENT = "YOUR_VALUE"
```
需要环境变量：MCPMSSQL_CONNECTION_STRING, MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, DOTNET_ENVIRONMENT

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-alyiox-mcp-mssql": {
      "command": "npx",
      "args": [
        "-y",
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "YOUR_VALUE",
        "MCPMSSQL_DESCRIPTION": "YOUR_VALUE",
        "MCPMSSQL_QUERY_MAX_ROWS": "YOUR_VALUE",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "YOUR_VALUE",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "YOUR_VALUE",
        "DOTNET_ENVIRONMENT": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-alyiox-mcp-mssql&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkFseWlvLk1jcE1zc3FsIl0sImVudiI6eyJNQ1BNU1NRTF9DT05ORUNUSU9OX1NUUklORyI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9ERVNDUklQVElPTiI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9RVUVSWV9NQVhfUk9XUyI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9RVUVSWV9DT01NQU5EX1RJTUVPVVRfU0VDT05EUyI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9RVUVSWV9TTkFQU0hPVF9NQVhfUk9XUyI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9RVUVSWV9TTkFQU0hPVF9DT01NQU5EX1RJTUVPVVRfU0VDT05EUyI6IllPVVJfVkFMVUUiLCJNQ1BNU1NRTF9BTkFMWVpFX0NPTU1BTkRfVElNRU9VVF9TRUNPTkRTIjoiWU9VUl9WQUxVRSIsIkRPVE5FVF9FTlZJUk9OTUVOVCI6IllPVVJfVkFMVUUifX0
需要环境变量：MCPMSSQL_CONNECTION_STRING, MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, DOTNET_ENVIRONMENT