pg-mcp
Data
database mcp server
SHOW HN2025
How HN took it
5 positive, 14 neutral or asking, 0 mixed, 14 critical, out of 33 comments about the project. Thread score -0.25.
Idea: 4 for, 6 againstExecution: 1 for, 2 againstPrivacy: 0 for, 2 againstDesign: 0 for, 2 againstPerformance: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for connecting agents to databases, with extension plugin system praised
From 1 comment
This is great, I like in particular that there are extensions plugins. I’ll be looking at integrating this in the Xata Agent (https://github.com/xataio/agent) as custom tooling.
tudorg on HN
Objections
Exposing port 8000 by default in docker-compose exposes the server to the internet without authentication
From 2 comments
From docker-compose ``` ports: - "8000:8000" ``` This will cause Docker to expose this to the internet and even helpfully configure an allow rule to the host firewall, at least…
fulafel on HNGood catch. OP, exposing your application without authentication is a serious security risk! Quick anecdote: Last week, I ran a Redis container on a VPS with an exposed port and…
rubslopes on HN
Text-to-SQL accuracy and reliability concerns for business use
From 2 comments
There are LLM SQL benchmarks. [1] And state of the art solution is still only at 77% accuracy. Would you trust that? [1] https://bird-bench.github.io/
moltar on HNYep gonna be easy Q: show me the top 5 customers by total sales A: System.Data.Odbc.OdbcException (0x80131937): ERROR [57014] ERROR: canceling statement due to statement timeout;…
clusterfook on HN
Unpaginated query results could overflow LLM context
From 1 comment
Where's the pagination? How does a large query here not blow up my context: https://github.com/stuzero/pg-mcp/blob/main/server/tools/query.py#L8
scottpersinger on HN
Shallow project; MCP servers are trivial to build
From 2 comments
Just for everyone here, the code for "building an MCP server", is importing the standard MCP package for Typescript, Python, etc, then writing as little as 10 lines of code to…
saberience on HNSaying you "built an MCP server" is literally the same as saying you wrote a method though. Like you can write a single 20 line method to connect to a MySQL database, add the MCP…
saberience on HN
Requests
Usage examples and documentation for people new to MCP
From 3 comments
I'm still trying to grok MCP, would be awesome if you could include usage examples in the doc. Good luck!
runako on HN+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…
mparis on HNThen please write up and share here some example usage documentation for someone who has never used MCP. (That was my suggestion upthread.) As a side note, do people here not…
runako on HN
Read-only temporary schema sessions for safe exploration
From 1 comment
Nice! What I'd be looking for is a MCP server where I can run in "biz/R&D exploration-mode", eg: - assume I'm working on a replica (shared about all R&D engineers) - they can…
oulipo on HN
Pagination for large query results
From 1 comment
Where's the pagination? How does a large query here not blow up my context: https://github.com/stuzero/pg-mcp/blob/main/server/tools/query.py#L8
scottpersinger on HN
Questions
Why HTTP/SSE instead of stdio for a locally running server
From 1 comment
I don’t understand the advantage of having the transport protocol be HTTP/SSE rather than studio especially in this case when it’s literally running locally.
ahamilton454 on HN
What multi-tenancy means here
From 1 comment
What is multi-tenancy?
koakuma-chan on HN
Alternatives named
Existing BI tools such as Tableau and PowerBI
From 2 comments
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…
otabdeveloper4 on HNdidn't Tableau (and some other BI solutions) have this feature out of the box?
slt2021 on HN
Existing text-to-SQL companies and integrations
From 1 comment
There are hundreds of text-to-SQL companies and integrations already. What's different about this that makes you react like that?
Kiro on HN
WhatsApp MCP server by lharries
From 1 comment
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.
jamestimmins on HN