tmustafiz/mcp-server-postgresql
If you are the rightful owner of mcp-server-postgresql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The MCP PostgreSQL Server is a production-grade, extensible server designed to facilitate Model Context Protocol (MCP) operations with PostgreSQL databases, particularly for LLM coding agents in various IDEs.
Tools
Functions exposed to the LLM to take actions
list_tables
List all tables in a schema
list_columns
List all columns for a table (with comments)
find_related_tables
Show direct FK relationships for a table
describe_relationship
Describe the relationship between two tables
generate_erd_mermaid
Generate a Mermaid ERD diagram for a schema
generate_erd_json
Generate a JSON graph of schema structure
fuzzy_column_match
Fuzzy match a column by natural language phrase
sample_column_data
Return sample data from a column
run_query
Execute SELECT queries with safety measures
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client