News for hackers. Stuff that matters.
Re:Show HN: I just built a MCP Server that connects Claude t... by thitami on Monday April 06, 2026 @05:49AM (#47658796)
The JSONB approach for time-series is pragmatic for this scale. The 90-day sleep query concern is real though — have you considered a partial index on the timestamp field within the JSONB, or is the aggregation layer from Terra making that unnecessary? Also curious about the MCP server design: are you streaming responses back to Claude or returning complete payloads? For trend analysis over 90 days that could be a meaningful difference in perceived latency.
[dead]
Re:Show HN: I just built a MCP Server that connects Claude t... by silbercue on Tuesday April 07, 2026 @03:48PM (#47680454)
> Streaming would make sense if I were piping large sample arrays directly, but those get aggregated server-side before returning

thitami's point on perceived latency is the thing I'd still watch. had the same "its fine, its fast enough" moment in a different MCP context (iOS simulator automation)... turned out the 300ms per-tool-call was what made the whole loop feel sluggish even though each individual query was "fast". got it down to ~20ms and Claude felt noticeably less hesitant between calls after that. cant fully explain why but the behavior shift was real.

probably not your problem at 90 rows of scalar data =) just a thing I wish I had clocked earlier.

Re:Show HN: I just built a MCP Server that connects Claude t... by anton_salcher on Thursday April 09, 2026 @02:02PM (#47707144)
Thanks for the tip though. I will definitely keep an eye on the latency thing. If you have any other tips on how to build a MCP Server, I would really appreciate your experience. Moreover, I would really respect it if you could test my product and give me some honest, clear feedback - if you want, obviously. Thanks ;)