← Directory

pgedge-postgres-mcp

The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients.

  • AI
  • Tools & Utilities
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. Supported Versions: PostgreSQL 14 and higher. If you on windows, you can generate random api token using powershell with command: $bytes = New-Object byte 32 ::Fill($bytes) ::ToHexString($bytes).ToLower() Then place it at "INIT_TOKENS". You will use the same value as the MCP bearer token in ChatGPT, Copilot and others. Verify after starting: http://Unraid_IP:8080/health

Platform availability

Available on 1 of 9 platforms

  • Unraid
  • TrueNAS (not listed)
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm (not listed)
  • Mac (not listed)
  • Windows (not listed)
  • Linux (not listed)

Health score

Not enough data yet for a health score. It needs at least 2 of 4 factors: maintenance, popularity, ease of install, resource needs.

Availability: platform listings confirmed today

No GitHub repository data collected yet.

Resources & Compatibility

Requirements not published yet.

Checked today - source: Docker Hub image tags and published docs

First-install notes

No first-install notes yet.

Alternatives

No alternatives collected yet.

Common questions

How do I generate and set the initial bearer token on Windows?

Use PowerShell to create 32 random bytes, convert the bytes to lowercase hexadecimal, set that value as INIT_TOKENS, and use the same value as the MCP bearer token.

How do I verify the service after startup?

After starting it, check the health endpoint on port 8080.

What common issues should I check if setup fails?

Check version requirements, port conflicts, database connectivity, Docker networking, and certificate validation.

How can I query Postgres with natural language?

The Natural Language Agent lets you send natural-language queries to the MCP Server to query Postgres.

Answers sourced from docs.pgedge.com, github.com, github.com

Community

No community discussions collected yet.