AgentHubAgentHub

Microsoft SQL Server MCP Setup & Guide

MCP ServerMCP RegistryOfficial

io.github.alyiox/mcp-mssql · v1.7.0

MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.

Repository ↗

Copy the install config on this page first, then verify docs and permissions upstream.

Overview

MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in. Microsoft SQL Server is a MCP Server listed from MCP Registry. Transports: stdio. This page includes an overview, setup tutorial, install commands, and use cases for Trae, Tongyi Lingma, Cursor, Claude Code, and VS Code.

Use cases

Code review & GitHubDatabase toolsCursor essentials

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-10-10
Install Snippets TestedCLI & JSON config syntax verified
Protocol Handshake ReadyComplies with JSON-RPC 2.0 specifications
Origin Registry ActiveSourced from official-mcp-registry
Verified ClientsClaude Code、Claude Desktop、Cursor 等
Security Tier: A+ 级 · 官方认证推荐 (A+)·Maintained by official/verified teams, audited for standard MCP protocol compliance.
No auto-generated install guide — see the source repository README.

Troubleshooting & Common ErrorsFAQ

Common connection errors and verified fixes for Microsoft SQL Server

Getting 'connection closed' or exit code 1 in Cursor / Claude Code for Microsoft SQL Server?

Usually caused by missing runtime paths or IDE environment inheritance. Fix steps: 1. Verify Node.js 18+ (npx) or Python 3.10+ (uvx) is installed; 2. Run 'which npx' or 'which uvx' in terminal, and replace 'command' with absolute path; 3. Reload or restart the client window after modifying config.

Fix Snippet
# Check binary path in terminal:
which npx
node -v
Getting 'spawn npx ENOENT' or 'command not found'?

The editor background process does not inherit your full terminal PATH. Solution: Globally install the package, or set the absolute binary path (e.g. C:\Program Files\nodejs\npx.cmd on Windows, or /usr/local/bin/npx on macOS).

Missing required environment variable or authentication failure?

Microsoft SQL Server requires environment variables (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、MCPMSSQL_ALLOW_WRITE、MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS、DOTNET_ENVIRONMENT). Ensure you have added valid keys under the 'env' object in your config file without trailing whitespace.

Fix Snippet
// .cursor/mcp.json 或 claude_desktop_config.json
{
  "env": {
    "API_KEY": "your_actual_key_here"
  }
}
Still not connecting? Read the MCP troubleshooting guide →

Tool Mock Playground

Sandbox

Microsoft SQL Server Tool Interface Simulation · Preview tool schema & outputs without local runtime

Sandbox Ready
fn: mcp_mssqlExecute the core tool interface of Microsoft SQL Server
Request ArgumentsJSON Schema
{
  "target": "Microsoft SQL Server",
  "action": "execute",
  "options": {
    "mode": "standard",
    "timeoutMs": 5000
  }
}
💡Parameters generated dynamically by Agent runtime
Agent Tool Output

Click 'Run Mock' above

to preview the raw response returned to the LLM

Env: AgentHub Virtual SandboxJSON-RPC 2.0

Decision Guide: Why & When to Use

Assess suitability before installing to save trial-and-error time

Best Suited For
  • PR review
  • Changelog generation
  • Cross-repo issue search
When NOT to Use
  • Replacing human security audit
  • Unauthorized repo access
Recommended Workflow Pairing:View Scenario →

Microsoft SQL Server + Scenario Prompt → Complete Agent Automation

MCP hands-on: install to visible results

Follow the full lab (expected UI/output + contrast checks). After installing this item, verify with the tutorial prompts.

Open tutorial →

Related resources

Often paired with

Planning with files

v3.23.0

SkillClawHub44.6k

io.clawhub.othmanadi/planning-with-files

Persistent file-based planning for multi-step AI-agent work. Keeps task_plan.md, findings.md, and progress.md on disk; lifecycle hooks inject selected project planning context. Automatic recovery reads project planning files only. Explicit session-catchup.py --metadata reads same-project local agent session records and emits aggregate counts only; --replay may emit bounded nonce-framed excerpts. Optional gated mode can request continuation only when the host supports it and never runs commands declared in Markdown. The skill has no network upload path. Use for research or work needing 5+ tool calls.

source
View on ClawHub

ClawCall

v2.0.1

SkillClawHub53.1k

io.clawhub.clawcall-dev/clawcall-dev

