Viewing profile — spennant

I'm working on leveraging NLP and LLM techniques to create a geometry over the discrete space of Ethereum transaction execution structure. (sorry... it's a bit of a mouthful) https…

I built a block explorer that allows visitors to browse the Ethereum blockchain by the shape of each transaction’s calls tree and address interaction graph. The call tree visualiza…

Is this still true?

Fine tuning Gemini 2.5 flash on EVM Blockchain execution structures and using perplexity with PageRank to perform transaction anomaly detection. https://lite.chaingenius.ai/theory …

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 an…

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.

It's coming...

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.

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 provid…

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 thi…

Indeed. Anything you do with MCP can be done in more traditional ways.

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 …

I made a few assumptions about the actual deployer and their environment that I shouldn’t have… I’ll need to address this. Thanks!

The pg-mcp server doesn’t need an API key. Those variables are only needed to run the example claude-client. You can write your own agent to talk to whatever LLM you like.

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 na…

Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant a…

I feel the same way. https://news.ycombinator.com/item?id=30094245

Money not a problem? Get a "pro"/digital sign display and connect your own sound system as well as tuner/stb. https://www.lg.com/us/business/digital-signage/lg-65ep5g https://www.s…

Personal story: I sat in his office as an undergrad and he presented a problem to me concerning counting balls in boxes that had applications to quantum theory. It blew my freshman…

Sure. But two things: 1) At the time, the European data laws implied that it protected its citizens no matter where they are. Nobody wanted to be the first to test that in court. 2…

Agreed. The media and advertising industry was most definitely leveraging cookie-level data for building attribution and targeting models. As soon as the EU established that this d…

In other words... being Iceman is better than being Maverick.

In October, NASA plans to launch the Europa Clipper on a mission to study Jupiter’s fourth-largest moon, one of the most promising places to search for extraterrestrial life in the…