dbbaskette/gp-mcp-server
If you are the rightful owner of gp-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 Greenplum MCP Server is a Spring Boot application designed to provide secure and efficient query tools for Greenplum and PostgreSQL databases using the Model Context Protocol (MCP).
Tools
Functions exposed to the LLM to take actions
gp.listSchemas
List database schemas with tables/columns, supporting pagination and filtering.
gp.previewQuery
Validate queries without execution, offering plan estimation and validation.
gp.runQuery
Execute parameterized SELECT queries with streaming, limits, and redaction.
gp.explain
Get detailed query execution plans in JSON format with ANALYZE support.
gp.openCursor
Open server-side cursors for handling large result sets.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client