Odd seeing this right now for me. I recently implemented a 6NF schema for parsed XBRL files from EDGAR. The architecture was the right call... too bad the data is not useful for analytics.
Readit Newsspennant commented on 6NF File Format habr.com/en/articles/9425... · Posted by u/sergeyprokhoren
A great thing about the Web is it can still be programmed just like it was thirty years ago. Unless you actually need an application a lot of web tooling and libraries are a waste of time. It's a great medium for actual documents.
What? No love for Perl scripts in cgi-bin/ ?
I moved from pip to poetry a while back, but was introduced to uv recently while working on MCP stuff. I now use uv for everything and haven’t looked back.
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
Where's the pagination? How does a large query here not blow up my context:
https://github.com/stuzero/pg-mcp/blob/main/server/tools/que...
It's coming...
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
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.
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
I 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.
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
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)spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
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.
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
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.
spennant commented on Show HN: Cloud-Ready Postgres MCP Server github.com/stuzero/pg-mcp... · Posted by u/spennant
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.
I made a few assumptions about the actual deployer and their environment that I shouldn’t have… I’ll need to address this. Thanks!