←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.209s | 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
anshumankmr ◴[20 Jun 25 15:57 UTC] No.44328966[source]▶
Would love to contribute. I have made a fork, will try and raise a PR if contributions are welcome.

Question, how are you testing this? Like doing it on dummy data is a bit too easy. These models, even 4o, falter when it comes to something really specific to a domain (like I work with supply chain data and other column names specific to the work that I do, that only makes sense to me and my team, but wouldn't make any sense to an LLM unless it somehow knows what those columns are)

replies(1): >>44329131 #
1. nicktikhonov ◴[20 Jun 25 16:09 UTC] No.44329131[source]▶
I'm using my own production databases at the moment. But it might be quite nice to be able to generate complex databases with dummy data in order to test the prompts at the higher levels of complexity!

And thank you for offering to contribute. I'll be very active on GitHub!