dev-tools

postgres

MCP server 'postgres' from TIHLDE/Photon

2 stars0 upvotes

Install Command

sh -c docker rm -f postgres-mcp 2>/dev/null; docker run -i --rm --name postgres-mcp -e DATABASE_URI="$DATABASE_URI" crystaldba/postgres-mcp --access-mode=unrestricted

Configuration

.mcp.json
{
  "postgres": {
    "env": {
      "DATABASE_URI": "postgresql://postgres:password@localhost:5432/photon_db"
    },
    "args": [
      "-c",
      "docker rm -f postgres-mcp 2>/dev/null; docker run -i --rm --name postgres-mcp -e DATABASE_URI=\"$DATABASE_URI\" crystaldba/postgres-mcp --access-mode=unrestricted"
    ],
    "command": "sh"
  }
}

Links

GitHubSource

Tags

mcppostgres