Skip to content

Latest commit

 

History

History
64 lines (42 loc) · 1.1 KB

File metadata and controls

64 lines (42 loc) · 1.1 KB

Postgres visual query app

Application that allows users to visually create PostgreSQL SELECT queries.

Functionality

Database

  • View tables in a schema
  • Switch schemas
  • Search for tables

Tables

  • Add/remove tables to/from query
  • Add alias to table
  • Copy tables

Columns

  • Add/remove columns to/from query
  • Add alias to column
  • Add function to column
  • Add filter condition to column
  • DISTINCT ON
  • ORDER BY ASC/DESC
  • GROUP BY
  • Change order of columns
  • Copy columns
  • Switch between displaying and not displaying column in query

Join

  • Join table
  • Change order of joins
  • Add multiple conditions to join

Result

  • View built SQL
  • Run the query and view the results
  • Download generated SQL
  • Download query results

Utility

  • Change the language (English, Estonian)

Setup

The setup for front-end is described at client and back-end at server

Pictures

Login page

Login page image

Query creation page

Query creation page

Licence

MIT