GitHub User Analyzer

A web app to analyze GitHub user profiles — fetch repos, view language charts, save analysis to a MySQL database, and browse stored results.

• Search any GitHub user by username
• View followers, public repos, and login info
• Fetch all repositories with stars, forks, and language
• Interactive pie chart for language breakdown per repo
• Save analysis data to a MySQL database
• Browse all saved analyses

Make sure you have the following installed:

• Node.js (v18 or above)
• MySQL (v8 or above)
• npm or yarn

/
├── front/         # React + Vite app
│   ├── src/
│   │   ├── Home.jsx
│   │   └── ...
│   └── .env
├── back/          # Express server
│   ├── server.js
│   └── .env
└── README.md

git clone https://github.com/vansh1011/GitHub_Analyzer.git
cd GitHub_Analyzer 

1. Open your MySQL client and create a database:

CREATE DATABASE test;

2. Create the analysis table:

USE test;

CREATE TABLE profiles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    followers INT,
    following INT,
    public_repos INT,
    total_stars INT,
    total_forks INT,
    top_language VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

cd back
npm install

Create a .env file inside the back/ folder:

HOST=mysql_host
USER=mysql_username
PASSWORD=mysql_password
DB = your database
PORT=8000
PORT2 = 4000
FRONTURL = frontend_url

Start the backend server:

node --watch server.js

The server will run at http://localhost:8000

cd front
npm install

Create a .env file inside the front/ folder:

VITE_SERVER=http://localhost:8000

Start the frontend dev server:

npm run dev

The app will run at http://localhost:5173

1. Push your frontend folder to GitHub
2. Import the repo on Vercel
3. Set the environment variable in Vercel dashboard:
   • VITE_SERVER → your backend's live URL
4. Deploy

You can deploy the backend on any Node.js hosting platform such as:

• Render
• Railway
• Cyclic

Make sure to set the same environment variables (HOST, USER, etc.) on the platform.

POSTMAN_COLLECTION

1. Enter a GitHub username in the search box and click Find
2. Click Get All Repos to load the user's repositories
3. Click View Chart on any repo to see a language breakdown pie chart
4. Click Save Analysis to store the user's stats in the database
5. Click Find Analysis or Find All to browse saved data