Skip to content
appsgit

Postgres MCP

Postgres MCP is an MCP server that enables SQL queries against PostgreSQL databases through MCP-compatible clients. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries. It has 233 GitHub stars, is released under the PostgreSQL license and runs locally with docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest.

github.com/pgEdge/pgedge-postgres-mcp (opens in a new tab)

  • Official
  • Databases
  • PostgreSQL
  • Actively maintained

Install Postgres MCP

Generated from the server's MCP registry entry. Replace your-value with your own values.

Claude Desktop

claude_desktop_config.json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/pgedge/postgres-mcp:latest"
      ]
    }
  }
}

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

Claude Code

claude mcp add --transport stdio postgres-mcp -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest

Cursor

.cursor/mcp.json
{
  "mcpServers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/pgedge/postgres-mcp:latest"
      ]
    }
  }
}

Project file; use ~/.cursor/mcp.json to enable it in every project.

VS Code

.vscode/mcp.json
{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/pgedge/postgres-mcp:latest"
      ]
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

About Postgres MCP

The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries.

  • ai
  • llm
  • mcp
  • postgres
  • postgresql
  • server

FAQ

Postgres MCP FAQ

Still curious? Email info@appsgit.com.

What is Postgres MCP?

Postgres MCP is an MCP server that enables SQL queries against PostgreSQL databases through MCP-compatible clients. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries. It has 233 GitHub stars, is released under the PostgreSQL license and runs locally with docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest. The source code is at github.com/pgEdge/pgedge-postgres-mcp.

How do I install the Postgres MCP MCP server?

Add the command docker run -i --rm ghcr.io/pgedge/postgres-mcp:latest to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.

Is Postgres MCP free?

The server is open source under the PostgreSQL license, so running it is free. It does not declare any required API key.

Is Postgres MCP actively maintained?

The most recent commit was on Sep 28, 2026. The latest release is v1.1.0, published Sep 4, 2026. appsgit only lists MCP servers with a commit in the last six months and re-checks every server daily.