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

41–50 of 84 posts

Re: Show HN: Cloud-Ready Postgres MCP Server

#41

Post by runako »

bavell wrote: post #40
runako wrote: post #35

Earlier quoted context omitted.

I think people who have been building with LLMs have a different view on what is complicated vs not :-) It may be easy for you to configure, but you dropped some acronyms in there that I would have to look up. I have definitely not personally set up anything like this.

It's basically a simple rpc server, there's nothing complicated going on...

Then 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 realize that less complicated examples are often better for learning? Have we as a community forgotten this basic truism?

Since it’s not complicated, you should be able to write it up quickly, and parallel commmenters to mine suggest there is an audience for such documentation.

Thanks!

Re: Show HN: Cloud-Ready Postgres MCP Server

#42

Post by conradfr »

pclmulqdq wrote: post #38
otabdeveloper4 wrote: post #9

Earlier quoted context omitted.

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.)

A family friend maintains a SQL database of her knitting projects that she does as a hobby. The PHB can easily learn SQL if they want.

But he doesn't.

The project manager also won't learn behat and write tests.

Your client also won't use the CMS to update their website.

Re: Show HN: Cloud-Ready Postgres MCP Server

#44

Post by jillesvangurp »

Is there more to MCP than being a simple Remote Procedure Call framework that allows AI interactions to include function calls driven by the AI model? The various documentation pages are a bit hand wavy on what the protocol actually is. But it sounds to me that RPC describes all/most of it.

Re: Show HN: Cloud-Ready Postgres MCP Server

#45

Post by curious_cat_163 »

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…

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.

Re: Show HN: Cloud-Ready Postgres MCP Server

#46

Post by brulard »

runako wrote: post #34
saberience wrote: post #27

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 define something is an MCP tool. Basically, it's not rocket science. I also built MCP servers for Mysql, Twilio, Polars, etc.

From HN guidelines: > Please don't post shallow dismissals, especially of other people's work. A good critical comment teaches us something. We are hackers here. Building is good. Sharing is good. All this is true even if you personally know how to do what is being shared, and it is easy for you. I promise you there are people who encounter every sharing post here and do not think what is posted is easy.

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?

Re: Show HN: Cloud-Ready Postgres MCP Server

#47

Post by runako »

brulard wrote: post #46
runako wrote: post #34

Earlier quoted context omitted.

From HN guidelines: > Please don't post shallow dismissals, especially of other people's work. A good critical comment teaches us something. We are hackers here. Building is good. Sharing is good. All this is true even if you personally know how to do what is being shared, and it is easy for you. I promise you there are people who encounter every sharing post here and do not think what is posted is easy.

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 that there are at least some people who read this site who know less about the topics covered than you do, and so might find this interesting or useful?

When you post something, will it help you to improve if people post non-constructive negative feedback? Will dismissive comments like these make you more or less likely to show your work publicly?

Just food for thought…

Re: Show HN: Cloud-Ready Postgres MCP Server

#48

Post by pclmulqdq »

flappyeagle wrote: post #43
pclmulqdq wrote: post #36

Earlier quoted context omitted.

That only works if you assume the fail cases are uncorrected. Spoiler alert: they are not.

Ask 10 different models then

Same problem: The models are also correlated on what they can and can't solve.

To give you an extreme example, I can ask 1000000 different models for a counterexample to the 3n + 1 problem, and all will get it wrong.

Re: Show HN: Cloud-Ready Postgres MCP Server

#49

Post by spennant »

saberience wrote: post #27

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 define something is an MCP tool. Basically, it's not rocket science. I also built MCP servers for Mysql, Twilio, Polars, etc.

I built this to fill a specific need. It's not really made to talk to Claude Desktop (although it can). It's built to take multiple connections from agents who bring their own LLM (via API key or whatever) and provide context to the LLM model. Yes, it does import the standard Python MCP package, however it does quite a few non-standard things in order to achieve the multi-tenancy. I encourage you to look at the code.

Re: Show HN: Cloud-Ready Postgres MCP Server

#50

Post by spennant »

jillesvangurp wrote: post #44

Is there more to MCP than being a simple Remote Procedure Call framework that allows AI interactions to include function calls driven by the AI model? The various documentation pages are a bit hand wavy on what the protocol actually is. But it sounds to me that RPC describes all/most of it.

Indeed. Anything you do with MCP can be done in more traditional ways.
Post reply on HN