Mssql MCP server

by daedalus·io.github.daedalus/mcp-server-mssql·v0.1.0

No reviews yet

MCP server for Microsoft SQL Server using mssql-python

B82/100grade B

Write a review Install

What users say

No reviews yet

Be the first

Safety scan

B82/100

full report

Adoption

New

0 stars32 downloads/wk

Reviews

Write one

Nobody has reviewed Mssql yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Mssql tools (21, 2 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

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

Public scan report

scanner v0.1.9 · 2026-09-27 · same rubric, same numbers if you re-run it

no findings

Code scan4 source files scanned25/25
–Live reliabilityno gateway calls yet and no remote to proben/a
–Tool poisoningtools not inspected (local package is not executed); not countedn/a
Auth qualitylocal package, no credentials required12/15
Maintenancelast push 159 days ago8/15
Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Overall 82/100. Components that don't apply are left out of the denominator. Any critical finding is an F.Rubric Appeal a finding JSON

How Mssql compares

Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.

Safety score: 82/100; higher than 55% of 802 Databases servers
Tools: 21; the typical Databases server has 8
Tools that change things: 10%; typical: 10%. Fewer write tools means less an agent can break
Downloads a week: 32; more than 19% of 324 Databases servers with a package

What its tools let an agent do: 15 read · 4 change · 2 run or deploy

Install Mssql in Claude Code, Cursor or VS Code

claude mcp add mcp-server-mssql -- uvx mcp-server-mssql

Add to Cursor

What the publisher says

From the Mssql repository's README, as published. We do not edit it. Read it on GitHub

mcp-server-mssql

MCP server for Microsoft SQL Server using mssql-python.

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

Install

pip install mcp-server-mssql

Usage

Run as MCP Server

mcp-server-mssql

Configure in Claude Desktop

Add to your claudedesktopconfig.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

Development

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/

Nothing above is checked by us. What we check is on the safety report.

Mssql: common questions

Is Mssql MCP server safe?: Mostly: it is graded B (82/100). Read the Mssql safety report
How do I install Mssql?: It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
Does Mssql need an API key?: Not as far as the registry entry and our scan can tell: no credentials are declared or required.
Is Mssql maintained?: The last commit was 195 days ago (2026-04-21). The latest release is v0.1.0.
What can I use instead of Mssql?: Servers from other publishers that do the same job: Mssql Reader MCP server, DBHub MCP server and Keboola MCP server.
How does Mssql compare with other Databases MCP servers?: safety score 82/100 (higher than 55% of 802 Databases servers); tools 21 (the typical Databases server has 8); tools that change things 10% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.

Alternatives to Mssql

Same job from other publishers: the closest match first, then the best rated.

Mssql Reader
Read-only MCP server for Microsoft SQL Server — schema discovery, profiling, safe querying
not reviewed
Growing
A
DBHub
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
not reviewed
Widely used
A
Keboola
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
not reviewed
Established
A
GeoLens
Read-only access to a self-hosted GeoLens spatial catalog: datasets, features, maps, sandboxed SQL.
not reviewed
Established
B
Faucet
SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.
not reviewed
Established
A