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
Accedi per aggiungere un commento
Altri post in questo gruppo
Article URL: https://popcorn.swmansion.com/
Comments URL: https://news.ycombinator.com/i
Article URL: https://seiya.me/blog/riscv-hypervisor
Comments URL: https://news.y
Article URL: https://sidsite.com/posts/life-transformer/
Comments URL: http
Article URL: https://v8.dev/features/explicit-resource-management
Article URL: https://github.com/prathyvsh/os-catalog
Comments URL: https://news
Article URL: https://phl.upr.edu/wow/outreach
Comments URL: https://news.ycombinator.c
