Tools → SQL in the sidebar is a visual console for MySQL/MariaDB and PostgreSQL. phpMyAdmin is still there; you just do not need a second window for everyday queries.
What it does
- engine: MySQL/MariaDB or PostgreSQL (Postgres on Pro);
- left: project, database catalog, tables;
- Browse — rows, CRUD, pagination, sort, CSV;
- Structure and Indexes — columns, indexes, foreign keys (full on MySQL; Postgres schema is browse-only for now);
- SQL tab — highlighting, ⌘↩, history and favorites, confirm destructive queries, CSV/JSON export.
Five-minute recipe
- Bring the stack up (Native by default).
- Create or import a PHP project —
macstack/macstackon127.0.0.1:3306. - Open SQL, pick the project and a table.
- One-off query → SQL tab; edit a row → Browse.
CLI if you prefer the terminal:
echo 'SELECT 1' | macstack db-query --name blog --sql - --json
Who it is for
Agencies after a hosting archive: peek at b_option / wp_options, flip one flag, export CSV for the client. Free already includes the SQL console for one PHP project.
MacFullStack
Try it on your Mac
Free — one PHP project and core stack. Pro unlocks Next/Django, Postgres, Share, and unlimited projects.