PGMAGIC

CHAT TO POSTGRES IN
NATURAL LANGUAGE.

It's not another f$#@-ing subscription!

Have a d&m with your db.

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)

Natural Language Queries
SQL Intellisense
Syntax Highlighting
Table viewer
14mb Mac App
Dark mode

Features

  • Small 14mb mac app
  • Connects and executes queries directly on your pg instance
  • Run regular SQL queries or ask a question in natural language based on your database schema
  • Credentials are stored locally on your machine
  • Dark mode
  • Save and manage multiple databases
  • Export results to json
  • Schema viewer
  • Table viewer that can render tens of thousands of rows.
  • SQL syntax higlighting and autocomplete from on your db schema
  • Uses the underlying editor that powers VSCode (...so it's not shit!)

    • Coming Soon

  • Local inference using downloaded LLM
  • Windows and Linux support
  • Export to csv

This must be boring watching me click on stuff. You could be doing this yourself ;)
The buy button is up there ^^^

FAQ

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)