←back to thread

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

(github.com)
103 points nicktikhonov | 2 comments | 20 Jun 25 11:08 UTC | HN request time: 0.637s | 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. throwmeaway9876 ◴[20 Jun 25 16:23 UTC] No.44329300[source]▶
Great tool!

Pardon my technical ignorance, but what exactly is OpenAI's API being used for in this?

replies(1): >>44329470 #
2. nicktikhonov ◴[20 Jun 25 16:37 UTC] No.44329470[source]▶
OpenAI LLM is used to generate SQL based on a combination of a user prompt and the database schema.
replies(1): >>44331216 #