←back to thread

Show HN: SnapQL – Desktop app to query Postgres with AI

(github.com)
103 points nicktikhonov | 1 comments | 20 Jun 25 11:08 UTC | HN request time: 0.375s | source

SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand.

Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.

Show context
GarrickDrgn ◴[20 Jun 25 14:29 UTC] No.44328059[source]▶
Am I misunderstanding something? How is this "Everything runs locally" if it's talking to OpenAI's APIs?
replies(4): >>44328354 #>>44328449 #>>44328475 #>>44328580 #
nicktikhonov ◴[20 Jun 25 15:22 UTC] No.44328580[source]▶
What I meant was that it isn't a web app and I don't store your connection strings or query results. I'll make this more clear
replies(2): >>44328639 #>>44329251 #
omega3 ◴[20 Jun 25 15:27 UTC] No.44328639[source]▶
You might not but openai does.
replies(2): >>44328748 #>>44328906 #
1. doctorpangloss ◴[20 Jun 25 15:37 UTC] No.44328748[source]▶
API gateways could accept public keys instead of generating bearer tokens. Then the private key could reside in an HSM, and apps like this could give HSMs requests to sign. IMO even though this could be done in an afternoon, everyone - Apple and Google, the CDN / WAF provider, the service provider - is too addicted to the telemetry.