Live data from Hacker News

Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

pgmagic.app

1–10 of 13 posts

Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

#1
Hi HN. This is a project I've been building for the last month.

It's a macOS postgres client that uses your OpenAI key to generate and immediately execute queries against your database locally on your machine.

I imagine the user being someone familiar with SQL and able to identify errors in the generated code, but regularly needs to write queries to answer relatively simple questions.

This is my first software project I'm intending on selling myself and would love feedback on the product and landing page. I'd also love ideas on how to market it to users, as I'm very new to this.

In the near future I want to flesh out the features to include:

* toggle immediate execution

* better export/editing

* local model inference

* windows & linux support

* themes

Thanks for trying it out and let me know what you think!

Show HN: pgMagic – a Mac Postgres client that lets you query in natural language
pgmagic.app

Re: Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

#7
Neat project!

Just in case its helpful to you, I maintain pg_query together with my colleagues at pganalyze, which packages the Postgres parser as a library: https://github.com/pganalyze/libpg_query

Might be useful to include in your product as a way to run a quick syntax check on the query output by the LLM, without actually connecting to the database and causing an error in the logs.

Re: Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

#8
Put priority on local models and aims for data analysts. Both SQL syntax and a structure of the database even for big project are simple and users will ask relatively simple questions. I bet you don't even need "large" language models for this.

Re: Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

#9
post #7

Neat project! Just in case its helpful to you, I maintain pg_query together with my colleagues at pganalyze, which packages the Postgres parser as a library: https://github.com/pganalyze/libpg_query Might be useful to include in your product as a way to run a quick syntax check on the query output by the LLM, without actually connecting to the database and causing an error in the logs.

Awesome! Great idea I'll check this out. Thanks :)

Re: Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

#10
post #4

This is cool. Not a feature request, but I guess my dream version of this in my head since I saw GPT-3 was this + charts, and maybe for Clickhouse.

Yeah data viz generation is certainly something I'm looking into adding.
Post reply on HN