Employee Management System

A simple web application for managing employee records built with FastAPI and Streamlit.

Features

• Add new employees
• View all employees
• Search and filter employees
• Update employee details
• Delete employees
• Bulk delete operations

Tech Stack

• Backend: FastAPI + SQLAlchemy
• Frontend: Streamlit
• Database: SQLite

Project Structure

employee_management_system/
├── backend/
│   ├── main.py              # FastAPI app
│   ├── database_setup.py    # Database configuration
│   ├── models.py            # Database models
│   ├── schemas.py           # Pydantic schemas
│   └── crud.py              # CRUD operations
├── frontend/
│   └── app.py               # Streamlit app
└── README.md

Installation

1. Clone the repository

git clone <your-repo-url>
cd employee_management_system

2. Install dependencies

pip install fastapi uvicorn sqlalchemy pydantic streamlit requests pandas

How to Run

Step 1: Start Backend (FastAPI)

cd backend
uvicorn main:app --reload

Backend will run on: http://localhost:8000

Step 2: Start Frontend (Streamlit)

Open a new terminal:

cd frontend
streamlit run app.py

Frontend will run on: http://localhost:8501

Login Credentials

• Email: subha@demo.com
• Password: demo123

Usage

1. Login with the demo credentials
2. Go to "Employee" menu
3. Use "Add Employee" tab to add new employees
4. View all employees in "View Employees" tab
5. Search and filter employees in "Search & Filter" tab
6. Delete employees by entering their ID

API Documentation

Once backend is running, visit:

• Swagger UI: http://localhost:8000/docs
• ReDoc: http://localhost:8000/redoc

Author

Subham Maharana

License

This project is for educational purposes.