Skip to content
pgMagic

Open source alternatives to pgMagic

200 open source apps like pgMagic, closest match first.

Top picks

  1. D

    data-peek

    Launch

    A 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

  2. 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

  3. D

    DBcooper

    Launch

    A 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

  4. T

    TablePro

    Launch

    A 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

  5. S

    Seaquel

    Launch

    A 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

  6. C

    Conar

    Launch

    Conar 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

7
Z

ZQLZ

the DATABASE Editor. https://discord.gg/cEe8v2Y7PJ

Launch
8
A

App

Database explorer for Mac, Windows & Linux

Launch
9
P

Pgconsole

Minimal Postgres editor for speed, collaboration, and AI

Launch
10
P

Pgpad

A small, fast cross-platform database client

Launch
11
T

Tusk

PostgreSQL Client

Launch
12
D

Dblab

The database client every command line junkie deserves

Launch
13
P

Postbird

Open source PostgreSQL GUI client for macOS, Linux and Windows

Launch
14
D

DBFlux

A fast, keyboard-first database client built with Rust and GPUI

Launch
15
T

Tusk

A fast, native, keyboard-driven database client for macOS

Launch
16
B

Bdash

Simple SQL Client for lightweight data analysis

Launch
17
C

Clickbase

Open Source Analytics

Launch
18
Q

QoreDB

Next Generation Database Client

Launch
19
S

subnetmarco/pgmcp

Natural-language queries for any PostgreSQL database

Get
20
D

dbstudio.sh

The modern pgAdmin alternative that works with every database

Launch
21
V

VeloxDB

Database management, built for developers

Launch
22
T

Tabularis

Lightweight database management tool

Launch
23
L

LibreDB Studio

Browser-based SQL IDE for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis

Launch
24
P

Pgbackweb

Effortless PostgreSQL backups with a user-friendly web interface!

Launch
25
O

OrcaQ

Modern database client and IDE for managing, querying

Launch
26
C

Collector

pganalyze statistics collector for gathering PostgreSQL metrics and log data

Launch
27
P

Prest

Instant REST and MCP APIs for PostgreSQL and MySQL, on existing or new databases

Launch
28
D

Database Build

In-browser Postgres sandbox with AI assistance (formerly postgres.new)

Launch
29
N

Neon

Postgres backends for apps and agents

Launch
30
D

dbtarzan

Database browser

Launch
31
M

Mathesar

A self-hosted tool that provides an intuitive, spreadsheet-style interface

Launch
32
C

Chat2DB

DBMS 、BI 、Report 、 NL2SQL、NL2Report

Launch
33
D

DBeaver

Cross-platform database management tool

Launch
34
S

Sqlectron

A simple and lightweight SQL client desktop

Launch
35
P

Pgmetrics

Collect and display information and stats from a running PostgreSQL server

Launch
36
D

DbGate

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

Launch
37
O

Openhare

AI-powered desktop SQL client. Cross-platform. Built with Flutter

Launch
38
J

julien040/anyquery

Query apps with SQL from a single local-first binary

Get
39
C

crystaldba/postgres-mcp

Postgres development and operations: performance analysis

Get
40
R

runekaagaard/mcp-alchemy

Access PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server and more

Get
41
D

DataPup

A modern, AI-assisted, cross-platform database client - free

Launch
42
P

pgAdmin

pgAdmin Website

Launch
43
P

PG Activity

pg_activity is a top like application for PostgreSQL server activity monitoring

Launch
44
S

Sqlchat

Chat-based SQL Client and Editor for the next decade

Launch
45
S

StackRender

Database schema design and SQL migration generator supporting PostgreSQL, MySQL

Launch
46
E

EZQL

Create, store, and edit SQL queries, access data from databases

Launch
47
R

Rainfrog

a database tool for the terminal

Launch
48
F

FreePeak/db-mcp-server

MySQL and PostgreSQL access: query execution, transaction management

Get
49
N

NexusPilot

AI-native cross-platform database workbench for developers and data teams

Launch
50
Z

ZeQLplus

Open Source Terminal SQLite Database Browser

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