Skip to content

DATABASE_URI not picked up #121

@fean

Description

@fean
{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@[server]:[port]/dbname"
      }
    }
  }
}

After adding this to the .claude.json, it boots the container but can't actually use the DB:

Container logs:

postgres-mcp --access-mode=unrestricted

----------------

[12/15/25 13:08:53] INFO     Starting PostgreSQL MCP Server in     server.py:555

                             UNRESTRICTED mode                                  

                    WARNING  error connecting in 'pool-1':     pool_async.py:691

                             connection is bad: connection to                   

                             server on socket                                   

                             "/var/run/postgresql/.s.PGSQL.543                  

                             2" failed: No such file or                         

                             directory                                          

                                     Is the server running                      

                             locally and accepting connections                  

                             on that socket?               

The server doesn't actually run on that port. I also saw that the repo is pretty much dead after the temporal take over, anyone have any ideas on what's up?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions