←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.412s | 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. jasonthorsness ◴[20 Jun 25 14:34 UTC] No.44328109[source]▶
Looks useful! And the system prompt didn't require too much finessing. I wonder how it would work with some later models than gpt-4o as in my own dabbling around gpt-4o wasn't quite there yet and the latest models are getting really good.

For analytical purposes, this text-to-SQL is the future; it's already huge with Snowflake (https://www.snowflake.com/en/engineering-blog/cortex-analyst...).

replies(1): >>44328659 #
2. nicktikhonov ◴[20 Jun 25 15:28 UTC] No.44328659[source]▶
Appreciate the input! I'd love to be able to support more models. That's one of the issues in the repo right now. And I'd be more than happy to welcome contributions to add this and other features