Devjoy-digital/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 henry@mcphub.com.
The PostgreSQL MCP Server is a robust tool designed to integrate AI environments with PostgreSQL databases, offering advanced configuration management and database operations.
Tools
Functions exposed to the LLM to take actions
create_config_file
Creates a structured .db-config.json file with full metadata tracking.
configure_connection
Configures database connection for the session with built-in validation.
update_configuration
Updates specific configuration settings with validation.
test_connection
Tests database connection with current or provided settings.
get_connection_info
Gets detailed current database connection configuration and status.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client