yty-build/postgres_mcp_allaccess
3.2
If you are the rightful owner of postgres_mcp_allaccess 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.
PostgreSQL MCP AllAccess is a production-ready server solution that integrates global connection pooling, PgBouncer, and automatic password rotation for AWS RDS.
Tools
Functions exposed to the LLM to take actions
list_tables
List tables in a schema
execute_query
Run any SQL query
describe_table
See table structure
execute_file
Run SQL from a file
list_schemas
List all schemas
search_tables
Find tables by name pattern
get_database_context
Overview of database structure
explain_query
Get query execution plan
analyze_query
Performance analysis
suggest_indexes
Index recommendations
get_session_info
Current session status
get_query_history
View query history
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client