Query and manage PostgreSQL databases with schema exploration, SQL execution, and query analysis

PostgreSQL guMCP Server

list_schemas

Array of schema objects with schema_name, schema_owner, and schema_type (System Schema, System Information Schema, or User Schema)

List tables, views, sequences, or extensions in a schema

list_objects

Array of database objects in the specified schema, each with schema, name, and type fields

Get detailed information about a table, view, sequence, or extension

get_object_details

Single object with detailed information including basic metadata, columns (with data types and constraints), table constraints, and indexes

execute_sql

Single object containing query execution results with an array of row objects (each row as key-value pairs), total row count, and execution status

Show query execution plan with costs and strategy

explain_query

Single object containing query execution plan showing node types (Seq Scan, Index Scan, Nested Loop, etc.), startup and total costs, row estimates, join strategies, and filter conditions

PostgreSQL

Tools

List Schemas

List Objects

Get Object Details

Execute Sql

Explain Query

Installation Steps

Create a Gumloop Account

Copy Your Server URL