Hacker News: spennant

New comment by spennant in "Ask HN: What are you working on? (February 2026)"

spennant — Mon, 09 Feb 2026 15:48:47 +0000

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

[SMILES](https://en.wikipedia.org/wiki/Simplified_Molecular_Input_Lin...) or [SELFIES](https://resources.wolframcloud.com/PacletRepository/resource...), but for EVM Blockchain executions.

New comment by spennant in "6NF File Format"

spennant — Thu, 04 Sep 2025 01:42:39 +0000

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.

New comment by spennant in "Geocities Backgrounds"

spennant — Wed, 23 Jul 2025 18:16:58 +0000

What? No love for Perl scripts in cgi-bin/ ?

New comment by spennant in "uv: An extremely fast Python package and project manager, written in Rust"

spennant — Mon, 23 Jun 2025 19:16:48 +0000

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.

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 23:36:53 +0000

It's coming...

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 15:51:36 +0000

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.

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 15:48:15 +0000

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.

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 15:11:09 +0000

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)

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 14:57:28 +0000

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

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 14:31:16 +0000

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.

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 12:27:57 +0000

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

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 12:18:24 +0000

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.

New comment by spennant in "Show HN: Cloud-Ready Postgres MCP Server"

spennant — Sun, 30 Mar 2025 12:10:50 +0000

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 help if the agent executed the query to see how it answered the user’s question. In other words “reasoning”… pg-mcp simply exposes the required context for Agents to do that kind of reasoning.

Show HN: Cloud-Ready Postgres MCP Server

spennant — Sun, 30 Mar 2025 03:14:36 +0000

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 and runs over HTTP/SSE (not stdio)

Features - Supports multiple database connections from multiple agents

- Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases)

- Read-Only Queries: Controlled execution of queries via MCP.

- EXPLAIN Tool: Helps smart agents optimize queries before execution.

- Extension Plugins: YAML-based plugin system for Postgres extensions (supports pgvector and postgis out of the box).

- Server Mode: Spin up the container and it's ready to accept connections at http://localhost:8000/sse

Comments URL: https://news.ycombinator.com/item?id=43520953

Points: 167

# Comments: 79

New comment by spennant in "NASA spacecraft to probe possibility of life in Europa's salty ocean"

spennant — Wed, 25 Sep 2024 18:43:28 +0000

I feel the same way.

https://news.ycombinator.com/item?id=30094245

New comment by spennant in "LG and Samsung are making TV screens disappear"

spennant — Tue, 30 Jul 2024 14:56:04 +0000

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.samsung.com/us/business/displays/4k-uhd/qe-serie...

New comment by spennant in "Lessons I Wish I Had Been Taught (1996) [pdf]"

spennant — Thu, 27 Jun 2024 17:29:05 +0000

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

New comment by spennant in "Machine Unlearning in 2024"

spennant — Sun, 05 May 2024 17:58:29 +0000

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) The organizations and agencies performing this type of data modeling were often doing so on behalf of large multinational organizations with absurd advertising spends, so they were dealing with Other People’s Data. The responsibility of scrubbing it clean of EU citizen data was unclear.

What this meant was that an EU tourist who traveled to the US, and got served a targeted ad, could make a RTBF request to the advertiser (think Coca-Cola, Nestle or Unilever)

The whole thing was a mess.

New comment by spennant in "Machine Unlearning in 2024"

spennant — Sun, 05 May 2024 14:39:55 +0000

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 data was “personal data”, as it could, theoretically, be tied back to individual citizens, there were questions about the models. Namely “Would they have to be rebuilt after every RTBF request?” Needless to say, no one in the industry really wanted to address the question, as the wrong answer would essentially shut down a very profitable practice.

New comment by spennant in "Avoid blundering: 80% of a winning strategy"

spennant — Wed, 03 Apr 2024 19:21:31 +0000

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