Install Database Postgres in Kiro CLI

What you need first

• Kiro CLI, installed.
• Node.js, which gives the npx command the server starts with.
• Your own values for YOUR_POSTGRES_HOST,YOUR_POSTGRES_USER,YOUR_POSTGRES_DATABASE.

Steps

1. Open ~/.codex/config.toml, or create it. The Codex CLI, its IDE extension and the ChatGPT desktop app share this file.
2. Add this table at the end of the file.

{
  "mcpServers": {
    "database-mcp-postgres": {
      "command": "npx",
      "args": ["-y", "@database-mcp/[email protected]"],
      "env": { "POSTGRES_HOST": "YOUR_POSTGRES_HOST", "POSTGRES_USER": "YOUR_POSTGRES_USER", "POSTGRES_DATABASE": "YOUR_POSTGRES_DATABASE" }
    }
  }
}

3. Replace YOUR_POSTGRES_HOST,YOUR_POSTGRES_USER,YOUR_POSTGRES_DATABASE with your own values.
4. Save the file and restart Kiro CLI.

Check it worked

Ask Kiro CLI: List the tools of database-mcp-postgres.

If it does not start

spawn npx ENOENT

Node.js is not on the PATH that Kiro CLI sees. Install it, or write the full path of npx in the config.

The server starts, but its tools fail

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

Nothing changes after a restart

The file is not valid JSON any more. Look for a missing comma where the block was added.