Skip to main content
Glama
derricksiawor

PostgreSQL MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PG_HOSTNoPostgreSQL server hostnamelocalhost
PG_PORTNoPostgreSQL server port5432
PG_USERNoDatabase usernamepostgres
PG_SCHEMANoDefault schemapublic
MAX_RESULTSNoMaximum rows returned1000
PG_DATABASEYesTarget database name
PG_PASSWORDYesDatabase password
PG_SSL_MODENoSSL connection mode (disable, require, verify-ca, verify-full)
QUERY_TIMEOUTNoQuery timeout in milliseconds30000
PG_SSL_CA_PATHNoPath to CA certificate
PG_SSL_KEY_PATHNoPath to client key
CONNECTION_LIMITNoMaximum pool connections10
PG_SSL_CERT_PATHNoPath to client certificate
PG_SSL_MIN_VERSIONNoMinimum TLS version (TLSv1.2, TLSv1.3)
RATE_LIMIT_PER_HOURNoQueries per hour1000
RATE_LIMIT_CONCURRENTNoConcurrent queries10
RATE_LIMIT_PER_MINUTENoQueries per minute60
ALLOW_WRITE_OPERATIONSNoEnable INSERT/UPDATE/DELETE operationsfalse
PG_SSL_REJECT_UNAUTHORIZEDNoReject self-signed certs (true, false)

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/derricksiawor/mav-postgresql-mcp-server'

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