←back to thread

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

(github.com)
104 points nicktikhonov | 1 comments | 20 Jun 25 11:08 UTC | HN request time: 0.204s | 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
sgarland ◴[20 Jun 25 23:36 UTC] No.44333123[source]▶
Genuinely do not understand the point of these tools. There is already a practically natural language to query RDBMS; it’s called SQL. I guarantee you, anyone who knows any other language could learn enough SQL to do 99% of what they wanted in a couple of hours. Give it a day of intensive study, and you’d know the rest. It’s just not that complicated.
replies(4): >>44333181 #>>44333631 #>>44333930 #>>44335820 #
1. physix ◴[21 Jun 25 02:15 UTC] No.44333930[source]▶
Without having looked at it, I would assume the value comes from not having to know the data model in great detail, such that you can phrase your query using natural language, like

"Give me all the back office account postings for payment transfers of CCP cleared IRD trades which settled yesterday with a payment amount over 1M having a value date in two days"

That's what I'd like to be able to say and get an accurate response.