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

71–80 of 84 posts

Re: Show HN: Cloud-Ready Postgres MCP Server

#71

Post by pclmulqdq »

flappyeagle wrote: post #70
pclmulqdq wrote: post #55

Earlier quoted context omitted.

If it's so easy, go do it. You can publish the result in any math journal you like with just a title and a number, because this is one of the hardest problems in mathematics. For reference: https://en.wikipedia.org/wiki/Collatz_conjecture

My guy, every LLM has read Wikipedia

I don't know if you're purposely being dense. The first sentence of Wikipedia is that this is a famous unsolved problem.

So no, sampling 1000000 LLMs will not get you a solution to it. I guarantee you that.

Re: Show HN: Cloud-Ready Postgres MCP Server

#72

Post by a-dub »

sshine wrote: post #37
a-dub wrote: post #13

Earlier quoted context omitted.

is that true? i'd like that, but i get the sense that this mcp stuff is more oriented around programming assistant and agent applications. i suppose the desktop app can use it, but how good is it for this general purpose "chat with the database for lightweight analytics" use cases is it worth the trouble of dealing with some electron app to make it work?

> i get the sense that this mcp stuff is more oriented around programming assistant and agent applications Agents will become ubiquitous parts of the user interface that is currently the chat. So if you bother with a website or an electron app now, MCP will just add more capabilities to what you can control using agents.

yeah, i understand the premise. my question revolves around how well it actually works today for bi style applications. specifically, how close is it to being something that you can just drop in as a smart query and plotting interface rather than a bi stack that is built around something like tableau.

when i've read through documentation for mcp servers, it seems like the use cases they've mostly been focused on are improving effectiveness of programming assistants by letting them look at databases associated with codebases they're looking to modify.

i understand that these things are meant to be generic in nature, but you never really know if something is fit for purpose until it's been used for that purpose. (at least until agi, i suppose)

Re: Show HN: Cloud-Ready Postgres MCP Server

#73

Post by flappyeagle »

pclmulqdq wrote: post #71
flappyeagle wrote: post #70

Earlier quoted context omitted.

My guy, every LLM has read Wikipedia

I don't know if you're purposely being dense. The first sentence of Wikipedia is that this is a famous unsolved problem. So no, sampling 1000000 LLMs will not get you a solution to it. I guarantee you that.

It will get you the correct answer, not a solution. Once again it’s a terrible example, I don’t know why you used it. It’s certainly not a gotcha

Re: Show HN: Cloud-Ready Postgres MCP Server

#75

Post by pclmulqdq »

flappyeagle wrote: post #73
pclmulqdq wrote: post #71

Earlier quoted context omitted.

I don't know if you're purposely being dense. The first sentence of Wikipedia is that this is a famous unsolved problem. So no, sampling 1000000 LLMs will not get you a solution to it. I guarantee you that.

It will get you the correct answer, not a solution. Once again it’s a terrible example, I don’t know why you used it. It’s certainly not a gotcha

The reason I used it is that the correct answer to the actual problem is unknown and nobody has any idea how to solve it. No amount of sampling an LLM will give you a correct answer. It will give you the best known answer today, but it won't give you a correct answer. This is an example where LLMs all give correlated answers that do not solve the problem.

If you want to scale back, many programming problems are going to be like this, too. Failure points of different models are correlated as much as failure points during sampling are correlated. You only gain information from repeated trials when those trials are uncorrelated, and sampling multiple LLMs is still correlated.

Re: Show HN: Cloud-Ready Postgres MCP Server

#76

Post by brulard »

runako wrote: post #47
brulard wrote: post #46

Earlier quoted context omitted.

I think we exactly need to hear things like that. This is what I was wondering. Why is every MCP project such a big news? Isn't it just a few lines of code?

Is this really “big news” or is it a GitHub link titled “Show HN”? Is there a glitzy corporate PR page trying to sell something, or is this just code for people to read? Did Ars Technica breathlessly cover it, or did a random hacker post and share something they worked on? If it’s the work of a random hacker not promoted by media outlets, who benefits from negative comments about that person’s work? Is it possible th…

I didn't find the original comment negative. Saying it's not that hard to try to build an MCP server yourself is actually very helpful and constructive. That's how I read it. Nothing that would discourage me from submitting a "Show HN" in the future.

Re: Show HN: Cloud-Ready Postgres MCP Server

#77

Post by brulard »

clusterfook wrote: post #19
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!

Yep 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; Q: Why do I get this error A: Looks like it needs an index, let me create that for you. Done. Rerunnign query. could not close temporary statistics file "pg_stat_tmp/global.tmp": No space left on device Q: Why this error A: 429 Too Many Requ…

I have to say I had a very good results creating and optimizing quite complex queries with Sonnet. But letting LLM run them on their own in production is quite a different beast.

Re: Show HN: Cloud-Ready Postgres MCP Server

#78

Post by tudorg »

spennant wrote: post #54
tudorg wrote: post #18

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.

Xata.io looks very interesting!!! I was thinking about building an intelligent agent for pg-mcp as my net project but it looks like you did a lot of the hard work already. When thinking about the "AI Stack" I usually separate concerns like this: UI Agent(s) MCP Server(s) Tools/Resources | LLM(s)

That's very similar to what we are thinking as well, and we'd like to separate the Agent tools into an MCP server as well as use MCP for custom tools.

Re: Show HN: Cloud-Ready Postgres MCP Server

#79

Post by saberience »

runako wrote: post #69
BoorishBears wrote: post #67

Earlier quoted context omitted.

I'm not so sure why you're writing so much against a reasonable clarification that was made. MCP is getting trendy, but a lot of people being drawn in can't find the actual meat of what it is outside of self-referential definitions. Someone pointing out the reason for the flood of MCP servers being how trivial they are to implement is a helpful data point. Simple as that.

> MCP is getting trendy, but a lot of people being drawn in can't find the actual meat of what it is outside of self-referential definitions. My comment was against the shallow dismissal. Do you think that the negative comments helped anyone locate the meat of what it is? Did they clarify or educate? Even the infamous Dropbox comment[1] was more constructive. I gently push back in the hope that we can have better dis…

Saying 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 tool decorator to the method and boom you "built an MCP server".

But no one is posting up to HN saying "Look guys, I wrote a method which connects to a MySQL server", because it takes almost zero expertise and is not novel at all.

Re: Show HN: Cloud-Ready Postgres MCP Server

#80

Post by clusterfook »

curious_cat_163 wrote: post #45
clusterfook wrote: post #19

Earlier quoted context omitted.

Yep 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; Q: Why do I get this error A: Looks like it needs an index, let me create that for you. Done. Rerunnign query. could not close temporary statistics file "pg_stat_tmp/global.tmp": No space left on device Q: Why this error A: 429 Too Many Requ…

That’s a good example of a worst case scenario. This is why we would still need humans loitering about. The question is do they still need 10? Or 2 would suffice? How about 5? This does not need to be a debate about the absolutes.

You will need 2. BUT, and here is the rub. https://en.wikipedia.org/wiki/Jevons_paradox

I am hoping Jevon will keep employing me. He has been a great boss for the last 25 years TBH.

Post reply on HN