Error connecting to Docker Postgres

[Fgabz]

I've tried to add MCP Postgres server, however got issue while trying with Claude

Error

---

2024-11-26T23:31:11.185Z [error] Could not start MCP server postgres: Error: spawn npx ENOENT
    at ChildProcess._handle.onexit (node:internal/child_process:286:19)
    at onErrorNT (node:internal/child_process:484:16)
    at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
  errno: -2,
  code: 'ENOENT',
  syscall: 'spawn npx',
  path: 'npx',
  spawnargs: [Array]
}

Config

---

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://postgres:postgres@localhost:5432/bounce_persistence_dev"
      ]
    }
  }
}

➜  ~ which npx

/Users/fanilo/.asdf/shims/npx

Check

---

and I confirm that db was running with

psql postgresql://postgres:postgres@localhost:5432/mydb

[Fgabz]

Ok fixed.

I'll let the issue open for others

Solution (MacOs)

sudo mkdir -p /usr/local/bin

➜  ~ sudo ln -s /Users/YOUR_USER/.asdf/shims/npx /usr/local/bin/npx

[rockywangxiaolei]

i also got similar problem using MCP server to connect a docker postgresql.
my env is windows 11.
i can see the config has been loaded to Claude desktop (under top menu:file->settings->developer).
there is also logs showing db connected as below:
2024-11-27T08:26:15.225Z [info] Attempting to connect to MCP server postgres...
2024-11-27T08:26:15.250Z [info] Connected to MCP server postgres!
2024-11-27T08:40:21.735Z [info] Attempting to connect to MCP server postgres...
2024-11-27T08:40:21.769Z [info] Connected to MCP server postgres!
however , on the chat interface it keep showing "Could not attach to MCP server postgres"

tried the solution you shared using command under windows but doesnt work.

[jspahrsummers]

Per #40 (comment), issues with npx on Windows should now be resolved. Please comment on that issue if the fix doesn't work for you.