PostgreSQL MCP Server

by hthuong09
Verified

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
POSTGRES_DBNoDatabase name
POSTGRES_SSLNoEnable SSL mode (set to 'true' to enable)
POSTGRES_URLNoFull database URL (e.g., postgres://user:pass@host:5432/dbname)
POSTGRES_HOSTNoDatabase host
POSTGRES_PORTNoDatabase port5432
POSTGRES_USERNoDatabase user
POSTGRES_PASSWORDNoDatabase password

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

ID: c92j003vx0