Runs queries and manages tables against Microsoft SQL Server, adapted from the reference SQLite server.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add mssql -- npx -y @modelcontextprotocol/inspector python C:mssql-mcpsrcserver.py~/.codex/config.toml
[mcp_servers.mssql]
command = "npx"
args = ["-y", "@modelcontextprotocol/inspector", "python", "C:mssql-mcpsrcserver.py"]
# codex mcp add mssql -- npx -y @modelcontextprotocol/inspector python C:mssql-mcpsrcserver.py~/.cursor/mcp.json
{
"mcpServers": {
"mssql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/inspector",
"python",
"C:mssql-mcpsrcserver.py"
]
}
}
}.vscode/mcp.json
{
"servers": {
"mssql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/inspector",
"python",
"C:mssql-mcpsrcserver.py"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"mssql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/inspector",
"python",
"C:mssql-mcpsrcserver.py"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"mssql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/inspector",
"python",
"C:mssql-mcpsrcserver.py"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"mssql": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/inspector",
"python",
"C:mssql-mcpsrcserver.py"
]
}
}
}