Open source alternatives to pgMagic
200 open source apps like pgMagic, closest match first.
Top picks
- D
data-peek
LaunchA lightning-fast, AI-powered database client. Query, explore, and edit PostgreSQL, MySQL, SQL Server, and SQLite, and query and browse ClickHouse, with a keyboard-first experience. Free for personal use.
FreeOpen source
- P
pgweb
LaunchPgweb is a web-based client for PostgreSQL databases. It runs as a single binary on macOS, Linux and Windows, and you open it in a browser to browse tables and run SQL queries. The binaries are cross-compiled with Go and available for 32 an
FreeOpen sourceSelf-hosted
- D

DBcooper
LaunchA fast, native macOS database client for PostgreSQL, MySQL, MariaDB, MongoDB, SQLite, DuckDB, Redis, ClickHouse, and Cloudflare D1. Browse data, run queries, visualize schemas, and generate queries with AI.
FreeOpen source
- T

TablePro
LaunchA native database client for MySQL, PostgreSQL, SQLite, MongoDB, Redis, and more. [![Open-Source Software][OSS Icon]](https://github.com/TableProApp/TablePro) ![Freeware][Freeware Icon]
FreeOpen source
- S
Seaquel
LaunchA fast, offline-first SQL client for Postgres, MySQL, MariaDB, SQLite, SQL Server and DuckDB. Browse schemas, visualize queries, and add AI assistance only when you want it.
FreeOpen source
- C

Conar
LaunchConar is a database client for Postgres, MySQL, MSSQL and ClickHouse, with AI features for writing queries and filtering data. You can chat with your database in natural language, asking questions such as which users have orders, and the as
Open source
More like pgMagic
About pgMagic
pgMagic
A Mac Postgres client that lets you query in natural language
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.
- Category
- Developer Tools
- Website
- pgmagic.app









