Skip to content

fix Incorrect DATABASE_URL without +psycopg on deployment/mcpgateway/docker-compose.yml #124

Description

@FrancescoBaroneItaly

Before submitting your bug report

Bug description

Need to add into DATABASE_URL the psycopg statement to force to use psycopg3

line44

  • DATABASE_URL=postgresql://postgres:${POSTGRES_PASSWORD:-mysecretpassword}@postgres:5432/mcp
  • DATABASE_URL=postgresql+psycopg://postgres:${POSTGRES_PASSWORD:-mysecretpassword}@postgres:5432/mcp

thank you

Steps to reproduce

follow podman deployment to reproduce ( see podman mcpgateway logs)

Expected behavior

database connection using psycopg3

Actual behavior

mcpgateway podman fails

SQL Tool Information

No response

Environment information

- **OS**: [e.g., macOS 14.2, Windows 11, Ubuntu 22.04]
- **MCP Server Version**: [e.g., 0.1.2]
- **IBM i OS Version**: [e.g., 7.5]
- **MCP Client**: [e.g., Claude Desktop 0.7.1, Continue, Zed]
- **Node.js Version**: [e.g., v20.10.0]
- **Connection Method**: [e.g., Environment variables, YAML sources, HTTP authentication]

Server configuration

No response

Log output

Screenshots or videos

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions