{"slug":"pgedge/pgedge-postgres-mcp","name":"pgEdge PostgreSQL MCP Server","description":"100% Open Source Enterprise PostgreSQL MCP with natural language queries, hybrid search (pgvector+BM25)","category":"database","tags":[],"official":false,"stars":166,"transport":"stdio","install":null,"tools":[{"name":"query","description":"Execute a SQL query against the connected PostgreSQL database"},{"name":"get_schema","description":"Retrieve the database schema including tables, columns, and relationships"},{"name":"list_tables","description":"List all tables in the connected PostgreSQL database"},{"name":"describe_table","description":"Describe the structure of a specific table including columns and data types"},{"name":"natural_language_query","description":"Convert a natural language question into a SQL query and execute it"},{"name":"get_foreign_keys","description":"Retrieve foreign key relationships for a specified table"},{"name":"get_indexes","description":"List indexes for a specified table"},{"name":"explain_query","description":"Provide an execution plan for a given SQL query"},{"name":"get_table_statistics","description":"Retrieve table statistics such as row count and size"},{"name":"list_views","description":"List all views in the connected PostgreSQL database"},{"name":"get_view_definition","description":"Retrieve the SQL definition of a specified view"},{"name":"list_functions","description":"List all functions in the connected PostgreSQL database"},{"name":"get_function_definition","description":"Retrieve the definition of a specified function"},{"name":"list_extensions","description":"List all installed PostgreSQL extensions"},{"name":"get_database_info","description":"Retrieve general information about the connected database"}],"env_vars":[],"auth_type":"none","github":"https://github.com/pgEdge/pgedge-postgres-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}