Back to MCP Servers
MCP Server

mssql-node

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-node": {
      "command": "node",
      "args": [
        "${CLAUDE_PLUGIN_ROOT}/vendor/MssqlMcp/Node/bundle/index.cjs"
      ],
      "env": {
        "ENCRYPT": "${MSSQL_NODE_ENCRYPT:-true}",
        "READONLY": "${MSSQL_NODE_READONLY:-true}",
        "SQL_USER": "${MSSQL_NODE_USER:-}",
        "AUTH_TYPE": "${MSSQL_NODE_AUTH_TYPE:-azure-default}",
        "SERVER_NAME": "${MSSQL_NODE_SERVER:-localhost}",
        "SQL_PASSWORD": "${MSSQL_NODE_PASSWORD:-}",
        "DATABASE_NAME": "${MSSQL_NODE_DATABASE:-master}",
        "CONNECTION_TIMEOUT": "${MSSQL_NODE_CONNECTION_TIMEOUT:-30}",
        "TRUST_SERVER_CERTIFICATE": "${MSSQL_NODE_TRUST_CERT:-true}"
      }
    }
  }
}

Replace placeholder values for: AUTH_TYPE, SQL_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
Commandnode
Access Leveladmin
Arguments
${CLAUDE_PLUGIN_ROOT}/vendor/MssqlMcp/Node/bundle/index.cjs
Environment Variables
ENCRYPT=${MSSQL_NODE_ENCRYPT:-true}
READONLY=${MSSQL_NODE_READONLY:-true}
SQL_USER=${MSSQL_NODE_USER:-}
AUTH_TYPE=${MSSQL_NODE_AUTH_TYPE:-azure-default}
SERVER_NAME=${MSSQL_NODE_SERVER:-localhost}
SQL_PASSWORD=${MSSQL_NODE_PASSWORD:-}
DATABASE_NAME=${MSSQL_NODE_DATABASE:-master}
CONNECTION_TIMEOUT=${MSSQL_NODE_CONNECTION_TIMEOUT:-30}
TRUST_SERVER_CERTIFICATE=${MSSQL_NODE_TRUST_CERT:-true}
Required Secrets
AUTH_TYPESQL_PASSWORD
Capabilities
data
Actions
Plugins (1)
microsoft40