Description
pgMagic is a small PostgreSQL client for Mac that lets you ask questions of your database in plain English. It also works as a regular database client: you connect to a Postgres instance, run SQL directly, browse tables and view the schema. When you type a question, the app generates the SQL from your database schema and runs it straight away. The editor is the one that powers VS Code, so it offers syntax highlighting and autocomplete drawn from your own tables. The table viewer can render tens of thousands of rows, and results can be exported to JSON. You can save and manage several databases, and dark mode is included. The app is a download of about 14 MB. Natural-language queries use an OpenAI API key that you enter when the app starts, because pgMagic is a client only and does not provide a key.…
Highlights
- Natural-language questions that run as generated SQL
- SQL autocomplete and syntax highlighting from your schema
- Table viewer that renders tens of thousands of rows
- Save and manage multiple databases, export results to JSON
- Credentials stored locally on your machine
Ratings & Reviews
No ratings yet
Be the first to rate pgMagic.
People also visit
TablePro
A native database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis, and more
pgMagic FAQ
Is an OpenAI API key included?
No. pgMagic is a client only. You enter your own OpenAI API key when the app starts. The site says the author chose not to charge a subscription in order to provide one.
Which platforms does pgMagic run on?
It is a Mac app. The site lists Windows and Linux support as coming soon.
Where are my database credentials kept?
On your own machine. The site says credentials are stored locally and are not sent to a pgMagic server.
Does pgMagic run queries on my database itself?
Yes. It connects to your Postgres instance and executes queries directly, including SQL it generates from a question you type in plain English.
Can I export query results?
Yes, results can be exported to JSON. Export to CSV is listed on the site as coming soon.
What are the best pgMagic alternatives?
Popular alternatives to pgMagic include data-peek, pgweb and DBcooper. See all pgMagic alternatives

