Schema | MCP Postgres Server

MCP Postgres Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

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
queryA	Execute SQL queries with pagination support and parameterization for security. Supports page sizes up to 500 rows.
describe_tableC	Get the structure of a database table
list_tablesC	List all tables in a schema
get_constraintsC	Get constraints for a table
list_schemasC	List all schemas in the database
list_indexesC	List indexes for a table or schema
explain_queryC	Get query execution plan (EXPLAIN)
get_table_statsC	Get table statistics and size information
list_viewsC	List views in a schema
list_functionsC	List functions and procedures in a schema

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/MadeByNando/mcp-postgres-server'

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