top of page
msg1205670546-34376 (1).jpg
photo_6070945803884677248_y.jpg

QHACKATHON

Not just a contest  a celebration of Satara’s tech power! 3 Days non stop innovation
Designer (2).jpeg
photo_6190336819447577283_y_edited.png
Overview
msg1205670546-34256-removebg-preview.png

To explore and prototype innovative agentic AI workflows that demonstrate the power of autonomous AI agents working together to solve complex business challenges across fashion technology and enterprise data management.

msg1205670546-34260-removebg-preview.png
Use Cases

SQL Database Chat 

Objective

Enable non-technical users to query relational databases using plain English and get human-friendly insights without writing SQL.

Description

This project uses Generative AI to create an intelligent SQL database assistant. Users can ask natural language questions like "What was the highest sale last month?" and receive both the corresponding SQL query and a natural-language summary of the results. It simplifies data access for business users, analysts, and decision-makers.

Key Features

Natural language to SQL query conversion

Result summarization in plain English

Error handling for ambiguous or invalid queries

ChatGPT_Image_Jul_23,_2025_at_12_23_09_PM 1

Tech Stack

Front End

Streamlit

LLM Framework

LangChain

Pydantic

Rectangle 127

Autogen

LLM Provider

OpenAi

Database

Supabase

Architecture Overview
ChatGPT_Image_Jul_25,_2025_at_12_58_52_PM 1

User inputs question

ChatGPT_Image_Jul_25,_2025_at_12_58_52_PM 2

LangChain processes prompt using LLM

ChatGPT_Image_Jul_25,_2025_at_12_58_52_PM 3

Generates SQL query

ChatGPT_Image_Jul_25,_2025_at_12_58_52_PM 5

Executes on live database

ChatGPT_Image_Jul_25,_2025_at_12_58_52_PM 4

Returns query + natural language result

Benefits

Empowers non-SQL users to interact with data

Saves time for analysts and business users

Reduces reliance on technical teams for routine queries

Bridges the gap between raw data and decision-making

Challenges

Complex query generation (e.g., joins, nested logic)

Schema understanding in large databases

Maintaining SQL safety and injection prevention

Handling vague or overly broad questions

VendorBoard – Smart & Simple Sales Tracker App

Key Features

JWT-based Secure Authentication: Login/signup system to protect user
data.

Sales Entry Panel: Enter product name, quantity, and price with auto-
calculation of totals.

Sales Analytics: Visual insights with graphs and metrics for weekly,
monthly, and yearly sales.

Sales History: Filter and view previous sales with download and edit
functionality.

Excel Report Download: Export filtered sales history as .xlsx files.

Responsive Dashboard: Mobile/tablet-friendly interface with collapsible
sidebar.

Description

VendorBoard is a modern, user-friendly sales tracker that enables users to
record their daily product sales, analyze trends, and download historical data in Excel format. With JWT-based secure login, users access a clean dashboard where they can switch between sales entry, analytics, and history—all optimized for mobile, tablet, and desktop use.

Objective

To develop a responsive and easy-to-use web application for small business owners and shopkeepers to track, manage, and visualize daily sales data with secure authentication and downloadable reports.

ChatGPT Image Aug 1, 2025 at 01_53_45 AM 1
Architecture Overview
image 20

Benefits

Secure Access : JWT ensures only authorized access to user-specific sales data.

Visual Insights : Helps users understand trends, top-selling products and performance.

Historical Tracking : Easily review and manage sales history by date or range.

Downloadable Reports : Quickly export sales data for records or
analysis

Device-Friendly: Fully responsive UI makes it convenient for mobile - first users.

Challenges

Implementing real-time and dynamic updates for charts and history.

Managing complex edits and deletions of specific date-based sales entries.

Ensuring fast and correct Excel generation across filter types.

Maintaining robust security while keeping user experience smooth.

Designing a scalable database schema for long-term data retention.

Artificial intelligence

Web Development
ChatGPT_Image_Jul_23,_2025_at_12_23_09_PM 1

Code Explainer Bot

Description

