PostgreSQL

Popular

Database

Database inspection and querying interface

One-Click Installation

VS Code

Install directly via the VS Code MCP extension.

Cursor

One-click addition to your Cursor AI rules.

Other IDEs & Manual Setup

1
Windsurf

To use this MCP in Windsurf, open your ~/.codeium/windsurf/mcp_config.json and add the following entry:

2
Cline / Roo Code

For Cline (VS Code extension), add the configuration to your MCP settings file, usually located at:~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json

JSON Configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgres://user:pass@localhost:5432/db"
      ],
      "env": {}
    }
  }
}

Metadata

Package Name: @modelcontextprotocol/server-postgres
Command: npx
Community Trust: 3,200 votes