Postgres MCP Server

Read-only SQL with schema inspection.

Official — published by the vendor of the system it connects to.

Inspect tables and columns, then run read-only queries against them. The connection is opened read-only at the driver level, so no prompt injection can turn a SELECT into a DROP.

Install Postgres MCP Server

Paste this into your MCP client config — Claude Desktop, Claude Code, Cursor, VS Code and Windsurf all read the same shape — then restart the client.

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

Config for each MCP client

The same server, in the shape each client expects. Copy the block for yours, restart it, and Postgres MCP Server appears in your next session.

Claude Desktop

claude_desktop_config.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/db"
      ]
    }
  }
}

Full Claude Desktop setup guide

Claude Code

terminal
claude mcp add postgres -- npx -y @modelcontextprotocol/server-postgres postgresql://localhost/db

Full Claude Code setup guide

Cursor

.cursor/mcp.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/db"
      ]
    }
  }
}

Full Cursor setup guide

VS Code

.vscode/mcp.json
{
  "servers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/db"
      ]
    }
  }
}

Full VS Code setup guide

Windsurf

mcp_config.json
{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/db"
      ]
    }
  }
}

Full Windsurf setup guide

Details

Repository
https://github.com/modelcontextprotocol/servers
Homepage
https://github.com/modelcontextprotocol/servers
Category
Database
Stars
5600
Installs per month
58000
Last checked

Frequently asked questions

How do I install Postgres MCP Server?

Add it to your MCP client's config with the command `npx -y @modelcontextprotocol/server-postgres postgresql://localhost/db`, or paste the ready-made JSON block above into Claude Desktop, Cursor, VS Code or Windsurf. Claude Code users can run `claude mcp add postgres` instead. Restart the client and the tools appear in the next session.

Does Postgres MCP Server need an API key?

No credential is recorded for this listing, which usually means it runs against something local or public rather than an authenticated API. Check the repository's README before assuming, and if you find otherwise, tell us and we will correct the listing.

Which clients work with Postgres MCP Server?

Any MCP client. Claude Desktop, Claude Code, Cursor, VS Code with Copilot, Windsurf, Zed, Cline and Continue all speak the Model Context Protocol, so a server written once works in all of them — only the location of the config file differs.

Is Postgres MCP Server free?

The server itself is free and open source, and you run it yourself. It is published by the vendor of the system it connects to, so that service's own pricing applies to whatever it reaches.

Other Database servers

All Database MCP servers · The full MCP server list · Install guides