Install pgmcp in Codex

What you need first

• Codex, installed.
• Docker, which gives the docker command the server starts with.
• Your own value for YOUR_PGMCP_DATABASE_URL.

Steps

1. Run this in a terminal. It writes the server into ~/.codex/config.toml, which the Codex CLI, its IDE extension and the ChatGPT desktop app share.

codex mcp add pgmcp --env PGMCP_DATABASE_URL=YOUR_PGMCP_DATABASE_URL -- docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0

2. Replace YOUR_PGMCP_DATABASE_URL with your own value.
3. Start Codex again and type /mcp: the server is listed.

Check it worked

Ask Codex: List the tools of pgmcp.

If it does not start

Cannot connect to the Docker daemon

Docker is not running. Start it, then restart Codex.

The server starts, but its tools fail

A YOUR_… placeholder is still in the config, or its value is wrong.