Skip to content

Erikdzo/postgres-visual-query-app

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

61 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Application for creating PostgreSQL queries

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages