This is a Next.js project
PRS Welcome || License MIT
Welcome to PGQL! Our product allows you to seamlessly visualize your SQL database tables and perform edits right in the application. No more writing queries.
Requirements
You'll need a Postgres database with it's respective URI. After logging in, input your URI in the provided space to get started.
That's it!
PostGres-Query-Less(PGQL) is an open-source web application that can be used to connect to any cloud PostgreSQL database to visualize and adjust it’s content. We strive to provide our users with a simple interface to communicate with their cloud databases through onClick functionality. When users make changes in their visualized database, queries are automated to adjust their databases directly in real-time.
Currently the application supports UPDATE and DELETE queries. Once a URI is inputted, our application visualizes all the tables and populates the data into interactive table cells. These cells can be updated, onClick, and once a change is made the user can press ENTER to execute built in queries that update your database in real-time. To delete rows, users can change the primary key value of the target row to “-1” and press ENTER.
Built using:
- React
- NodeJS
- NextJS
- TypeScript
- TailwindCSS
- PostgreSQL
- MongoDB