Claude MarketplacesSubmit

Mcp Server Mssql

daedalus/mcp-server-mssql

Connects Claude to Microsoft SQL Server databases with a comprehensive set of operations beyond basic queries. You get the usual execute_query and fetch_results, but also transaction controls (commit, rollback), stored procedure calls, bulk copy operations, and schema introspection tools to list tables, columns, primary keys, and foreign keys. It handles multiple simultaneous connections and lets you configure timeouts and autocommit behavior. Built on pymssql, so it works with SQL Server and Azure SQL. Reach for this when you need Claude to interact with enterprise SQL Server databases, whether you're doing data analysis, running reports, or managing database operations through conversation.

tools: 21
transport: STDIO
last updated: Apr 3, 2026

Tools

21 tools

Public tool metadata for what this MCP can expose to an agent.

connect_toolConnect to Microsoft SQL Server

Connect to Microsoft SQL Server

No parameter schema in public metadata yet.

close_connectionClose an existing connection

Close an existing connection

No parameter schema in public metadata yet.

list_connectionsList all active connections

List all active connections

No parameter schema in public metadata yet.

execute_queryExecute SQL query and return results

Execute SQL query and return results

No parameter schema in public metadata yet.

execute_scalarExecute SQL and return single value

Execute SQL and return single value

No parameter schema in public metadata yet.

fetch_resultsFetch results from a cursor

Fetch results from a cursor

No parameter schema in public metadata yet.

call_procedureCall a stored procedure

Call a stored procedure

No parameter schema in public metadata yet.

commitCommit current transaction

Commit current transaction

No parameter schema in public metadata yet.

rollbackRollback current transaction

Rollback current transaction

No parameter schema in public metadata yet.

bulk_copyPerform bulk copy operation

Perform bulk copy operation

No parameter schema in public metadata yet.

get_tablesList database tables

List database tables

No parameter schema in public metadata yet.

get_columnsList table columns

List table columns

No parameter schema in public metadata yet.

get_proceduresList stored procedures

List stored procedures

No parameter schema in public metadata yet.

get_foreign_keysList foreign keys

List foreign keys

No parameter schema in public metadata yet.

get_primary_keysList primary keys

List primary keys

No parameter schema in public metadata yet.

parse_connection_stringParse connection string

Parse connection string

No parameter schema in public metadata yet.

build_connection_stringBuild connection string

Build connection string

No parameter schema in public metadata yet.

set_connection_timeoutSet connection timeout

Set connection timeout

No parameter schema in public metadata yet.

set_login_timeoutSet login timeout

Set login timeout

No parameter schema in public metadata yet.

set_autocommitSet autocommit mode

Set autocommit mode

No parameter schema in public metadata yet.

get_connection_infoGet connection information

Get connection information

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly

Agent CaffeineSponsoredClose your lid, come back to finished work

SnugSponsoredThe clipboard manager for the AI era Promote your product hereReach 125k+ visitors monthly

WaxSponsoredBlock anything with supervision, without erasing your iPhone Promote your product hereReach 125k+ visitors monthly

knobsSponsoredSee your site on any phone, any day, in any language

Readme

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 claude_desktop_config.json:

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

Available Tools

View the full README on GitHub

Details

Repository: github.com/daedalus/mcp-server-mssql
Category: Databases
Package: mcp-server-mssql
Transport: STDIO
Registry: MCP registry, active

Related Databases MCP servers

1

Mcp Data Pipeline Connectordbsectrainer/mcp-data-pipeline-connectorUniversal data connector for CSV, Postgres, and REST APIs via DuckDB0stars

2

Mcpinstanode-dev/mcpProvision Postgres databases + webhooks from AI coding agents in one HTTP call.0stars

3

Mcp Datainfoinlet-marketplace/marketplaceTabular data for AI agents — load CSV/JSON/XLSX, query, group-by, stats (no database).0stars

4

AgentBuilderssirarchiemccarthy-oss/clawdDeploy full-stack web apps with database, file storage, auth, and RBAC via a single API call.0stars

5

Warehouse Mcpkalehdoo/warehouse-mcpProduction MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.0stars

6

Microquery Mcpmicroqueryhq/microquery-mcpSQL over real-world data — FDA, SEC, blockchain, genomics, CVEs, and more. No config.0stars