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…
In plain words
Cloud-Ready Postgres MCP Server is a Model Context Protocol server that enables large language models and agents to inspect PostgreSQL database schemas and execute read-only queries. It supports multiple concurrent database connections and runs over HTTP/SSE, offering tools like schema introspection with catalog descriptions, query execution with controls, EXPLAIN query optimization, and a YAML-based plugin system for Postgres extensions including pgvector and postgis. It is designed for developers building LLM-powered applications that need structured database access.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
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
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, March 2025
the whole month →
Mimic Human Research & Save Findings in AI Knowledge Base
AI · 2025 · sider.ai
