Schema | postgres-mcp

postgres-mcp

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
postgres_queryA	Execute a custom SQL query against the PostgreSQL database. Use this for complex queries, joins, aggregations, and any SQL operation not covered by other tools.
postgres_list_tablesA	List all tables in the public schema of the PostgreSQL database
postgres_describe_tableA	Get detailed information about a specific table including columns, data types, and constraints
postgres_schema_overviewA	Get a complete overview of the database schema including all tables and their columns
postgres_selectA	Select data from a table with optional filtering, sorting, and pagination
postgres_insertB	Insert a new record into a table
postgres_updateC	Update existing records in a table
postgres_deleteB	Delete records from a table

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

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