Live data from Hacker News

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

github.com

11–20 of 85 posts

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

#11
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...).

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

#14
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.

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.

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

#16

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

This app is using OpenAI via the ai package[0][1], so "Everything runs locally" is definitely misleading.

[0]: https://github.com/NickTikhonov/snap-ql/blob/409e937fa330deb...

[1]: https://github.com/vercel/ai

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

#20
post #14

Earlier quoted context omitted.

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.

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.

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.

Post reply on HN