NukitaOkamu/mcp-server-postgresql
3.1
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.
This project provides an MCP server that connects to a PostgreSQL database, enabling interaction with LLMs like Claude via the MCP Python SDK.
Tools
Functions exposed to the LLM to take actions
all_table_names
Returns a comma-separated list of all table names.
filter_table_names
Filters table names by a search term.
schema_definitions
Returns detailed schema info (columns, primary/foreign keys) for specified tables.
execute_query
Executes read-only SQL queries and returns formatted results.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client