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
I've been working on a little side project that combines Duolingo-like listening comprehension exercises with real content .
Every video is transcribed to get much better transcripts than the cl
Article URL: https://nuejs.org/blog/large-scale-apps/
Comments URL: https://ne
Article URL: https://julian.digital/2025/03/27/the-case-against-conversational-interfaces/
Commen
Article URL: https://sgnt.ai/p/hell-out-of-llms/
Comments URL: https://news.ycombin
