Mcp Server Mssql

io.github.daedalusPublished by GitHub account daedalusv0.1.0Updated Oct 24, 2026

MCP server for Microsoft SQL Server using mssql-python

VerifiedSTDIODesktop onlyDatabasesDeveloper Tools

Overview

AI-generated overview

Lets an assistant connect to Microsoft SQL Server, run queries and stored procedures, inspect schema, and manage transactions.

What you can do
A local MCP server for Microsoft SQL Server built on mssql-python. It exposes tools to open and close connections, list active connections, execute queries or scalar statements, fetch cursor results, call stored procedures, and commit or rollback transactions. Schema tools list tables, columns, stored procedures, primary keys, and foreign keys, and further tools parse or build connection strings, set connection and login timeouts, toggle autocommit, and report connection information.
When to use it
Useful when an assistant needs to work directly against a SQL Server instance: exploring schema, running ad hoc queries, calling stored procedures, or performing bulk copy operations during database work.
Requirements
Runs as a local process, installed from PyPI with pip install mcp-server-mssql and started with the mcp-server-mssql command, for example from a Claude Desktop configuration. It needs a reachable Microsoft SQL Server instance and a connection string; no environment variables or headers are declared in the manifest.
Before you install
The server can execute arbitrary SQL, call stored procedures, and run bulk copy operations, so it can read, change, or delete data. Transactions can be committed or rolled back, and autocommit can be enabled. Connection strings may contain credentials; treat them as secrets and point the server only at databases where such access is intended.

Installation

In SourceWeft

  1. Open Mcp Server Mssql in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

mcp-server-mssql

MCP server for Microsoft SQL Server using mssql-python.

[PyPI] [Python] [Ruff]

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

Install

bash
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:

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.gitcd mcp-server-mssqlpip install -e ".[test]"
# run testspytest
# formatruff format src/ tests/
# lintruff check src/ tests/
# type checkmypy src/

Source: README.md at commit 5cecfe0

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v0.1.0LatestSep 16, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts