jplwunder/postgres-mcp-server
If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A Model Context Protocol (MCP) server providing read-only access to PostgreSQL databases.
Tools
Functions exposed to the LLM to take actions
query_database
Execute SELECT queries on the database with formatted output.
list_tables
List all tables in the database with metadata.
describe_table
Get detailed table structure including columns, types, indexes, and constraints.
list_schemas
List all schemas in the database.
get_table_indexes
Get all indexes for a specific table.
get_query_history
Retrieve recent query history with execution metadata.
get_database_stats
Get overall database statistics and metadata.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client