MCP Servers / database / pgEdge PostgreSQL MCP Server

pgEdge PostgreSQL MCP Server

stdionone★ 166database

100% Open Source Enterprise PostgreSQL MCP with natural language queries, hybrid search (pgvector+BM25)

Install

How to run this server

No install command recorded.

server path: pgedge-postgresql-mcp-server

Tools

What this server exposes

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

Configuration

Environment & auth

authnone

Resources