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
Comments URL: https://news.ycombinator.com/item?id=43520953
Points: 11
# Comments: 2
Login to add comment
Other posts in this group
Article URL: https://mcr21.org.uk/
Comments URL: https://news.ycombinator.com/item?id=43758999
Article URL: https://interfacinglinux.com/2025/04/18/magewell-eco-m-2-hdmi-capture-card/
Comments U

Article URL: https://arxiv.org/abs/2504.05001
Comments URL: https://news.ycombinator.c

Article URL: https://mcyoung.xyz/2025/04/21/go-arenas/
Comments URL: https://