Show HN: Cloud-Ready Postgres MCP Server https://ift.tt/SGD80nK

Show HN: Cloud-Ready Postgres MCP Server Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension Plugins: YAML-based plugin system for Postgres extensions (supports pgvector and postgis out of the box). - Server Mode: Spin up the container and it's ready to accept connections at http://localhost:8000/sse https://ift.tt/z83OMNm March 30, 2025 at 12:14AM