Skip to main content
Glama

MSSQL MCP Server

MIT License
29
  • Apple
  • Linux

MSSQL MCP Server

English | 中文

Overview

MSSQL MCP Server, provides database interaction and business intelligence capabilities. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Refer to the official website's SQLite for modifications to adapt to MSSQL

Components

  • read_query
    • Execute SELECT queries to read data from the database
  • write_query
    • Execute INSERT, UPDATE, or DELETE queries
  • create_table
    • Create new tables in the database
  • list_tables
    • Get a list of all tables in the database
  • describe-table
    • View schema information for a specific table
  • append_insight
    • Add new business insights to the memo resource

Demo

The database table is as follows. The column names are not standardized, and AI will match them on its own. Errors during SQL execution will self correct.

Table

The following is the demo.

Demo

Operating environment

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

Usage

Install packages

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

config

#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" ] } } }

Cursor

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

Cursor config

Note:The new version of cursor has also been changed to JSON configuration, please refer to the previous section

MCP Inspector

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

Project Structure

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

License

MIT License

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

Provides database interaction and business intelligence capabilities, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos for Microsoft SQL Server databases.

  1. Overview
    1. Components
      1. Demo
        1. Operating environment
          1. Usage
            1. Install packages
            2. config
            3. Claude Desktop 、 Windsurf
            4. Cursor
            5. MCP Inspector
          2. Project Structure
            1. License

              Related MCP Servers

              • 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
                360
                Python
                MIT License
                • Linux
                • Apple
              • -
                security
                A
                license
                -
                quality
                Enables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.
                Last updated -
                10
                TypeScript
                MIT License
                • Apple
                • Linux
              • -
                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
              • -
                security
                A
                license
                -
                quality
                An easy-to-use bridge that lets AI assistants like Claude and Cursor IDE directly query and explore Microsoft SQL Server databases. No coding experience required!
                Last updated -
                27
                JavaScript
                GPL 3.0
                • Apple

              View all related 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