It's not another f$#@-ing subscription!
pgMagic is a tiny postgres client for mac that understands natural language. You can do everything you would expect from a regular db client, but you can also ask questions in plain English and have the generated SQL run immediately.
It's as if you're talking to a friend ... who knows a suspicious amount about your data schema
This is me clicking around on stuff (@2x speed so you don't have to watch me type)
Coming Soon
This must be boring watching me click on stuff. You could be doing this yourself ;)
The buy button is up there ^^^
Is an OpenAI api key provided?
No. This is a client only. You can enter your own API key on pgMagic startup. I would have to charge a subscription fee to provide an API key, and I don't want to do that.
Is using my own OpenAI key expensive?
It depends on how many natural language queries you send and the size of your database schema, however as a rough estimate based on my own usage during the development of this tool, I have not exceeeded $0.07 per day.
Of course, I recommend setting a usage limit.
What data is sent to OpenAI?
We fetch your public schema (i.e. tables, column names and types), serialize it and send it to OpenAI. We do not send any of your row data. Of course your natural language query is also sent, so any data included in that will be sent to OpenAI.
Can I use a local model?
Not yet. But soon! This is the next feature I'm working on.
Is this available on Windows & Linux?
Not yet. But soon! This is the next feature I'm working on after that last one.
Is it correct?
Usually! It works best on simple queries. LLMs, of course are overconfident stochastic babblers so it is definitely wise to check the output SQL before presenting it to your boss.
What databases does pgMagic support?
Believe it or not, only postgres. I might add support for other databases in the future (and probs a rebrand lmao)