Install Postgres DBA MCP in Codex
What you need first
- Codex, installed.
- Docker, which
gives the
dockercommand the server starts with. - Your own value for
YOUR_DATABASE_URI.
Steps
- 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 postgres-dba-mcp --env DATABASE_URI=YOUR_DATABASE_URI -- docker run -i --rm -e DATABASE_URI ghcr.io/a-lafon/postgres-dba-mcp:0.3.3 - Replace
YOUR_DATABASE_URIwith your own value. - Start Codex again and type
/mcp: the server is listed.
Check it worked
Ask Codex: List the tools of postgres-dba-mcp.
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.