MSSQL MCP Server

Name: MSSQL MCP Server
Author: daobataotie

@daobataotie

代码仓库

关于 MSSQL MCP Server

mssql mcp server

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

基本信息

分类

数据库

许可证

MIT

运行时

python

传输方式

stdio

发布者

daobataotie

配置

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

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from MSSQL MCP Server

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