Hacker News new | past | comments | ask | show | jobs | submit login
Show HN: pgMagic – a Mac Postgres client that lets you query in natural language (pgmagic.app)
49 points by tjhill on June 14, 2023 | hide | past | favorite | 12 comments
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!




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 :)


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.


P.S. If you would like to purchase it after the demo, please use HELLOHN for 25% off :)

Thanks again!


This looks really cool! Unfortunately, no matter how hard I try, I can't seem to connect to a database. I get the "error returned from database: permission denied for database "postgres" even though I'm specifying all the fields.


Hey! I’d love to learn more about your setup if you have time. Do you mind sending an email to hello[at]pgmagic.app - Thanks!


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.


Nice work! I’m really interested in this but I made the unfortunate mistake of tying all my apps to MS SQL a long time ago. I might still pick this up for future projects.


cool, 1 year of updates seems like a good alternative to subs


This is very cool. I'll definitely try it out soon.


This is awesome!




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: