chenz4027/postgres-mcp
3.1
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 henry@mcphub.com.
A Model Context Protocol (MCP) server that provides PostgreSQL database access to Claude Desktop.
Tools
Functions exposed to the LLM to take actions
postgres_query
Execute custom SQL queries
postgres_list_tables
List all tables in the database
postgres_describe_table
Get detailed table information
postgres_schema_overview
Get complete database schema
postgres_select
Select data with filtering and pagination
postgres_insert
Insert new records
postgres_update
Update existing records
postgres_delete
Delete records
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client