Show HN: Cloud-Ready Postgres MCP Server

Summary

PostgreSQL Model Context Protocol (PG-MCP) Server A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents. Overview PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture. This implementation builds upon and extends the reference Postgres MCP implementation with several key enhancements: Full Server Implementation: Built as a complete server with SSE transport for production use Multi-database Support: Connect to multiple PostgreSQL databases simultaneously Rich Catalog Information: Extracts and exposes table/column descriptions from the database catalog Extension Context: Provides detailed YAML-based knowledge about PostgreSQL extensions like PostGIS and pgvector Query Explanation: Includes a dedicated tool for analyzing query execution plans Robust Connection Management: Proper lifecycle for database connections with secure connection ID handling Features Connection Management Connect Tool : Register PostgreSQL connection strings and get a secure connection ID : Register PostgreSQL connection strings and get a secure connection ID Disconnect Tool : Explicitly close database connections when done : Explicitly close database connections when done Connection Pooling: Efficient connection management with pooling Query Tools pg_query : Execute read-only SQL queries using a connection ID : Execute read-only SQL queries using a connection ID pg_explain: Analyze query execution plans in JSON format Schema Discovery Resources List schemas with descriptions List tables with descriptions and row counts Get column details with data types and descriptions View table constraints and indexes Explore database extensions Data Access Resources Sample table data (with pagination) Get approximate row counts Extension Context Built-in contextual i...