Databae - Cal Hacks 11.0

What is Databae?

• Have you ever had to create an SQL query by hand? You're probably saying, "Do not make me do that!" Well, Databae comes to the rescue!
• Databae is your personal AI assistant when it comes to exploring the complexities of an SQL database. Tell Databae what you want to query your database in plain English, and Databae will automatically query the database and visualize the results for you to understand.

Diagram

Instructions

Frontend

• Install npm
• Change directory into the folder frontend and run npm install to install all the dependencies
• Run the command npm run dev

Backend

• Install Python (minimum version 3.10)
• Install Poetry & Pipx.
• Run poetry shell and poetry install
• Make a .env file consisting to store the Groq API key GROQ_API_KEY=GRAB YOUR API KEY FROM GROQ
• For backend, open up two terminals. Change into the directory folder backend and run uvicorn server:app --reload on terminal 1 and run python agents.py on terminal 2. Depending on your operating system, it could be python or python3.

Use Cases

• Connect to any MySQL database to visualize data
• Generate a pie chart based off data in the database
• Generate a table based off data in the database
• Generate a plaintext response based off data in the database

Audience

Anyone, whether SQL wizards or not, can use it. Type in plain English, and we generate the queries and visualize the data for you.

• Are you in the medical industry? Do you want to visualize the amount of usage of medication A within each age group? Tell Databae!
• Are you in the education industry? Do you want to know the grades of every student? Tell Databae!
• Are you in the music industry? Do you want to make a pie chart that visualizes how many tracks each artist has created? Tell Databae!