广告合作
MCP.so
登录

MSSQL MCP Server

@daobataotie

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

daobataotie

关于 MSSQL MCP Server

mssql mcp server

#ai#mcp#mssql#sqlserver#model-context-protocol#mssqlmcp

MSSQL MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mssql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/inspector",
        "python",
        "C:\\mssql-mcp\\src\\server.py"
      ]
    }
  }
}

MSSQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is MSSQL MCP Server?

MSSQL MCP Server provides database interaction and business intelligence capabilities for Microsoft SQL Server. It enables running SQL queries, analyzing business data, and automatically generating business insight memos. It is designed for AI agents (e.g., Claude Desktop) to interact with MSSQL databases via the Model Context Protocol.

How to use MSSQL MCP Server?

Install Python packages with pip install -r requirements.txt, then create a config.json file with database connection details (driver, server, database, username, password). Configure the server as an MCP tool in Claude Desktop, Windsurf, or Cursor by pointing to server.py with the Python command. Supported tools include read_query, write_query, create_table, list_tables, describe-table, and append_insight.

Key features of MSSQL MCP Server

  • Execute SELECT, INSERT, UPDATE, and DELETE queries
  • Create new tables in the database
  • List all tables and describe table schemas
  • Append business insights to a memo resource
  • Self-correct SQL execution errors

Use cases of MSSQL MCP Server

  • Querying and analyzing business data using natural language via AI
  • Performing CRUD operations on MSSQL databases
  • Generating automated business insight memos from database content
  • Exploring database schema and table structures

常见问题

1

What dependencies are required?

Python 3.x, the packages `pyodbc>=4.0.39`, `pydantic>=2.0.0`, `mcp>=0.1.0`, and ODBC Driver 17 for SQL Server.

2

How do I configure the database connection?

Create a `config.json` file in the same folder as `server.py` with fields: driver (e.g., "ODBC Driver 17 for SQL Server"), server, database, username, password, and trusted_connection (false).

3

How do I integrate with Claude Desktop?

Add an entry to `claude_desktop_config.json` with `"command": "python"` and `"args": ["path/to/server.py"]`.

4

What operations does the server support?

It supports `read_query`, `write_query`, `create_table`, `list_tables`, `describe-table`, and `append_insight` tools.

5

Does the server require an internet connection?

No, it connects directly to a local or network-accessible MSSQL database instance via ODBC.

评论

数据库 分类下的更多 MCP 服务器

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作