Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

github.com

Post reply on HN
Print view View original

41–50 of 85 posts

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

#41

Post by kokanee »

nicktikhonov wrote: post #25
GarrickDrgn wrote: post #10

Am I misunderstanding something? How is this "Everything runs locally" if it's talking to OpenAI's APIs?

What I meant was that it isn't a web app and I don't store your connection strings or query results. I'll make this more clear

It is a web app, though. You just aren't running the server, OpenAI is. And you're packaging the front end in electron instead of chrome to make it feel as if it all runs locally, even though it doesn't.

Side note: I don't see a license anywhere, so technically it isn't open source.

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

#43

Post by nicktikhonov »

stephancill wrote: post #40
gabrielruttner wrote: post #36

This is nice -- we're heavy users of postgresql and haven't found the right tool here yet. I could see this being incredible if it had a set of performance related queries or ran explain analyze and offered some interpreted results. Can this be run fully locally with a local llm?

just opened a PR for local llm support https://github.com/NickTikhonov/snap-ql/pull/11

Merged! Thanks Stephan

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

#45

Post by _9y71 »

nicktikhonov wrote: post #27
esafak wrote: post #14

Earlier quoted context omitted.

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.

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.

Your project is source-available, not open-source. Consider adding a license.

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

#47

Post by ramoz »

revskill wrote: post #28
nicktikhonov wrote: post #24

Earlier quoted context omitted.

Currently OpenAI 4o

So u already train all knowledgebase or fine tune? Would love to know how can u evaluate correctness.

they don't it's simple a zero-shot text to sql interface. the app development started 2days ago.

https://github.com/NickTikhonov/snap-ql/blob/main/src/main/l...

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

#48

Post by ramoz »

nicktikhonov wrote: post #6
esafak wrote: post #4

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?

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.

https://dbeaver.com/docs/dbeaver/AI-Smart-Assistance/
Post reply on HN