Postgres MCP Server

Overview

The reference Postgres MCP server is part of the modelcontextprotocol/servers monorepo. It teaches the agent the schema, exposes read-only queries by default, and is the cleanest answer when an agent needs to look at production data without anyone copy-pasting a connection string.

Best for

Best for
Teams on raw Postgres (not Supabase) who want agent DB access

Use cases

• Let an agent answer 'what does the schema look like' without a DB GUI
• Run scoped analytical queries in read-only mode
• Use as a starter for your own DB-flavoured MCP server
• Local dev workflow against a Postgres in Docker

How to use

Install

npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydb

Tested with

Claude Desktop

Example client config

{\n  "mcpServers": {\n    "postgres": {\n      "command": "npx",\n      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"]\n    }\n  }\n}

Notes

Why it matters

Not every team is on Supabase. The reference Postgres MCP is the cleanest answer for the still-very-large set of teams on raw Postgres or RDS.

How teams use it in production

Pin to a read-only role. Wrap with logging. Use a second server, locked tighter, for the rare write path.

What to watch

The line between this server and a richer “agent DBA” surface (explain plans, query suggestions) is closing. Expect a feature-rich fork within a year.