Live data from Hacker News

Show HN: Cloud-Ready Postgres MCP Server

github.com

21–30 of 84 posts

Re: Show HN: Cloud-Ready Postgres MCP Server

#21
post #10

Earlier quoted context omitted.

There are hundreds of text-to-SQL companies and integrations already. What's different about this that makes you react like that?

Those companies will be dead once this goes mainstream. Why pay to a 3rd party company when you can ask LLM to create graphs and analysis of whatever you want. Pair it with scheduled tasks and I really don't see any value in those SaaS products.

there are a lot of nuances in Business Analytics, you maybe can get away with GenAI for naiive questions like "Who are my top5 customers?", but thats not the type of insight usually needed. Most companies already know their top5 customers by heart and these don't change a lot.

Nuanced BI analytics can have a lot of toggles and filters and drilldowns, like compare sales of product A in category B subcategory C, but only for stores in regions X,Y and that one city Z during time periods T1, T2. and out of these sales, look at sales of private brand vs national brand, and only retail customers, but exclude purchases via business credit card or invoiced.

with every feature in a DB (of which there could be thousands), the number of permutations and dimensions grows very quickly.

whats probably going to happen, is simple questions could be self-served by GenAI, but more advanced usage is still needed interention by specialist. So we would see some improvement in productivity, but people will not lose jobs. Perhaps number of jobs could even increase due to increased demand for analytics, as it often happens with increased efficiency/productivity (Jevon's paradox)

Re: Show HN: Cloud-Ready Postgres MCP Server

#22
post #10

Earlier quoted context omitted.

There are hundreds of text-to-SQL companies and integrations already. What's different about this that makes you react like that?

Those companies will be dead once this goes mainstream. Why pay to a 3rd party company when you can ask LLM to create graphs and analysis of whatever you want. Pair it with scheduled tasks and I really don't see any value in those SaaS products.

Those companies and integrations are already using LLMs. That's the whole point. I'm only talking about LLM products, many of which are free and open source. This has been mainstream for years.

Re: Show HN: Cloud-Ready Postgres MCP Server

#23
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…

and the next 10 after that, and the next 10 after that, and...

Re: Show HN: Cloud-Ready Postgres MCP Server

#24
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 connect and make read-only queries to the replica for the company data - they have a temporary read-write schema just for their current connection so they can have temporary tables and caches - temporary data is deleted when they close the session

How could you make a setup like that so that when using your MCP server, I'm not worried about the model / users modifying the data, but only doing their own private queries/tables?

Re: Show HN: Cloud-Ready Postgres MCP Server

#25
post #16

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 on Linux.

Good 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 no password (rookie mistake). Within 24 hours, the logs revealed someone attempting to make my Redis instance a slave to theirs! The IP traced back to Tencent, the Chinese tech giant... Really weird. Fortunately, there was nothing valuable stored in it.

Re: Show HN: Cloud-Ready Postgres MCP Server

#26
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!

So you will ask "What is our churn?", get a random result, and then turn your whole marketing strategy around wrong number?

Thats cute.

Re: Show HN: Cloud-Ready Postgres MCP Server

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

Re: Show HN: Cloud-Ready Postgres MCP Server

#28
post #2

I'm still trying to grok MCP, would be awesome if you could include usage examples in the doc. Good luck!

It's not complicated at all.

All it does is expose methods as a "tool" which is then brought back to your LLM and defined with its name, description and input parameters.

E.g. Name: "MySqlTool", Description: "Allows arbitrary MySQL queries to the XYZ database", Parameters: "string: sqlToExecute"

The MCP Client (e.g. Claude Desktop, Claude Code), is configured to talk to an MCP server via stdio or sse, and calls a method like "tools/list", the server just sends a list back (in JSON) of all the tools, names, descriptions, params.

Then, if the LLM gets a query that mentions e.g. do a web search, or a web scraping, etc, it just outputs a tool use token then stops inferencing. Then the code calls that tool via stdio/sse (json-rpc), to the MCP server, which just runs that method, returns the result, then its added to the message history in the LLM, then inferencing runs again from the beginning.

Re: Show HN: Cloud-Ready Postgres MCP Server

#29
post #17
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!

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/

Yes. Ask it to do it 10 times and pick the right answer

Re: Show HN: Cloud-Ready Postgres MCP Server

#30
post #16

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 on Linux.

Good 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 no password (rookie mistake). Within 24 hours, the logs revealed someone attempting to make my Redis instance a slave to theirs! The IP traced back to Tencent, the Chinese tech giant... Really weird. Fortunately, there was nothing valuable st…

> The IP traced back to Tencent, the Chinese tech giant... Really weird.

They're a large cloud provider in Asia like Amazon AWS or Microsoft Azure. I doubt such a tech company would make it that obvious when breaking the law.

Post reply on HN