Show HN: SnapQL – Desktop app to query Postgres with AI • Hacker News Board

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

#1

Post by nicktikhonov » Fri, Jun 20, 2025, 11:08 AM UTC

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 HN: SnapQL – Desktop app to query Postgres with AI
github.com

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

#2

Post by zicon35 » Fri, Jun 20, 2025, 11:18 AM UTC

congrats on the launch! This looks very interesting

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

#3

Post by jaimin888patel » Fri, Jun 20, 2025, 11:36 AM UTC

awesome work nick, literally been asking for a vibe coding SQL interface for months

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

#4

Post by esafak » Fri, Jun 20, 2025, 2:07 PM UTC

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?

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

#5

Post by boredemployee » Fri, Jun 20, 2025, 2:20 PM UTC

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?

[flagged]

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

#6

Post by nicktikhonov » Fri, Jun 20, 2025, 2:24 PM UTC

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.

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

#7

Post by [deleted] » Fri, Jun 20, 2025, 2:27 PM UTC

boredemployee wrote: post #5

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?

[flagged]

[deleted]

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

#8

Post by [deleted] » Fri, Jun 20, 2025, 2:27 PM UTC

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?

[deleted]

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

#9

Post by [deleted] » Fri, Jun 20, 2025, 2:28 PM UTC

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?

[deleted]

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

#10

Post by GarrickDrgn » Fri, Jun 20, 2025, 2:29 PM UTC

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