Use when the user wants an AI agent to place a US phone call, call a business, handle hold or phone menus, confirm/reschedule/cancel/book/follow up/check an order, reach a real person, leave voicemail, connect the user into a live call, configure ClawCall voice/personality/profile or inbound reserved-number answering, poll received inbound calls, or link a ClawCall API key. Not for SMS, email, or international calls.

source
View on ClawHub

中文公文写作

v2.0.25

SkillClawHub9.1k

io.clawhub.gongyu0918-debug/chinese-official-writing

用于中文公文、事务性材料和新闻稿件的起草、改写、压缩、润色、审校、文种核对、去口语化、降 AI 味及 Word 格式处理，适用于机关、企事业单位、学校和新闻机构。涵盖申请、请示、报告、通知、通告、意见、决定、决议、议案、公报、命令、函、复函、批复、说明、方案、纪要、公告、公示、通报、制度、规定、办法、细则、操作规程、工作要点、总结、调研、讲话、致辞、主持词、述职、可研、审查材料、技术需求、新闻消息、编者按、新闻评论，以及采购、整改、反馈和 AI 算力等场景。

source
View on ClawHub

Keep exploring AgentHub

Most people compare similar tools or check scenario guides before installing—start here.

Browse more like thisSearch similarPick by scenarioPrompt playbooksMCP hands-onReviews & comparisons

Listing badge: put AgentHub on your site

Copy either snippet into your project homepage, docs, or GitHub README. The badge is a hotlinked SVG — nothing to host — and it links back to this page so visitors can find the install steps.

PreviewListed on AgentHub: Microsoft SQL Server
HTML
<a href="https://myagenthub.cn/p/io.github.alyiox/mcp-mssql" title="Listed on AgentHub: Microsoft SQL Server" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/io.github.alyiox/mcp-mssql?lang=en" alt="Listed on AgentHub: Microsoft SQL Server" height="20" style="border:0"/>
</a>
Markdown (GitHub README)
[![Listed on AgentHub: Microsoft SQL Server](https://myagenthub.cn/badge/io.github.alyiox/mcp-mssql?lang=en)](https://myagenthub.cn/p/io.github.alyiox/mcp-mssql)

Badges are generated on the fly from /badge/<package-id>, so name and listing changes propagate automatically. Keep the link target unchanged — it is what counts as the referral.

Unified Manifest

{
  "id": "io.github.alyiox/mcp-mssql",
  "type": "mcp-server",
  "version": "1.7.0",
  "displayName": "Microsoft SQL Server",
  "description": "MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.",
  "repository": {
    "url": "https://github.com/alyiox/mcp-mssql",
    "source": "github",
    "subfolder": "src/Alyio.McpMssql"
  },
  "homepage": "https://github.com/alyiox/mcp-mssql",
  "distribution": {
    "packages": [
      {
        "registryType": "nuget",
        "identifier": "Alyio.McpMssql",
        "version": "1.7.0",
        "runtimeHint": "dnx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "MCPMSSQL_CONNECTION_STRING",
            "description": "Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.",
            "isSecret": true
          },
          {
            "name": "MCPMSSQL_DESCRIPTION",
            "description": "Optional human-readable description for the default profile."
          },
          {
            "name": "MCPMSSQL_QUERY_MAX_ROWS",
            "description": "Max rows per interactive query (default 500; ceiling 1000)."
          },
          {
            "name": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS",
            "description": "Interactive query command timeout in seconds (default 30)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS",
            "description": "Max rows for snapshot queries (default 10000; ceiling 50000)."
          },
          {
            "name": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS",
            "description": "Snapshot query timeout in seconds (default 120)."
          },
          {
            "name": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS",
            "description": "Execution plan analysis timeout in seconds (default 300; ceiling 600)."
          },
          {
            "name": "MCPMSSQL_ALLOW_WRITE",
            "description": "Enable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only — prefer a db_datareader login for a hard read-only guarantee."
          },
          {
            "name": "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS",
            "description": "Write command timeout in seconds (default 60; ceiling 600)."
          },
          {
            "name": "DOTNET_ENVIRONMENT",
            "description": "Set to Development to load dotnet user-secrets (local dev)."
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.alyiox/mcp-mssql",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.alyiox%2Fmcp-mssql/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
Microsoft SQL Server MCP Setup & Guide - AgentHub