Show HN: Cloud-Ready Postgres MCP Server

pg-mcp is a cloud-ready Model Context Protocol server for PostgreSQL that enables LLMs and agents to inspect database schemas and execute queries over HTTP/SSE. It supports multi-tenant connections, schema introspection with documentation, read-only query execution, query optimization via EXPLAIN, and extensible YAML-based plugins for Postgres extensions like pgvector and postgis.

Key Points

• •pg-mcp is an MCP server enabling LLMs and AI agents to interact with PostgreSQL databases through structured APIs
• •Supports multi-tenant architecture with multiple concurrent database connections from different agents over HTTP/SSE protocol
• •Schema introspection tool returns comprehensive database metadata including tables, types, indexes, constraints, and catalog descriptions
• •Read-only query execution provides controlled database access for agents while maintaining security boundaries
• •EXPLAIN tool integration helps agents optimize SQL queries before execution by analyzing query plans
• •YAML-based plugin system extends functionality for Postgres extensions like pgvector (embeddings) and PostGIS (geospatial)
• •Cloud-ready containerized deployment with immediate HTTP/SSE endpoint availability at startup
• •Enriched schema documentation from pg_catalog enables better LLM understanding of database structure and relationships

Workflow Diagram

Concepts