Postgres MCP Server

Tools · 10

• query Execute SQL queries with pagination support
• describe_table Get table structure and column details
• list_tables List all tables in a schema
• list_schemas List all schemas in the database
• get_constraints Get table constraints (PK, FK, etc.)
• list_indexes List indexes for a table or schema
• list_views List views in a schema
• list_functions List functions and procedures
• explain_query Get query execution plan
• get_table_stats Get table size and statistics