Skip to main content
Glama
enesjakozh

MSSQL MCP Server

by daobataotie
GitHub
Python
MIT License
31
  • Apple
  • Linux
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

MSSQL MCP 服务器

English |中文

概述

MSSQL MCP 服务器，提供数据库交互和商业智能功能。该服务器支持运行 SQL 查询、分析业务数据并自动生成业务洞察备忘录。
参考官网的SQLite进行修改，适配MSSQL

成分

  • read_query
    • 执行 SELECT 查询以从数据库读取数据
  • write_query
    • 执行 INSERT、UPDATE 或 DELETE 查询
  • create_table
    • 在数据库中创建新表
  • list_tables
    • 获取数据库中所有表的列表
  • describe-table
    • 查看特定表的架构信息
  • append_insight
    • 向备忘录资源添加新的业务见解

演示

数据库表如下。列名非标准化，AI 会自行匹配。SQL 执行过程中的错误会自行纠正。

桌子

以下是演示。

演示

操作环境

  • Python 3.x
  • Packages
    • pyodbc>=4.0.39
    • pydantic>=2.0.0
    • mcp>=0.1.0
  • ODBC Driver 17 for SQL Server

用法

安装软件包

CD /d ~/mssql-mcp pip install -r requirements.txt

配置

#with server.py same folder create config.json，add： { "database": { "driver": "ODBC Driver 17 for SQL Server", "server": "server ip", "database": "db name", "username": "username", "password": "password", "trusted_connection": false }, "server": { "name": "mssql-manager", "version": "0.1.0" } }

Claude Desktop、Windsurf

# add to claude_desktop_config.json. Note：use your path { "mcpServers": { "mssql": { "command": "python", "args": [ # your path，e.g.："C:\\mssql-mcp\\src\\server.py" "~/server.py" ] } } }

光标

# Add according to the following diagram Cursor MCP. Note：use your path

光标配置

注：新版cursor也改为JSON配置，请参考上一节

MCP 检查器

# Note：use your path npx -y @modelcontextprotocol/inspector python C:\\mssql-mcp\\src\\server.py

项目结构

mssql-mcp ├── .git ├── .gitignore ├── LICENSE ├── README.md ├── README_en.md ├── README_zh.md ├── imgs │ ├── cursor_config.png │ ├── table.png │ └── demo.gif ├── requirements.txt └── src ├── __init__.py └── server.py

执照

MIT 许可证

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

How are these scores calculated?

提供数据库交互和商业智能功能，使用户能够运行 SQL 查询、分析业务数据并自动为 Microsoft SQL Server 数据库生成业务洞察备忘录。

  1. 概述
    1. 成分
      1. 演示
        1. 操作环境
          1. 用法
            1. 安装软件包
            2. 配置
            3. Claude Desktop、Windsurf
            4. 光标
            5. MCP 检查器
          2. 项目结构
            1. 执照

              Related Resources

              Related MCP Servers

              • MySQL MCP Server

                designcomputer
                A
                security
                A
                license
                A
                quality
                Allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
                Last updated -
                1
                580
                Python
                MIT License
                • Linux
                • Apple

              • MSSQL MCP Server

                c0h1b4
                -
                security
                A
                license
                -
                quality
                Enables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.
                Last updated -
                13
                TypeScript
                MIT License
                • Apple
                • Linux

              • SQL Server Express MCP Server

                hanweg
                -
                security
                A
                license
                -
                quality
                Facilitates interaction with Microsoft SQL Server Express, supporting database operations such as querying, table management, and schema inspection via natural language MCP commands.
                Last updated -
                1
                Python
                MIT License

              • MSSQL MCP Server

                JexinSam
                -
                security
                A
                license
                -
                quality
                A Model Context Protocol server that enables secure and structured interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries with controlled access.
                Last updated -
                20
                Python
                MIT License
                • Linux
                • Apple

              View all related MCP servers

              Appeared in Searches

              New MCP Servers

              MCP directory API

              We provide all the information about MCP servers via our MCP API.

              curl -X GET 'https://glama.ai/api/mcp/v1/servers/daobataotie/mssql-mcp'

              If you have feedback or need assistance with the MCP directory API, please join our Discord server