PostgreSQL MCP Server

MCP server · by YawLabs

Databases npm v0.13.10

PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

View source ↗ Website ↗ Generate config for multiple servers More servers

Install

Pin version registry version 0.13.10

npm
npx -y @yawlabs/postgres-mcp

npm
npx -y @yawlabs/postgres-mcp@0.13.10

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp@0.13.10"
      ]
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

terminal

claude mcp add postgres-mcp -- npx -y @yawlabs/postgres-mcp

claude mcp add postgres-mcp -- npx -y @yawlabs/postgres-mcp@0.13.10

Format verified against the official Claude Code docs ↗.

.cursor/mcp.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp@0.13.10"
      ]
    }
  }
}

Format verified against the official Cursor docs ↗.

.vscode/mcp.json

{
  "servers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}

{
  "servers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp@0.13.10"
      ]
    }
  }
}

Format verified against the official VS Code docs ↗.

mcp_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp"
      ]
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@yawlabs/postgres-mcp@0.13.10"
      ]
    }
  }
}

Format verified against the official Windsurf docs ↗.

GitHub

⭐ 8 stars · 最近更新于 31 天前 · MIT license

About this server

@yawlabs/postgres mcp One click adds this to your local Yaw MCP config so it's available in every Yaw Terminal session. Or install manually below. Query a PostgreSQL database from Claude Code, Cursor, and any MCP client. Read only by default writes opt in via a single env var so an agent can't silen…

Summary from the project README — github.com/YawLabs/postgres-mcp

Distributed as npm, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

What does the PostgreSQL MCP Server MCP server do?

How do I install PostgreSQL MCP Server?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is PostgreSQL MCP Server free to use?

The MCP server itself is free to install. The source is public on https://github.com/YawLabs/postgres-mcp. Any third-party service it calls may require its own API key and account.

Which clients support PostgreSQL MCP Server?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/postgres-mcp.svg)](https://mcpnav.net/server/postgres-mcp/)

HTML

<a href="https://mcpnav.net/server/postgres-mcp/"><img src="https://mcpnav.net/badge/postgres-mcp.svg" alt="Listed on MCPNav" height="20"></a>