![Bilan 2024 : Les nouveautés Agorapulse pour booster votre stratégie sociale [Infographie]](https://www.agorapulse.com/fr/blog/wp-content/uploads/sites/3/2025/03/FR-New-Favorite-Agorapulse-Features-of-2024-Blogpost-Header-scaled.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: 21 # Comments: 2
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: 21
# Comments: 2
