PostgreSQL MCP Server

claude mcp add postgresql-server-musaddiq-dev --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server

~/.codex/config.toml

[mcp_servers.postgresql-server-musaddiq-dev]
command = "uvx"
args = ["mdev-postgresql-mcp-server"]
env = { POSTGRES_HOST = "<POSTGRES_HOST>", POSTGRES_PORT = "<POSTGRES_PORT>", POSTGRES_USER = "<POSTGRES_USER>", POSTGRES_PASSWORD = "<POSTGRES_PASSWORD>", POSTGRES_DB = "<POSTGRES_DB>" }

# codex mcp add postgresql-server-musaddiq-dev --env POSTGRES_HOST='<POSTGRES_HOST>' --env POSTGRES_PORT='<POSTGRES_PORT>' --env POSTGRES_USER='<POSTGRES_USER>' --env POSTGRES_PASSWORD='<POSTGRES_PASSWORD>' --env POSTGRES_DB='<POSTGRES_DB>' -- uvx mdev-postgresql-mcp-server

~/.cursor/mcp.json

{
  "mcpServers": {
    "postgresql-server-musaddiq-dev": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "postgresql-server-musaddiq-dev": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "postgresql-server-musaddiq-dev": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-server-musaddiq-dev": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "postgresql-server-musaddiq-dev": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}