This project uses Generative AI to build an intelligent assistant that simplifies code comprehension. By integrating GitHub repository parsing with LLM capabilities, the Code Explainer Bot lets users explore files in a project and ask questions like “What does this function do?” or “Can you summarize this code?” The tool delivers natural language explanations, summaries, and suggestions for improvement — perfect for self-learning, code review, or onboarding into new codebases.

Objective

Enable users — especially students, developers, and open-source contributors — to understand unfamiliar codebases by simply providing a GitHub repository link, eliminating the need to manually read and interpret raw code.

Key Features

GitHub repository parsing and code file listing

Code preview with clean formatting

Interactive Q&A on code files (functions, lines, or entire files)

Optional file upload support for local code

Suggestions for improvements and bug detection

File-level and function-level summaries

Tech Stack

OpenAi

black-transparentbg 1

Code Llama

AI Model

Code Display & Interaction

Streamlit code block

dropdowns

tabs

Preprocessing & Analysis

Code cleaning

prompt engineering

GitHub Integration

48152365 1

Front End

Streamlit

Architecture Overview

ChatGPT_Image_Jul_31,_2025_at_12_40_57_PM 4

User inputs GitHub repo URL

ChatGPT_Image_Jul_31,_2025_at_12_40_57_PM 3

System fetches and lists code files

ChatGPT_Image_Jul_31,_2025_at_12_40_57_PM 2

User selects file to
explore

ChatGPT_Image_Jul_31,_2025_at_12_40_57_PM 1

Code is displayed in UI

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 5 1

Returns explanations, summaries, suggestions

ChatGPT_Image_Jul_31,_2025_at_12_48_49_PM 1

LLM processes code + question

ChatGPT_Image_Jul_31,_2025_at_12_40_57_PM

User asks questions

Benefits

Simplifies code understanding for non-expert users

Speeds up onboarding into open-source or team codebases

Encourages independent learning and collaboration

Reduces cognitive load in code reading and documentation

Assists educators, reviewers, and hackathon participants

Challenges

Accurately parsing and filtering code files from varied repositories

Handling large or complex codebases within token limits

Ensuring explanations are precise and technically sound

Managing multiple languages and coding styles

Providing actionable insights (bugs, improvements) without hallucination

Rewards

Frame 90

01

Winner

₹10 lakhs + Paid Project

02

Winner

₹10 lakhs + Paid Project

03

Winner

₹10 lakhs + Paid Project

Smart Interview Simulator

Description

 

This project leverages Generative AI to build a smart interview simulator that reads a user's resume and dynamically generates interview questions tailored to their skills, experience, and the selected job role. Users receive real-time feedback, improvement tips, and a performance report — making it an ideal AI interview coach for career preparation.

Key Features

Resume parsing to extract skills, education, and experience

Personalized questiongeneration using LLM

Real-time answer evaluation and scoring

Feedback on strengths and areas of improvement

Performance summary and downloadable report

Optional voice input for answering questions

Objective

Help students and job seekers practice job interviews by providing personalized, AI-driven mock interviews based on their resumes — anytime, anywhere.

ChatGPT_Image_Jul_31,_2025_at_03_56_42_PM 1

Tech Stack

48152365 1

PyMuPDF

PDF
plumber

1*7oAmMEW4lvpuOARbVJTzrA 1

python-docx

Resume Parsing

Session & Reporting

Streamlit Session
State

_spip-contrib-extensions_fpdf 1

PDF plumber

Voice Input

8d090580-6c9f-11ea-8bdc-70fdb1acf0d5 1

LLM Integration

OpenAi

Front End

Streamlit

Architecture Overview

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 1

User uploads resume

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 2 1

Resume parser extracts key information

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 3 1

User selects job
domain

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 4 1

LLM generates personalized interview questions

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 5 1

Feedback and report are generated

ChatGPT_Image_Jul_30,_2025_at_07_15_59_PM 6 1

AI evaluates and scores the response

User answers via text or voice

Benefits

Makes interview preparation personalized and effective

Enables self-paced practice with real-time feedback

Reduces stress by simulating real interviews

Offers insights on skills and gaps through final report

Encourages iterative improvement and confidence building

Challenges

Parsing unstructured resumes with varying formats

Generating domain-specific, high-quality questions

