Skip to main content
Glama

PostgreSQL MCP Server

by compilotbv

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
POSTGRES_DBYesDatabase name
POSTGRES_HOSTNoDatabase hostlocalhost
POSTGRES_PORTNoDatabase port5432
POSTGRES_USERYesDatabase user
QUERY_TIMEOUTNoQuery timeout in seconds30
POSTGRES_SSLMODENoSSL modeprefer
POSTGRES_PASSWORDYesDatabase password
POSTGRES_POOL_MAXNoMaximum connections in the pool10
POSTGRES_POOL_MINNoMinimum connections in the pool1
POSTGRES_READONLYNoRead-only modefalse

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

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/compilotbv/mcpg'

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