MCP server enables AI agents to interact with MSSQL.
Server Config
{
"mcpServers": {
"mssql": {
"command": "npx",
"args": [
"github:stilllovee/mssql-mcp-server"
],
"env": {
"DB_SERVER": "servername",
"DB_DATABASE": "dbname",
"DB_USER": "username",
"DB_PASSWORD": "password",
"DB_TRUST_SERVER_CERTIFICATE": "true",
"DB_ENCRYPT": "true"
}
}
}
}