Back to MCP Servers
MCP Server

mssql-dotnet

From microsoft
Install
1
Run in your terminal
$
npx claudepluginhub melodic-software/claude-code-plugins --plugin microsoft
Add to Your Project

Add to your .mcp.json:

{
  "mcpServers": {
    "mssql-dotnet": {
      "command": "${CLAUDE_PLUGIN_ROOT}/vendor/MssqlMcp/dotnet-publish/MssqlMcp.exe",
      "env": {
        "MSSQL_USER": "${MSSQL_DOTNET_USER:-}",
        "MSSQL_SERVER": "${MSSQL_DOTNET_SERVER:-localhost}",
        "MSSQL_ENCRYPT": "${MSSQL_DOTNET_ENCRYPT:-true}",
        "MSSQL_DATABASE": "${MSSQL_DOTNET_DATABASE:-master}",
        "MSSQL_PASSWORD": "${MSSQL_DOTNET_PASSWORD:-}",
        "MSSQL_READONLY": "${MSSQL_DOTNET_READONLY:-true}",
        "MSSQL_AUTH_TYPE": "${MSSQL_DOTNET_AUTH_TYPE:-windows}",
        "MSSQL_TRUST_CERT": "${MSSQL_DOTNET_TRUST_CERT:-true}",
        "CONNECTION_STRING": "${MSSQL_CONNECTION_STRING:-}",
        "MSSQL_CONNECTION_TIMEOUT": "${MSSQL_DOTNET_CONNECTION_TIMEOUT:-30}"
      }
    }
  }
}

Replace placeholder values for: MSSQL_AUTH_TYPE, MSSQL_PASSWORD

Security Considerations
Requires secrets

This MCP server needs API keys or credentials. Configure them in your environment before use.

External connections

This server connects to external services. Review the URLs it accesses before enabling.

Admin access level

This server has elevated permissions. Review the source code before enabling.

Details
Command${CLAUDE_PLUGIN_ROOT}/vendor/MssqlMcp/dotnet-publish/MssqlMcp.exe
Access Leveladmin
Environment Variables
MSSQL_USER=${MSSQL_DOTNET_USER:-}
MSSQL_SERVER=${MSSQL_DOTNET_SERVER:-localhost}
MSSQL_ENCRYPT=${MSSQL_DOTNET_ENCRYPT:-true}
MSSQL_DATABASE=${MSSQL_DOTNET_DATABASE:-master}
MSSQL_PASSWORD=${MSSQL_DOTNET_PASSWORD:-}
MSSQL_READONLY=${MSSQL_DOTNET_READONLY:-true}
MSSQL_AUTH_TYPE=${MSSQL_DOTNET_AUTH_TYPE:-windows}
MSSQL_TRUST_CERT=${MSSQL_DOTNET_TRUST_CERT:-true}
CONNECTION_STRING=${MSSQL_CONNECTION_STRING:-}
MSSQL_CONNECTION_TIMEOUT=${MSSQL_DOTNET_CONNECTION_TIMEOUT:-30}
Required Secrets
MSSQL_AUTH_TYPEMSSQL_PASSWORD
Capabilities
data
Actions
Plugins (1)
microsoft40