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
Connectez-vous pour ajouter un commentaire
Autres messages de ce groupe

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


Article URL: https://github.com/koreader/koreader
Comments URL: https://news.ycomb
Article URL: https://libera.chat/news/burnout
Comments URL: https://news.ycombinator.c

Article URL: https://github.com/astronomer/airflow-ai-sdk
Comments URL: ht