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

Clone io.github.daedalus/mcp-server-mssql from https://github.com/daedalus/mcp-server-mssql and configure it as an MCP server in your client (Claude Desktop, Cursor, or VS Code).

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

Yes, io.github.daedalus/mcp-server-mssql is open source under the MIT license. Source code is available at https://github.com/daedalus/mcp-server-mssql.

What category does io.github.daedalus/mcp-server-mssql belong to?

io.github.daedalus/mcp-server-mssql is listed under Databases MCP servers on MCPFind.

io.github.daedalus/mcp-server-mssql — MCP Server for Databases

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/

Set up in your AI client

AI clientOperating system

Merge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.

json

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

Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.

Claude Desktop setup reference

Compatible MCP Clients

io.github.daedalus/mcp-server-mssql works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.

Claude Desktop~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.

Cursor~/.cursor/mcp.jsonRestart Cursor for changes to take effect.

VS Code.vscode/mcp.jsonReload VS Code window for changes to take effect.

Windsurf~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect.

Claude Code.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.

io.github.daedalus/mcp-server-mssql