←back to thread

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

(github.com)
103 points nicktikhonov | 4 comments | 20 Jun 25 11:08 UTC | HN request time: 0.763s | 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.

1. gabrielruttner ◴[20 Jun 25 16:07 UTC] No.44329096[source]▶
This is nice -- we're heavy users of postgresql and haven't found the right tool here yet.

I could see this being incredible if it had a set of performance related queries or ran explain analyze and offered some interpreted results.

Can this be run fully locally with a local llm?

replies(2): >>44329109 #>>44329234 #
2. nicktikhonov ◴[20 Jun 25 16:08 UTC] No.44329109[source]▶
Thank you for the feedback. Please feel free to raise some issues on the repo and we can jam this out there
3. stephancill ◴[20 Jun 25 16:18 UTC] No.44329234[source]▶
just opened a PR for local llm support https://github.com/NickTikhonov/snap-ql/pull/11
replies(1): >>44329461 #
4. nicktikhonov ◴[20 Jun 25 16:36 UTC] No.44329461[source]▶
Merged! Thanks Stephan