ez-ql is a point-and-click desktop GUI for querying PostgreSQL databases intended for non-technical business users.

Step-by-step query-builder allowing for the following SQL operations: join, aggregate, filter, sort, groupby
Built with Electron.js, boostrapped with Create-React-App
Packages and libraries: squel.js, node-postgres, MaterialUI

Requirements

Available Scripts

In the project directory, you can run:

Runs installation of all dependencies listed in package.json. Required for the following two scripts.

Runs the app in the development mode.
Will open a Chromium Browser Window instance serving on [http://localhost:3000 (http://localhost:3000)].

If you make edits to the code while the window is open, type Ctrl-Shift-R to refresh the window.
You will also see any lint errors in the console.

Builds the app for production to the build folder.
Also generates distributable binaries to install the app to local OS in the dist folder.

Building on a Mac will generate a standard .dmg file.

Building on Linux will generate a .AppImage file.

You can install and open either of these files by double-clicking them in your file explorer GUI or from a terminal by running
./.ez-ql...