Pgconsole MCP Server

Postgres Editor with Guardrails

Local serverstdio

What is the Pgconsole MCP Server?

Postgres Editor with Guardrails

The short version

What it needs from you

  • Node.js 20+

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Pgconsole MCP Server

{
  "mcpServers": {
    "pgconsole": {
      "command": "npx",
      "args": ["-y", "@pgplex/pgconsole"]
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

  • Node.js 20+

Example prompts to try

  • “Use Pgconsole to Autocomplete.”
  • “Use Pgconsole to Formatting.”
  • “Use Pgconsole to Text-to-SQL.”

Frequently asked questions

Postgres Editor with Guardrails Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.