Self-hosted alternatives to pgMagic
200 self-hosted apps like pgMagic, closest match first.
Top picks
- 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
- L
LibreDB Studio
LaunchBrowser-based SQL IDE for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse, DuckDB and more, with SSO, audit trail, ER diagrams and optional AI assistance on your own model key (alternative to DataGrip, DBeaver, CloudBeaver
FreeOpen sourceSelf-hosted
- P

Pgbackweb
Launch🐘 Effortless PostgreSQL backups with a user-friendly web interface! 🌐💾
FreeOpen sourceSelf-hosted
- O

OrcaQ
LaunchModern database client and IDE for managing, querying, and exploring multiple database types with built-in AI assistant. (Source Code) MIT Nodejs/deb/Docker
FreeOpen sourceSelf-hosted
- P
Prest
LaunchInstant REST and MCP APIs for PostgreSQL and MySQL, on existing or new databases. CRUD, custom SQL routes, auth and ACL without writing a backend. Low-code, ⚡ realtime, high-performance. Native MySQL support since v2.5.
FreeOpen sourceSelf-hosted
- P

pgAdmin
LaunchpgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a s
FreeOpen sourceSelf-hosted
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






