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

61–70 of 84 posts

Re: Show HN: Cloud-Ready Postgres MCP Server

#61

Post by yroc92 »

koakuma-chan wrote: post #56
spennant wrote: post #49

Earlier quoted context omitted.

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.

What is multi-tenancy?

User isolation in a single data store. Basically, many customers sharing a single database securely without sharing their data.

Re: Show HN: Cloud-Ready Postgres MCP Server

#62

Post by dinfinity »

spennant wrote: post #31
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!

It won’t be that easy. First off, most databases in the wild are not well documented. LLMs benefit from context, and if your tables/columns have non-intuitive or non-descriptive names, the SQL may not even work. Second, you might benefit from an LLM fine-tuned on writing code and/or an intelligent Agent that checks for relevancy and ambiguity in user input prior to attempting to answer the question. It would also hel…

Then let the AI first complete the documentation by looking at the existing documentation, querying the DB (with pg-mcp), etc.

Do human reviewing and correcting of the updated documentation. Then ensure that the AI knows that the documentation might still contain errors and ask it to do the 'actual' work.

Re: Show HN: Cloud-Ready Postgres MCP Server

#63

Post by asdev »

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.

5% hackers, 95% FANG employees who think this is meaningless

Re: Show HN: Cloud-Ready Postgres MCP Server

#66

Post by doug_durham »

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.

The biggest contribution is the LLM compatible metadata that describes the tool and its argument. It is trivial to adopt. In python you can use FASTMcp to add a decorator to a function, and as long as that function returns a JSON string you are in business. The decorator extracts the arguments and doc strings and presents that to the LLM.

Re: Show HN: Cloud-Ready Postgres MCP Server

#67

Post by BoorishBears »

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

Re: Show HN: Cloud-Ready Postgres MCP Server

#68

Post by jillesvangurp »

doug_durham wrote: post #66
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.

The biggest contribution is the LLM compatible metadata that describes the tool and its argument. It is trivial to adopt. In python you can use FASTMcp to add a decorator to a function, and as long as that function returns a JSON string you are in business. The decorator extracts the arguments and doc strings and presents that to the LLM.

What makes a spec LLM compatible? I've thrown a lot of different things at gpt o1 and it generally understands them more better than I do. OpenAI specifications, unstructured text, log output, etc.

Re: Show HN: Cloud-Ready Postgres MCP Server

#69

Post by runako »

BoorishBears wrote: post #67
runako wrote: post #47

Earlier quoted context omitted.

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'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 discussions here than on other sites.

1 - https://news.ycombinator.com/item?id=9224

Re: Show HN: Cloud-Ready Postgres MCP Server

#70

Post by flappyeagle »

pclmulqdq wrote: post #55
flappyeagle wrote: post #53

Earlier quoted context omitted.

No. What a bizarre example to choose. This is so easy to demonstrate. They will all come back with the exact same correct answer

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
Post reply on HN