←back to thread

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

(github.com)
103 points nicktikhonov | 10 comments | 20 Jun 25 11:08 UTC | HN request time: 1.299s | source | bottom

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. esafak ◴[20 Jun 25 14:07 UTC] No.44327879[source]▶
If you can do this, can't you create a read-only user and use it with a database MCP like https://github.com/executeautomation/mcp-database-server ? Am I missing something?
replies(4): >>44327987 #>>44328015 #>>44328042 #>>44328050 #
2. nicktikhonov ◴[20 Jun 25 14:24 UTC] No.44328015[source]▶
You can set up an MCP and use it in your existing AI app, but is afaiu the first open source standalone app that gives you a familiar interface to other SQL workspace tools. I built it to be a familiar but much more powerful experience for both technical and nontechnical people.
replies(2): >>44328242 #>>44330049 #
3. ◴[20 Jun 25 14:27 UTC] No.44328040[source]▶
4. ◴[20 Jun 25 14:27 UTC] No.44328042[source]▶
5. ◴[20 Jun 25 14:28 UTC] No.44328050[source]▶
6. esafak ◴[20 Jun 25 14:49 UTC] No.44328242[source]▶
There are competitors with a GUI too, such as https://www.sqlchat.ai/ and https://www.jetbrains.com/datagrip/features/ai/

I wish you luck in refining your differentiation.

replies(2): >>44328542 #>>44328640 #
7. BenderV ◴[20 Jun 25 15:17 UTC] No.44328542{3}[source]▶
Selfless plug, our own tool => https://www.myriade.ai

> I wish you luck in refining your differentiation. Can't agree more with you. It's about distribution (which Snowflake/Databricks/... have) or differentiation.

Still, chatting with your data is already working and useful for lots.

8. nicktikhonov ◴[20 Jun 25 15:27 UTC] No.44328640{3}[source]▶
The first doesn't have good UX and the second isn't open source. SnapQL is both :) But I'll find new ways to differentiate for sure, it's part of the fun of building.
replies(1): >>44329622 #
9. un1970ix ◴[20 Jun 25 16:51 UTC] No.44329622{4}[source]▶
Your project is source-available, not open-source. Consider adding a license.
10. ramoz ◴[20 Jun 25 17:40 UTC] No.44330049[source]▶
https://dbeaver.com/docs/dbeaver/AI-Smart-Assistance/