Skip to content
pgMagic

Self-hosted alternatives to pgMagic

200 self-hosted apps like pgMagic, closest match first.

Top picks

  1. P

    pgweb

    Launch

    Pgweb 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

  2. L

    LibreDB Studio

    Launch

    Browser-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

  3. P

    Pgbackweb

    Launch

    🐘 Effortless PostgreSQL backups with a user-friendly web interface! 🌐💾

    FreeOpen sourceSelf-hosted

  4. O

    OrcaQ

    Launch

    Modern 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

  5. P

    Prest

    Launch

    Instant 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

  6. P

    pgAdmin

    Launch

    pgAdmin 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

7
S

StackRender

Database schema design and SQL migration generator supporting PostgreSQL, MySQL

Launch
8
D

Dbgate

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

Launch
9
O

Oddk

Opinionated Database Deployment Kit — locally running RDS for PostgreSQL

Launch
10
C

CloudBeaver

Manage databases, supports PostgreSQL, MySQL, SQLite and more

Launch
11
U

undb

Build and manage custom databases

Launch
12
D

Databasus

PostgreSQL backup tool with Point-In-Time-Recovery and restore verification

Launch
13
A

Adminer

Database management in a single PHP file

Launch
14
A

AstraSQL Agent — AI-Powered NL to SQL

Convert natural language to SQL for database analytics

Launch
15
V

Vela

Postgres Platform with full stack (auth, APIs, functions), instant cloning…

Launch
16
D

Datasette ChatGPT plugin

Enable natural language questions, real-time insights

Launch
17
V

Velld

Database backup management and automation

Launch
18
M

Magic

Instant SECURE Full Stack Apps and AI Agents

Launch
19
C

ChartDB

Database diagrams editor that allows you to visualize and design your DB

Launch
20
D

d9

Turn SQL databases into secure APIs through an intuitive admin interface

Launch
21
Q

QueryGlow

QueryGlow is a self-hosted database GUI supporting multiple databases

Launch
22
W

WhoDB

Where data access meets operational intelligence

Launch
23
S

SQLPage

SQL-only dynamic website builder. (Source Code) MIT Rust/Docker

Launch
24
P

Portabase

Database backup & restore tool for PostgreSQL, MySQL, MsSQL

Launch
25
I

Insights

Open Source Self-Hosted Business Intelligence Platform

Launch
26
A

Atomic Server

Knowledge graph database with documents

Launch
27
B

Baserow

Open source no-code database and Airtable alternative

Launch
28
F

flatnotes

Database-less note-taking web app

Launch
29
S

Supabase Automated Self Host

Self-host Supabase with Nginx/Caddy and Authelia with just ONE bash script

Launch
30
P

Pigsty

Enterprise-Grade OSS PostgreSQL Distribution

Launch
31
D

Directus

Data platform which wraps any database with an intuitive app

Launch
32
C

Chmonitor

Open-source operational advisor for ClickHouse

Launch
33
D

datannur

Lightweight data catalog for documenting and exploring structured data files

Launch
34
W

Wide

Run Go with full intellisense code-completion, expression-info

Launch
35
R

RootCX

One place for every internal app and AI agent

Launch
36
A

Airbroke

Lightweight, Airbrake/Sentry-compatible

Launch
37
S

Supa Manager

Manage self-hosted Supabase instances with an easy to use API & Web Portal

Launch
38
T

Turtl

Totally private personal database and note taking app

Launch
39
B

ByteStash

Pastebin and file storage service with a simple web interface

Launch
40
G

Graphweaver

Turn multiple data sources into a single GraphQL API

Launch
41
E

Evidence

Lightweight BI using SQL and markdown

Launch
42
C

Coordino

Self-hosted Knowledge Software your question & answer system written on top of

Launch
43
M

Marmot

Data catalog for discovering and organizing data assets across your stack

Launch
44
C

CH-UI

Use CH-UI to work with your data from Click House self-hosted

Launch
45
E

Expressa

Content Management System for powering database driven websites

Launch
46
L

Livebook

Realtime collaborative notebook app based on Markdown

Launch
47
P

purple

Free, open-source terminal SSH manager and SSH config editor in Rust

Launch
48
C

Compiiile

The most convenient way to render and deploy a folder containing markdown files

Launch
49
T

Totum

Business database for non-programmers

Launch
50
M

Memory

A self-hosted editor and note taking app

Launch

About pgMagic

P

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