Schema | postgresdb-mcp

postgresdb-mcp

Overview Schema Related Servers Score Discussions

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`POSTGRES_STG_SSL`	No	Enable SSL for the staging environment (true/false)	false
`POSTGRES_PROD_SSL`	No	Enable SSL for the production environment (true/false)	false
`POSTGRES_STG_HOST`	No	PostgreSQL host for the staging environment
`POSTGRES_STG_PORT`	No	PostgreSQL port for the staging environment (default 5432)	5432
`POSTGRES_STG_USER`	No	Database user for the staging environment
`POSTGRES_LOCAL_SSL`	No	Enable SSL for the local environment (true/false)	false
`POSTGRES_PROD_HOST`	No	PostgreSQL host for the production environment
`POSTGRES_PROD_PORT`	No	PostgreSQL port for the production environment (default 5432)	5432
`POSTGRES_PROD_USER`	No	Database user for the production environment
`POSTGRES_LOCAL_HOST`	No	PostgreSQL host for the local environment
`POSTGRES_LOCAL_PORT`	No	PostgreSQL port for the local environment (default 5432)	5432
`POSTGRES_LOCAL_USER`	No	Database user for the local environment
`POSTGRES_STG_SCHEMA`	No	Comma-separated schema allowlist for the staging environment
`POSTGRES_PROD_SCHEMA`	No	Comma-separated schema allowlist for the production environment
`POSTGRES_LOCAL_SCHEMA`	No	Comma-separated schema allowlist for the local environment
`POSTGRES_STG_DATABASE`	No	Database name for the staging environment
`POSTGRES_STG_PASSWORD`	No	Database password for the staging environment
`POSTGRES_PROD_DATABASE`	No	Database name for the production environment
`POSTGRES_PROD_PASSWORD`	No	Database password for the production environment
`POSTGRES_LOCAL_DATABASE`	No	Database name for the local environment
`POSTGRES_LOCAL_PASSWORD`	No	Database password for the local environment
`POSTGRES_STG_ALLOW_WRITES`	No	Allow write operations for the staging environment (true/false)	false
`POSTGRES_PROD_ALLOW_WRITES`	No	Allow write operations for the production environment (true/false)	false
`POSTGRES_LOCAL_ALLOW_WRITES`	No	Allow write operations for the local environment (true/false)	false
`POSTGRES_STG_SSL_REJECT_UNAUTHORIZED`	No	Verify SSL certificate for the staging environment (true/false)	true
`POSTGRES_PROD_SSL_REJECT_UNAUTHORIZED`	No	Verify SSL certificate for the production environment (true/false)	true
`POSTGRES_LOCAL_SSL_REJECT_UNAUTHORIZED`	No	Verify SSL certificate for the local environment (true/false)	true

Instructions

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.

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

Name	Description
No tools

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Server Configuration
Instructions
Capabilities
Tools
Prompts
Resources

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

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/nayzo/postgresdb-mcp'

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