pgEdge PostgreSQL MCP Server

Tools · 15

• query Execute a SQL query against the connected PostgreSQL database
• get_schema Retrieve the database schema including tables, columns, and relationships
• list_tables List all tables in the connected PostgreSQL database
• describe_table Describe the structure of a specific table including columns and data types
• natural_language_query Convert a natural language question into a SQL query and execute it
• get_foreign_keys Retrieve foreign key relationships for a specified table
• get_indexes List indexes for a specified table
• explain_query Provide an execution plan for a given SQL query
• get_table_statistics Retrieve table statistics such as row count and size
• list_views List all views in the connected PostgreSQL database
• get_view_definition Retrieve the SQL definition of a specified view
• list_functions List all functions in the connected PostgreSQL database
• get_function_definition Retrieve the definition of a specified function
• list_extensions List all installed PostgreSQL extensions
• get_database_info Retrieve general information about the connected database