SQL Executor

This project is part of the course CS527 at Rutgers University.

The web application is specifically designed to take user queries as input and seamlessly execute them on our AWS data infrastructure. It establishes connections with MySQL, RedShift, and MongoDB server databases, offering users the flexibility to choose the desired database (Instacart or ADNIMERGE) for query execution. Once the query is submitted, it undergoes processing, and the resulting output is displayed on the intuitive interface for easy user access. Additionally, we have incorporated a convenient feature that allows users to effortlessly view the Entity-Relationship (ER) diagram of the dataset whenever needed.

Installation

A few things are required before getting started with the project:

Java
Gradle
- Installation - https://gradle.org/next-steps/?version=6.9.1&format=all
- Environment Variable Setup - https://stackoverflow.com/a/48033901