MCP Server Mssql

MCP server for Microsoft SQL Server using mssql-python

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-server-mssql": {
      "command": "uvx",
      "args": [
        "mcp-server-mssql"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Documentation Overview

mcp-server-mssql

MCP server for Microsoft SQL Server using mssql-python.

mcp-name: io.github.daedalus/mcp-server-mssql

Install

Terminal

pip install mcp-server-mssql

Usage

Run as MCP Server

bash

mcp-server-mssql

Configure in Claude Desktop

Add to your claude_desktop_config.json:

config.json

{
  "mcpServers": {
    "mcp-server-mssql": {
      "command": "mcp-server-mssql"
    }
  }
}

Available Tools

connect_tool - Connect to Microsoft SQL Server
close_connection - Close an existing connection
list_connections - List all active connections
execute_query - Execute SQL query and return results
execute_scalar - Execute SQL and return single value
fetch_results - Fetch results from a cursor
call_procedure - Call a stored procedure
commit - Commit current transaction
rollback - Rollback current transaction
bulk_copy - Perform bulk copy operation
get_tables - List database tables
get_columns - List table columns
get_procedures - List stored procedures
get_foreign_keys - List foreign keys
get_primary_keys - List primary keys
parse_connection_string - Parse connection string
build_connection_string - Build connection string
set_connection_timeout - Set connection timeout
set_login_timeout - Set login timeout
set_autocommit - Set autocommit mode
get_connection_info - Get connection information

Development

bash

git clone https://github.com/daedalus/mcp-server-mssql.git
cd mcp-server-mssql
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Server Mssql

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "mcp-server-mssql": { "command": "npx", "args": ["-y", "mcp-server-mssql"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

MCP Server Mssql AllMCPs Directory Badge

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/mcp-server-mssql?style=directory)](https://allmcps.com/mcp/mcp-server-mssql)

HTML Embed

<a href="https://allmcps.com/mcp/mcp-server-mssql"><img src="https://allmcps.com/api/badge/mcp-server-mssql?style=directory" alt="MCP Server Mssql on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

35Quality signal: Fair · 35/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools15/30

Adoption & activity1/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge and attach your website — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Server Mssql →Install in Claude Desktop Install in Cursor Install in VS Code

Documentation Overview

mcp-server-mssql

MCP server for Microsoft SQL Server using mssql-python.

mcp-name: io.github.daedalus/mcp-server-mssql

Install

Terminal

pip install mcp-server-mssql

Usage

Run as MCP Server

bash

mcp-server-mssql

Configure in Claude Desktop

Add to your claude_desktop_config.json:

config.json

{
  "mcpServers": {
    "mcp-server-mssql": {
      "command": "mcp-server-mssql"
    }
  }
}

Available Tools

connect_tool - Connect to Microsoft SQL Server
close_connection - Close an existing connection
list_connections - List all active connections
execute_query - Execute SQL query and return results
execute_scalar - Execute SQL and return single value
fetch_results - Fetch results from a cursor
call_procedure - Call a stored procedure
commit - Commit current transaction
rollback - Rollback current transaction
bulk_copy - Perform bulk copy operation
get_tables - List database tables
get_columns - List table columns
get_procedures - List stored procedures
get_foreign_keys - List foreign keys
get_primary_keys - List primary keys
parse_connection_string - Parse connection string
build_connection_string - Build connection string
set_connection_timeout - Set connection timeout
set_login_timeout - Set login timeout
set_autocommit - Set autocommit mode
get_connection_info - Get connection information

Development

bash

git clone https://github.com/daedalus/mcp-server-mssql.git
cd mcp-server-mssql
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/