Skip to main content
Glama

PostgreSQL MCP Server

by jplwunder

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
LOG_LEVELNoLogging level (DEBUG, INFO, WARNING, ERROR)INFO
POSTGRES_HOSTYesPostgreSQL host addresslocalhost
POSTGRES_PORTYesPostgreSQL port number5432
POSTGRES_USERYesPostgreSQL user for authentication
POSTGRES_DATABASEYesPostgreSQL database name
POSTGRES_PASSWORDYesPostgreSQL password for authentication
QUERY_HISTORY_SIZENoNumber of queries to keep in history100
POSTGRES_POOL_MAX_SIZENoMaximum connection pool size10
POSTGRES_POOL_MIN_SIZENoMinimum connection pool size2
POSTGRES_COMMAND_TIMEOUTNoCommand timeout in seconds60
POSTGRES_CONNECTION_TIMEOUTNoConnection timeout in seconds10

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/jplwunder/postgres-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server