Schema | postgres-mcp-server

postgres-mcp-server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`PGSSL`	No	SSL configuration mode (alias for PGSSLMODE)
`PGHOST`	No	Database host name	localhost
`PGPORT`	No	Database port number	5432
`PGUSER`	No	Database user name	postgres
`POOL_MAX`	No	Maximum active database connections in pool (alias for MAX_CONNECTIONS)	10
`PGSSLMODE`	No	SSL configuration mode (require, verify-full, etc.)
`ROW_LIMIT`	No	Maximum rows returned per query (alias for MAX_ROW_LIMIT)	1000
`PGDATABASE`	No	Database name	postgres
`PGPASSWORD`	No	Database password
`ALLOW_WRITE`	No	Enables write queries (1, true, yes)	false
`POSTGRES_DB`	No	Database name (alias for PGDATABASE)	postgres
`DATABASE_URL`	No	Full PostgreSQL connection URI (postgres://user:pass@host:port/db)
`MAX_ROW_LIMIT`	No	Maximum rows returned per query	1000
`POSTGRES_HOST`	No	Database host name (alias for PGHOST)	localhost
`POSTGRES_USER`	No	Database user name (alias for PGUSER)	postgres
`MAX_CONNECTIONS`	No	Maximum active database connections in pool	10
`QUERY_TIMEOUT_MS`	No	Per-query timeout in milliseconds	30000
`POSTGRES_PASSWORD`	No	Database password (alias for PGPASSWORD)

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
No tools

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

This server cannot be deployed

ActivityMaintained

ResponsivenessNo issues