MCP.so
Sign In

MSSQL MCP Server

@daobataotie

Repository

About MSSQL MCP Server

mssql mcp server

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

Basic information

Category

Databases

License

MIT

Runtime

python

Transports

stdio

Publisher

daobataotie

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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

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

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

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Elasticsearch MCP Server

elastic

685

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295