PostgreSQL Schema MCP

claude mcp add postgresql-schema --env POSTGRESQL_URL='<POSTGRESQL_URL>' --env PG_URL='<PG_URL>' --env DATABASE_URL='<DATABASE_URL>' -- docker run -i --rm mcp/postgres postgresql://host.docker.internal:5432/mydb

~/.codex/config.toml

[mcp_servers.postgresql-schema]
command = "docker"
args = ["run", "-i", "--rm", "mcp/postgres", "postgresql://host.docker.internal:5432/mydb"]
env = { POSTGRESQL_URL = "<POSTGRESQL_URL>", PG_URL = "<PG_URL>", DATABASE_URL = "<DATABASE_URL>" }

# codex mcp add postgresql-schema --env POSTGRESQL_URL='<POSTGRESQL_URL>' --env PG_URL='<PG_URL>' --env DATABASE_URL='<DATABASE_URL>' -- docker run -i --rm mcp/postgres postgresql://host.docker.internal:5432/mydb

~/.cursor/mcp.json

{
  "mcpServers": {
    "postgresql-schema": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ],
      "env": {
        "POSTGRESQL_URL": "<POSTGRESQL_URL>",
        "PG_URL": "<PG_URL>",
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "postgresql-schema": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ],
      "env": {
        "POSTGRESQL_URL": "<POSTGRESQL_URL>",
        "PG_URL": "<PG_URL>",
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "postgresql-schema": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ],
      "env": {
        "POSTGRESQL_URL": "<POSTGRESQL_URL>",
        "PG_URL": "<PG_URL>",
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-schema": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ],
      "env": {
        "POSTGRESQL_URL": "<POSTGRESQL_URL>",
        "PG_URL": "<PG_URL>",
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "postgresql-schema": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/postgres",
        "postgresql://host.docker.internal:5432/mydb"
      ],
      "env": {
        "POSTGRESQL_URL": "<POSTGRESQL_URL>",
        "PG_URL": "<PG_URL>",
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}