MSSQL MCP Server

@daobataotie

Repository

Basic information

About MSSQL MCP Server

mssql mcp server

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

MSSQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

MSSQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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

Frequently asked questions

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.

Comments

More Databases MCP servers

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s