Evaluating subjective answers with consistent scoring

Managing state and session for multi-turn interactions

Handling multilingual or vague resume inputs

ChatGPT_Image_Jul_23,_2025_at_12_23_09_PM 1

Inventory Management System (CRUD Application using AI)

Objective

Build a lightweight Inventory Management System to allow users to manage products, suppliers, and stock levels in real time.

Description

This CRUD-based app allows small businesses or store owners to track their inventory seamlessly. Users can add, view, update, and delete items, suppliers, and stock levels. 

Key Features

Add New Products with attributes like name, category,price, and stock

View Inventory List with filters for category/stock levels

Update Product Info including quantity and status

Delete Products or Suppliers

Supplier Management: Manage vendors, contacts, and purchase history

Tech Stack

Django

Back End

Django ORM

ORM

Database

Supabase

Front End

Streamlit

Architecture Overview

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 1

User interacts via Stream lit UI  → Adds, updates, or queries product/supplier/stock information in natural language

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 2

LangChain processes the user query using an LLM  → Converts the natural language prompt into an SQL query or relevant instruction

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 3

Generated SQL is executed on the live inventory database  → CRUD operation or data retrieval is performed (e.g., stock check, product update)

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 6

Results are returned to the backend  → Includes raw SQL results (rows, values, messages)

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 5

LangChain LLM generates a natural language response  → Summarizes the result (e.g., "You have 4 products with low stock.")

ChatGPT Image Jul 28, 2025 at 01_52_35 AM 4

Streamlit displays the SQL + natural language result  → Shows query for transparency and AI-generated answer for user clarity

Sample Database Schema

id (int)

name (text)

category (text)

quantity (int)

price (float)

supplier_id (foreign key)


Products Table

Suppliers Table

id (int)

name (text)

contact_email (text)

phone (text)  

Stock Transactions Table 

id

product_id

type (inbound/outbound)

quantity

date


Benefits

Prevents overstocking and understocking

Increases business transparency

Reduces manual effort and paperwork

Enables easy scaling to include more warehouses or products

Challenges

Handling concurrent updates (real-time sync)

Validating supplier-product relationships

Maintaining SQL safety and injection prevention

Maintaining data accuracy during edits or deletes

Technical Requirements

Prevents overstocking and understocking

Increases business transparency

Reduces manual effort and paperwork

Enables easy scaling to include more warehouses or products

Mandatory Requirements

Handling concurrent updates (real-time sync)

Validating supplier-product relationships

Maintaining SQL safety and injection prevention

Maintaining data accuracy during edits or deletes

 Registration Opens​​

31st July 2025

Submit your entries online

Registration Closes

12th August 2025

Last date to Register

Quiz for Shortlisting

14th August 2025

Online quiz for all shortlisted team from registered teams

Final List Announcement

16th August 2025

Top 10 Teams will be announced

Milestone

Date

Description

Hackathon Starts

18th August 2025

After innogration developement starts

Result Day

20th August 2025

Winner team will be announce and Panel discussion starts from 2 pm

Timeline

Timeline

Milestone

Date

Description

Registration Opens

  31st July 2025

                              Submit your entries online

Registration Closes

 12th August 2025

Last date to Register

Quiz for Shortlisting

14th August 2025

            Online quiz for all shortlisted              team from registered teams

Final List Announcement

   16th August 2025

            Top 10 Teams will be announced

Hackathon Starts

                            18th August 2025

After innogration developement starts

       Result Day

      20th August 2025

                 Winner team will be announce and                      Panel discussion starts from 2 pm

Registration Closes

 12th August 2025

Last date to Register

Rewards

Frame 90

01

Winner

Price will reveal soon.........

02

Winner

Price will reveal soon........

Award Ceremony

On the final day of QHackathon 2025, we’ll honor the brightest minds with:

Exciting Cash Prizes (to be revealed live)

Official Certificates of Excellence

Exclusive Mementos from QHills

Timeline

Milestone

Date

Description

Commencement of Innovation Challenge

Date

Official launch and registration opening

Milestone

Date

Description

Milestone

Date

Description

Milestone

Date

Description

Milestone

Date

Description

Milestone

Date

Description

bottom of page