Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Cloud-Ready Postgres MCP Server

github.com

Post reply on HN
Print view View original

1–10 of 84 posts

Show HN: Cloud-Ready Postgres MCP Server

#1

Post by spennant »

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

Show HN: Cloud-Ready Postgres MCP Server
github.com

Re: Show HN: Cloud-Ready Postgres MCP Server

#3

Post by mparis »

runako wrote: post #2

I'm still trying to grok MCP, would be awesome if you could include usage examples in the doc. Good luck!

+1

My first foray into using MCP was via Claude Desktop. Would be great if you packaged your tool such that one could add it with a few lines in their ‘~/Library/Application Support/Claude/claude_desktop_config.json’

Re: Show HN: Cloud-Ready Postgres MCP Server

#4

Post by 1zael »

This is wild. Our company has like 10 data scientists writing SQL queries on our DB for business questions. I can deploy pg-mcp for my organization so everyone can use Claude to answer whatever is on their mind? (e.x."show me the top 5 customers by total sales")

sidenote: I'm scared of what's going to happen to those roles!

Re: Show HN: Cloud-Ready Postgres MCP Server

#5

Post by jamestimmins »

mparis wrote: post #3
runako wrote: post #2

I'm still trying to grok MCP, would be awesome if you could include usage examples in the doc. Good luck!

+1 My first foray into using MCP was via Claude Desktop. Would be great if you packaged your tool such that one could add it with a few lines in their ‘~/Library/Application Support/Claude/claude_desktop_config.json’

Same here. Tonight I added Whatsapp to Claude Desktop via Luke Harries' https://github.com/lharries/whatsapp-mcp. Very solid intro into how it all works.

Re: Show HN: Cloud-Ready Postgres MCP Server

#9

Post by otabdeveloper4 »

1zael wrote: post #4

This is wild. Our company has like 10 data scientists writing SQL queries on our DB for business questions. I can deploy pg-mcp for my organization so everyone can use Claude to answer whatever is on their mind? (e.x."show me the top 5 customers by total sales") sidenote: I'm scared of what's going to happen to those roles!

Probably nothing. "Expose the database to the pointy-haired boss directly, as a service" is an idea as old a computing itself. Even SQL itself was originally an iteration of that idea. Every BI system (including PowerBI and Tableau) were supposed to be that.

It doesn't work because the PHB doesn't have the domain knowledge and doesn't know which questions to ask. (No, it's never as simple as group-by and top-5.)

Re: Show HN: Cloud-Ready Postgres MCP Server

#10

Post by Kiro »

1zael wrote: post #4

This is wild. Our company has like 10 data scientists writing SQL queries on our DB for business questions. I can deploy pg-mcp for my organization so everyone can use Claude to answer whatever is on their mind? (e.x."show me the top 5 customers by total sales") sidenote: I'm scared of what's going to happen to those roles!

There are hundreds of text-to-SQL companies and integrations already. What's different about this that makes you react like that?
Post reply on HN