[dead]
Show HN: Cloud-Ready Postgres MCP Server
51–60 of 84 posts
Re: Show HN: Cloud-Ready Postgres MCP Server
#52Earlier quoted context omitted.
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.
[deleted]
Re: Show HN: Cloud-Ready Postgres MCP Server
#53Earlier quoted context omitted.
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.
No. What a bizarre example to choose. This is so easy to demonstrate. They will all come back with the exact same correct answer
Re: Show HN: Cloud-Ready Postgres MCP Server
#54This 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)Re: Show HN: Cloud-Ready Postgres MCP Server
#55Earlier quoted context omitted.
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.
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
Re: Show HN: Cloud-Ready Postgres MCP Server
#56Just 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.
What is multi-tenancy?
Re: Show HN: Cloud-Ready Postgres MCP Server
#57Just 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.
You do have to implement every functionality that you want to expose.
Re: Show HN: Cloud-Ready Postgres MCP Server
#58I 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.
Re: Show HN: Cloud-Ready Postgres MCP Server
#59I 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.
The use case for pg-mcp is server deployment - local running is just for dev purposes. HTTP/SSE enables multiple concurrent connections and network access, which stdio can't provide.
Re: Show HN: Cloud-Ready Postgres MCP Server
#60Earlier 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?
Just a fancy way of saying that multiple agents (with their own LLMs) can concurrently connect, also that pg-mcp can simultaneously connect to multiple Postgres servers as well.