dharmit01/postgres-mcp
If you are the rightful owner of postgres-mcp 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.
The PostgreSQL MCP Server is a Model Context Protocol server that provides tools for exploring PostgreSQL schemas and executing queries over STDIO and an experimental SSE HTTP interface.
Tools
Functions exposed to the LLM to take actions
health_check
Quick connectivity check
get_schema
Full columns listing excluding system schemas
list_tables
List user tables
describe_table
Describe a specific table ("schema.table")
select
Safe SELECT-only query execution
execute
INSERT/UPDATE/DELETE/DDL (non-SELECT) returning rowCount
run_query
Unrestricted SQL (use with caution)
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client