Schema | Postgres MCP Pro

Postgres MCP Pro

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MCP_API_KEY`	No	Optional API key for streamable HTTP authentication
`DATABASE_URI`	No	Postgres connection URI (legacy, alternative to individual POSTGRES_* variables). Example: postgresql://user:password@host:5432/dbname
`POSTGRES_HOST`	No	Postgres host
`POSTGRES_PORT`	No	Postgres port (default 5432)	5432
`OPENAI_API_KEY`	No	Optional OpenAI API key for experimental index tuning by LLM
`MCP_ALLOWED_HOSTS`	No	Comma-separated list of allowed hosts for DNS rebinding protection (streamable HTTP)
`POSTGRES_DATABASE`	No	Postgres database name
`POSTGRES_PASSWORD`	No	Postgres password
`POSTGRES_SSL_MODE`	No	Postgres SSL mode (e.g., disable, require, verify-full). Default is disable.	disable
`POSTGRES_USERNAME`	No	Postgres username
`MCP_ALLOWED_ORIGINS`	No	Comma-separated list of allowed origins for DNS rebinding protection (streamable HTTP)
`MCP_DISABLE_DNS_REBINDING`	No	Set to 'true' to disable DNS rebinding protection (not recommended for production)	false

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_schemasA	List all schemas in the database
list_objectsC	List objects in a schema
get_object_detailsB	Show detailed information about a database object
explain_queryA	Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed cost estimates.
analyze_workload_indexesB	Analyze frequently executed queries in the database and recommend optimal indexes
analyze_query_indexesA	Analyze a list of (up to 10) SQL queries and recommend optimal indexes
analyze_db_healthA	Analyzes database health. Here are the available health checks: index - checks for invalid, duplicate, and bloated indexes connection - checks the number of connection and their utilization vacuum - checks vacuum health for transaction id wraparound sequence - checks sequences at risk of exceeding their maximum value replication - checks replication health including lag and slots buffer - checks for buffer cache hit rates for indexes and tables constraint - checks for invalid constraints all - runs all checks You can optionally specify a single health check or a comma-separated list of health checks. The default is 'all' checks.
get_top_queriesA	Reports the slowest or most resource-intensive queries using data from the 'pg_stat_statements' extension.
execute_sqlB	Execute any SQL query

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/dblinick/postgres-mcp-pro-streamable'

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