MSSQL MCP Server

Name: MSSQL MCP Server
Availability: InStock
Author: daobataotie

Supports UI

by daobataotie

Connect AI to Microsoft SQL Server for complex queries, data analysis, and business intelligence automation.

0 stars

3 views

Works in:WindsurfCursor

Exposes:ToolsResources

View on GitHub Docs

What it does

This MCP server connects AI models to Microsoft SQL Server (MSSQL) databases, enabling the AI to perform read and write operations, analyze business data, and automatically generate business insights.

Tools

read_query: Execute SELECT queries to retrieve data.
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 business insights to a memo resource.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": ["/path/to/mssql-mcp/src/server.py"]
    }
  }
}

Supported hosts

Claude Desktop
Windsurf
Cursor

Quick install

pip install -r requirements.txt

Information

Pricing: free
Published: 4/28/2026
stars

Related Apps

Choose your AI client and follow the steps below.

Cursor

Add to mcp.json: { "mssql": { "command": "python", "args": ["/path/to/mssql-mcp/src/server.py"] } }

Windsurf

Add to mcp_config.json: { "mssql": { "command": "python", "args": ["/path/to/mssql-mcp/src/server.py"] } }

Claude Desktop

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": ["/path/to/mssql-mcp/src/server.py"]
    }
  }
}