[Help] trying to configure mssql-mcp

[solutionprovider27]

trying to configure mssql-mcp with following configs but getting failed . no idea . tested nodjs from command prompt . tested command with args from cmd no problem .

mssql-mcp

{
"mcpServers": {
"mssql": {
"transport": "stdio",
"enabled": true,
"command": "C:\Program Files\nodejs\npx.cmd",
"args": [
"-y",
"mssql-mcp@latest"
],
"env": {
"DB_SERVER": "localhost",
"DB_DATABASE": "DB_STAGING",
"DB_USER": "sa",
"DB_PASSWORD": "......",
"DB_TRUST_SERVER_CERTIFICATE": "true"
},
"url": null,
"extraData": null,
"proxy": null,
"headers": null,
"exclude_tools": []
}
}
}

dive_mcp_host.host.errors.McpSessionGroupError: Client initialization error for mssql: (FileNotFoundError(2, 'The system cannot find the file specified', None, 2, None),) (1 sub-exception) +-+---------------- 1 ---------------- | Traceback (most recent call last): | File "C:\Users\masghar\AppData\Local\dive\resources\mcp-host\dive_mcp_host\host\tools\mcp_server.py", line 444, in _stdio_client_watcher | stdio_client( | File "C:\Users\masghar.dive\bin\python\Lib\contextlib.py", line 210, in aenter | return await anext(self.gen) | ^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar\AppData\Local\dive\resources\mcp-host\dive_mcp_host\host\tools\hack\stdio_server.py", line 72, in stdio_client | process = await _create_platform_compatible_process( | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar\AppData\Local\dive\resources\mcp-host\dive_mcp_host\host\tools\hack\stdio_server.py", line 186, in _create_platform_compatible_process | process = await anyio.open_process( | ^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive/host_cache\deps\anyio_core_subprocesses.py", line 190, in open_process | return await get_async_backend().open_process( | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive/host_cache\deps\anyio_backends_asyncio.py", line 2561, in open_process | process = await asyncio.create_subprocess_exec( | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\subprocess.py", line 224, in create_subprocess_exec | transport, protocol = await loop.subprocess_exec( | ^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\base_events.py", line 1756, in subprocess_exec | transport = await self._make_subprocess_transport( | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\windows_events.py", line 400, in _make_subprocess_transport | transp = _WindowsSubprocessTransport(self, protocol, args, shell, | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\base_subprocess.py", line 36, in init | self._start(args=args, shell=shell, stdin=stdin, stdout=stdout, | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\windows_events.py", line 878, in _start | self._proc = windows_utils.Popen( | ^^^^^^^^^^^^^^^^^^^^ | File "C:\Users\masghar.dive\bin\python\Lib\asyncio\windows_utils.py", line 153, in init | super().init(args, stdin=stdin_rfd, stdout=stdout_wfd, | File "C:\Users\masghar.dive\bin\python\Lib\subprocess.py", line 1026, in init | self._execute_child(args, executable, preexec_fn, close_fds, | File "C:\Users\masghar.dive\bin\python\Lib\subprocess.py", line 1538, in _execute_child | hp, ht, pid, tid = _winapi.CreateProcess(executable, args, | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | FileNotFoundError: [WinError 2] The system cannot find the file specified +------------------------------------

[johnfunmula]

Try using npx directly
"command": "npx"
Or escape the path
"command": "C:\\Program Files\\nodejs\\npx.cmd"