SQL PHP

In-app SQL console: no phpMyAdmin for every SELECT

Browse tables, CRUD, destructive-query confirm, CSV — MySQL and Postgres in the sidebar.

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

  1. Bring the stack up (Native by default).
  2. Create or import a PHP project — macstack / macstack on 127.0.0.1:3306.
  3. Open SQL, pick the project and a table.
  4. 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.

Help: /help/tools-overview, /help/mysql-mariadb.

MacFullStack

Try it on your Mac

Free — one PHP project and core stack. Pro unlocks Next/Django, Postgres, Share, and unlimited projects.

Download Free All articles
Download Pro Teams