mukul975/postgres-mcp-server
3.3
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 henry@mcphub.com.
The PostgreSQL MCP Server is an AI-powered tool designed for automated management and monitoring of PostgreSQL databases, integrating seamlessly with AI assistants like Claude and ChatGPT.
Tools
Functions exposed to the LLM to take actions
list_tables
Lists all tables in the database.
describe_table
Provides detailed structure of a specified table.
execute_select_query
Executes a SELECT query safely.
get_cache_hit_ratios
Retrieves cache hit ratios for performance analysis.
create_user
Creates a new database user with specified privileges.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client