![[PEOPLE] Mélanie Thierry, mère épanouie et actrice transgressive](https://media.bvoltaire.fr/file/Bvoltaire/2025/04/whatsapp-image-2025-04-01-a-111720-5a7a8e54-616x346.jpg?#)
![[FIC 2025] ITrust, filiale d'Iliad spécialisée dans la cybersécurité, lance son XDR collaboratif](https://www.usine-digitale.fr/mediatheque/1/1/1/001525111_896x598_c.png)
/2025/04/01/chef-67eb962cac4b3461109913.jpg?#)
/2025/04/01/af7a6e8e4ddcabaf0ed936bb81b623f4-67eb9b91c8be5074424657.webp?#)
/2025/04/01/adolescence-uk-n-s1-e1-00-31-35-22-67eb18106bb8a059286841.jpg?#)
/2025/04/01/071-776-4384-67eb9c596611b867898314.jpg?#)
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 Comments URL: https://news.ycombinator.com/item?id=43520953 Points: 85 # Comments: 22
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: 85
# Comments: 22
