GitHub - webofmarius/SQLJoiner: Sql Joiner - Graphical SQL builder and debugger

A visual SQL query builder for MySQL.

Build SELECT queries by dragging tables onto a canvas, connecting them with joins, and setting conditions — all without writing SQL by hand.

Features

• Visual canvas — drag tables from the sidebar onto the canvas, then draw join lines between columns
• Join types — INNER, LEFT, RIGHT, FULL OUTER, CROSS
• SELECT builder — pick columns visually or switch to raw SQL mode; supports column aliases, DISTINCT, custom expressions, and alpha sort
• WHERE / GROUP BY / HAVING / ORDER BY — visual or raw SQL mode for each clause
• Subqueries — add a subquery as a named table on the canvas
• Import SQL — paste an existing query to reverse-engineer it onto the canvas
• Contexts — save and restore canvas states (tables, joins, conditions)
• Notes — attach freeform notes to a context
• Connection profiles — store multiple MySQL connection profiles; switch between them from the top bar
• Query cancellation — cancel a running query mid-execution
• Results grid — paginated results with copy-to-clipboard support
• Canvas search — find tables, aliases, joins, or island labels

Tech stack

Requirements

• PHP 8+ — required (the only hard dependency)
• Node.js + Electron — optional, only needed if you want the desktop app wrapper or to build installers
• Packaged app: PHP binary is bundled (Windows & Mac builds include it under php-bin/)

Getting started

Without Electron (PHP only)

The simplest way to run the app — just PHP:

cd app
php -S localhost:8080

Then open http://localhost:8080 in your browser.

With Electron (desktop app)

Building installers

Requires Node.js.

npm run build:mac    # macOS DMG
npm run build:win    # Windows installer (NSIS)
npm run build:linux  # Linux AppImage

Output goes to dist/.

Project structure

app/
  src/
    Core/       Request, Response, ContextManager, AboutManager
    Database/   Connection (PDO), ProfileManager, SchemaInspector
    Query/      QueryBuilder, QueryParser, JoinClause, WhereClause,
                GroupByClause, HavingClause, OrderByClause
  assets/
    js/         Canvas, joins, islands, autocomplete, undo/redo, results, profiles, api
  storage/      Connection profiles and saved contexts (JSON)
electron/
  main.js       Electron entry — starts the PHP server, opens the window
php-bin/        Bundled PHP binaries (win/, mac/, linux/)

Connection profiles

Profiles are stored in app/storage/profiles.json. Each profile holds host, port, database, user, and password. Manage them via Profiles in the top bar.