PostgreSQL MCP Server

Requires: Node.js · A Postgres connection string (ideally a read-only role)

1. 1

   Add to your MCP config

   Pass the connection string. Use a least-privilege, read-only database user.

   jsonCopy

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

2. 2

   Ask a data question

   The agent inspects the schema first, then writes and runs a query.

You inherited a database and don't know its shape.

What to expect: The agent inspects the live schema and returns a readable overview with foreign-key relationships — grounded, not guessed.

• Follow up with 'write a read-only query that…' and review the SQL before running elsewhere.