From microsoft
Provides access to Microsoft SQL Server (MSSQL) databases for queries, schema inspection, and data manipulation. Runs locally as a subprocess. Requires credentials like SQL_USER, SQL_PASSWORD, SERVER_NAME, and DATABASE_NAME.
Copy this JSON into your .mcp.json to enable this server
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
Review these signals before enabling this server
This MCP server needs API keys or credentials. Configure them in your environment before use.
This server connects to external services. Review the URLs it accesses before enabling.
This server has elevated permissions. Review the source code before enabling.
Server configuration and connection parameters
nodeCommand-line arguments passed to the server process
Environment variables set when the server starts
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}Sensitive values you must provide — never committed to source control
Declared capabilities of this MCP server
npx claudepluginhub melodic-software/claude-code-plugins --plugin microsoft