PostgreSQL MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
analyze_database

Analyze PostgreSQL database configuration and performance

get_setup_instructions

Get step-by-step PostgreSQL setup instructions

debug_database

Debug common PostgreSQL issues