Hacker News

Show HN: SQL Query Optimizer

Hacker News - Fri, 02/20/2026 - 1:30pm

Hello all,

I wrote a tool to optimize SQL queries using LLM models. I sometimes struggle to find the root cause for the slow running queries and sending to LLM most of the time doesn't have good result. I think the reason is LLM doesnt have the context of our database, schemas, explain results .etc.

That is why I decided to write a tool that gathers all infor about our data and suggest meaningful improvements including adding indexes, materialized views, or simply rewriting the query itself. The tool supports only PostgreSQL and MySQL for now , but you can easily fork and add your own desired database.

You just need to add your LLM api key and database credentials. It is an open source tool so I highly appreciate the review and contribution if you would like.

Feel free to check it out : https://github.com/SubhanHakverdiyev/OptimizeQL

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

Points: 1

# Comments: 0

Categories: Hacker News

Ask HN: What is the current adoption scenario for background coding agents?

Hacker News - Fri, 02/20/2026 - 1:30pm

Hi, background coding agents are here for about half a year now. But only bold and forward teams are using it so far. what is your say? have you adopted background agents in your organization or are most of the people still working with locally running coding agents? One thing i have felt is that organizations are reluctant to give access to these vendors to clone their repos in cloud machines. But what is the overall scenario? are we shifting really to background agents, if yes are organizations and teams trusting third party vendors to clone their repos on cloud machines for the agent to work on? Thanks!

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

Points: 1

# Comments: 1

Categories: Hacker News

Show HN: LobsterHelper – Managed OpenClaw on Firecracker VMs

Hacker News - Fri, 02/20/2026 - 1:29pm

Hey HN,

steipete mentioned in an interview that if you can't use a terminal you shouldn't use OpenClaw (paraphrasing). I disagree - the way we interact with the internet is changing, and simply because a new technology carries risk doesn't mean that one cadre of society is uniquely well-equipped to understand and accept the risks.

So, I put my money where my mouth is and built LobsterHelper.

Each instance runs in its own Firecracker micro-VM with LUKS-encrypted storage. Not Docker containers on shared infra. The VMs have no public IP - all access goes through an authenticated proxy.

I can't make the AI safe yet, but I can make the infra safe, and that's a good place to start.

We've got a long dev-log lined up (3rd party api configuration on platform, token metering, free token use tiers, openclaw UI enhancements) and we'll have bonuses for early adopters along the way.

We're on a long journey to make these technologies safer and more accessible, and we'd hope you join us for the ride.

Alex

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

Points: 1

# Comments: 0

Categories: Hacker News

Show HN: Manifestinx-verify – offline verifier for evidence bundles (drift)

Hacker News - Fri, 02/20/2026 - 1:27pm

Manifest-InX EBS is a spec + offline verifier + proof kit for tamper-evident evidence bundles.

Non-negotiable alignment: - Live provider calls are nondeterministic. - Determinism begins at CAPTURE (pinned artifacts). - Replay is deterministic offline. - Drift/tamper is deterministically rejected.

Try it in typically ~10 minutes (no signup): 1) Run the verifier against the included golden bundle → PASS 2) Tamper an artifact without updating hashes → deterministic drift/tamper rejection

Repo: https://github.com/OneInX/Manifest-InX-EBS Skeptic check: docs/ebs/PROOF_KIT/10_MINUTE_SKEPTIC_CHECK.md

Exit codes: 0=OK, 2=DRIFT/TAMPER, 1=INVALID/ERROR

Boundaries: - This repo ships verifier/spec/proof kit only. The Evidence Gateway (capture/emission runtime) is intentionally not included. - This is not a “model correctness / no hallucinations” claim—this is evidence integrity + deterministic replay/verification from pinned artifacts.

Looking for feedback: - Does the exit-code model map cleanly to CI gate usage? - Any spec/report format rough edges that block adoption?

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

Points: 1

# Comments: 0

Categories: Hacker News

Photopea-Online Photo Editor

Hacker News - Fri, 02/20/2026 - 1:26pm

Article URL: https://www.photopea.com/

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

Points: 2

# Comments: 0

Categories: Hacker News

Lil' Fun Langs

Hacker News - Fri, 02/20/2026 - 12:34pm

Article URL: https://taylor.town/scrapscript-000

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

Points: 1

# Comments: 0

Categories: Hacker News

Pages