←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: 0s | 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
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 #
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 #
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 #
1. BenderV ◴[20 Jun 25 15:17 UTC] No.44328542[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.