compilotbv/mcpg
3.2
If you are the rightful owner of mcpg and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
The PostgreSQL MCP Server is a Model Context Protocol server designed for PostgreSQL databases, providing remote deployment capabilities through HTTP/SSE transport. It is built using Python, FastAPI, and Docker, making it suitable for deployment on Elestio or any cloud platform.
Tools
Functions exposed to the LLM to take actions
execute_query
Run SELECT queries
execute_explain
Get query execution plans
list_databases
List all databases
list_tables
List tables in schema
list_columns
Show column information
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client