English Français العربية

io.github.daedalus/mcp-server-mssql

Official registry Data and databases

MCP server for Microsoft SQL Server using mssql-python

Source code Documentation

What can you do with io.github.daedalus/mcp-server-mssql?

  • 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

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

PYPI package mcp-server-mssql
Claude Code 
claude mcp add mcp-server-mssql -- uvx mcp-server-mssql==0.1.0
JSON configuration (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "mcp-server-mssql": {
            "command": "uvx",
            "args": [
                "mcp-server-mssql==0.1.0"
            ]
        }
    }
}

Documentation

From the project's README on GitHub, refreshed weekly. Links open on GitHub.

Contents
  1. mcp-server-mssql
  2. Install
  3. Usage
  4. Available Tools
  5. Development

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

  • 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

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/

Frequently asked questions

What is io.github.daedalus/mcp-server-mssql?

MCP server for Microsoft SQL Server using mssql-python

How do I install io.github.daedalus/mcp-server-mssql?

It runs on your machine. In Claude Code: claude mcp add mcp-server-mssql -- uvx mcp-server-mssql==0.1.0. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.daedalus/mcp-server-mssql need an API key?

Its registry entry lists no required key or secret. Some features may still need an account with the service it connects to.

Is io.github.daedalus/mcp-server-mssql open source?

Yes. Its code is on GitHub under the MIT license.

Who maintains io.github.daedalus/mcp-server-mssql?

It is published by daedalus. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.