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

常见问题

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.

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).

How do I integrate with Claude Desktop?

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

What operations does the server support?

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

Does the server require an internet connection?

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

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

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.

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl