PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases, designed to facilitate AI agent interaction. It extends the reference Postgres MCP implementation with features like full server capabilities, multi-database support, detailed catalog information, extension context for tools like PostGIS and pgvector, query plan analysis, and robust connection management. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases, making it easier to integrate database insights into AI-driven applications.
Key Features
01Provides a complete server implementation with SSE transport.
02448 GitHub stars
03Enables query plan analysis for optimization.
04Offers rich catalog information, including table and column descriptions.
05Includes detailed YAML-based knowledge about PostgreSQL extensions.
06Supports connections to multiple PostgreSQL databases simultaneously.
