The PetrolPump Management System is a Python-based web application that gives petrol pump operators a clean, browser-based interface to manage every aspect of their business. Built with Streamlit for the frontend and MySQL for the backend, it supports full Create, Read, Update, and Delete (CRUD) operations across six core entities, and exposes advanced database features such as triggers, stored functions, and custom SQL queries.Documentation Index
Fetch the complete documentation index at: https://mintlify.com/Adarsh275/PetrolPump-Management-System/llms.txt
Use this file to discover all available pages before exploring further.
Introduction
Learn what the system does, its architecture, and how its components fit together.
Quickstart
Set up MySQL, install dependencies, and launch the app in minutes.
Database Schema
Explore every table, column, and data type in the MySQL schema.
User Guide
Step-by-step instructions for each entity’s CRUD screens.
What you can do
Manage Pumps
Register and update petrol pump stations with company and location details.
Track Employees
Add staff, assign designations, and manage salaries with automatic validation.
Handle Customers
Maintain a customer registry linked to fuel invoices.
Issue Invoices
Record fuel sales by type, volume, discount, and payment method.
Monitor Tankers
Track tanker capacity, pressure, fuel type, and calculate total fuel value.
Advanced Queries
Run custom SQL directly from the UI or call the TOTAL_AMOUNT function.
Get started in four steps
Install Python dependencies
Install
streamlit, mysql-connector-python, and pandas from your terminal.Populate the schema
Execute
Backend/create_table.sql in MySQL Workbench or the CLI to create all tables and seed sample data.The system uses a local MySQL connection by default (
localhost, user root, empty password). Update the credentials in Project/database.py before deploying to any shared environment.