Install Pg Readonly in Codex
What you need first
- Codex, installed.
- uv, which
gives the
uvxcommand the server starts with. - Your own value for
YOUR_PG_READONLY_MCP_DSN.
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 pg-readonly-mcp --env PG_READONLY_MCP_DSN=YOUR_PG_READONLY_MCP_DSN -- uvx pg-readonly-mcp==0.1.1 - Replace
YOUR_PG_READONLY_MCP_DSNwith your own value. - Start Codex again and type
/mcp: the server is listed.
Check it worked
Ask Codex: List the tools of pg-readonly-mcp.
If it does not start
- spawn uvx ENOENT
- uv is not on the PATH that Codex sees. Install it, or write the
full path of
uvxin the config. - The server starts, but its tools fail
- A
YOUR_…placeholder is still in the config, or its value is wrong.