pg_mcp_server
If you are the rightful owner of pg_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.
PG_MCP_SERVER is a custom implementation for PostgreSQL with PostGIS support, utilizing the go-mcp library for MCP functionality.
PG_MCP_SERVER is a general-purpose PostgreSQL MCP Server designed to efficiently manage context when deploying LLMs locally. It uses the go-mcp library to support Stdio and SSE transports, and it provides a pre-processing approach to fetch and describe database schema information to LLMs. The server supports PostGIS and PgVector extensions, and it requires careful role definition to prevent SQL injection and ensure data isolation. The server can be run using Docker or directly with Go, and it includes features for managing database connections and permissions.
Features
- Efficient context management for LLMs by pre-processing database schema information.
- Supports Stdio and SSE transports using the go-mcp library.
- Fetches and describes table structures, columns, constraints, and more to provide context to LLMs.
- Supports PostGIS and PgVector extensions for enhanced geospatial and vector operations.
- Role-based access control to prevent SQL injection and ensure data isolation.
