PostgreSQL MCP Server

Query and manage PostgreSQL databases directly from AI assistants

CommunityActiveNot tested★MCPpedia VerifiedUpdated 4/3/2026

Data Developer Tools

★ 82.8k↓ 74.2k/wknpm

Edit this page

MCPpedia
Score

No CVEsActive1 toolsstdioMIT

How we score →

Should you use this server?

The PostgreSQL MCP Server connects your AI assistant directly to a PostgreSQL database. Run SQL queries, explore schemas, inspect data, and debug issues — all through natural conversation. You provide the connection string when configuring the server.

✓

Is it safe?

No known CVEs for @modelcontextprotocol/server-postgres.

No authentication — any process on your machine can connect to this server.

MIT. View license →

Last scanned 0 days ago.

✓

Is it maintained?

Last commit 5 days ago. 82,845 GitHub stars. 74,221 weekly downloads.

Will it work with my client?

Transport: stdio. Works with claude-desktop, cursor, claude-code, windsurf.

How much context will it use?

1 tool. Estimated ~200 tokens.

What if it doesn't work?

Common issues: JSON syntax errors in config, wrong Node.js version, npx cache. Setup guide covers troubleshooting. Or check GitHub issues for known problems.

Quick Install

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

Setup guide

Test This Server

Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.

npx -y @modelcontextprotocol/server-postgres 2>&1 | head -1 && echo "✓ Server started successfully"

After testing, let us know if it worked:

Tools (1)

query

Execute a SQL query on the connected database

API Info

API: PostgreSQL
Pricing: free
Auth required: No

Score Breakdown

MCPpedia Score

Click each category to see evidence

98A

Scored 1h ago

How we score →

Security

30/30

Last scanned 1h ago

No known vulnerabilities.

✓

CVEs — No known CVEs for this packagecheck OSV.dev \u2192

○

Authentication — None required — easy to connect

✓

License — MITview license \u2192

✓

Repository — Activeview repo \u2192

✗

MCPpedia review — Not yet reviewed by MCPpedia

CVEs checked daily via OSV.dev. Score algorithm is open source.

Embed this score in your READMEPreview badge

[![MCPpedia Score](https://mcppedia.org/api/badge/postgres)](https://mcppedia.org/s/postgres)

Reviews

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?