pgedge-postgres-mcp

pgedge-postgres-mcp

Docker app from andaks' Repository

Overview

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

Categories

AITools > Utilities

Related apps

Explore more like this

Explore all
AIUtilities apps

Links

Projectdocs.pgedge.comSupportforums.unraid.netGHCRghcr.ioTemplateraw.githubusercontent.com

Details

Repository
ghcr.io/pgedge/postgres-mcp:latest
Registry
https://ghcr.io/pgedge/postgres-mcp
Last Updated2026-10-12
First Seen2026-10-12

Runtime arguments

Network
bridge
Shell
sh
Privileged
false

Template configuration

MCP HTTP PortPorttcp
Target
8080
Value
8080
MCP DataPathrw
Target
/app/data
Value
/mnt/user/appdata/pgedge-postgres-mcp
HTTP EnabledVariable
Target
PGEDGE_HTTP_ENABLED
Value
true
HTTP AddressVariable
Target
PGEDGE_HTTP_ADDRESS
Value
:8080
AuthenticationVariable
Target
PGEDGE_AUTH_ENABLED
Value
true
API TokenVariable
Target
INIT_TOKENS
Value
791aaec185e51677165e850dcdb79fe77fb458ec1db06caf1420fdccbc376bb0
Database HostVariable
Target
PGEDGE_DB_HOST
Value
localhost
Database PortVariable
Target
PGEDGE_DB_PORT
Value
5432
Database NameVariable
Target
PGEDGE_DB_NAME
Value
dbname
Database UserVariable
Target
PGEDGE_DB_USER
Value
dbuser
Database PasswordVariable
Target
PGEDGE_DB_PASSWORD
Value
dbpass
Database SSL ModeVariable

disable for same-host internal network

Target
PGEDGE_DB_SSLMODE
Value
disable
Allow WritesVariable
Target
PGEDGE_DB_ALLOW_WRITES
Value
false
DebugVariable
Target
PGEDGE_DEBUG
Value
false
EmbeddingsVariable
Target
PGEDGE_EMBEDDING_ENABLED
Value
false
LLM ProxyVariable
Target
PGEDGE_LLM_ENABLED
Value
false
Knowledge BaseVariable
Target
PGEDGE_KB_ENABLED
Value
false