Skip to main content

Postgres MCP

Verified

MIT License

67

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DATABASE_URI`	Yes	The PostgreSQL database connection URI

Schema

Prompts

Interactive templates invoked by user choice

Name	Description
No prompts

Resources

Contextual data attached and managed by the client

Name	Description
No resources

Tools

Functions exposed to the LLM to take actions

Name	Description
list_schemas	List all schemas in the database
list_objects	List objects in a schema
get_object_details	Show detailed information about a database object
explain_query	Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed cost estimates.
analyze_workload_indexes	Analyze frequently executed queries in the database and recommend optimal indexes
analyze_query_indexes	Analyze a list of (up to 10) SQL queries and recommend optimal indexes
analyze_db_health	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_queries	Reports the slowest SQL queries based on execution time, using data from the 'pg_stat_statements' extension.
execute_sql	Execute any SQL query

ID: ecl7vgkzit