DEV Community

Cover image for I Built a GitHub Repo Analyzer with FastAPI and PostgreSQL – Live Demo + Source Code
gudhalarya
gudhalarya

Posted on

I Built a GitHub Repo Analyzer with FastAPI and PostgreSQL – Live Demo + Source Code

Have you ever wanted a quick way to analyze any GitHub repository and see things like stars, forks, contributors, and top contributors — all in one place?

I did too. So I built RepoVista — a fully open-source GitHub repo analyzer that gives you visual insights about any public repository.

This was more than just a project — it helped me level up my skills in FastAPI, PostgreSQL, and Docker, and taught me how to turn an idea into a working, sharable product.

What is RepoVista?

RepoVista is a backend-heavy web app that lets you:

Analyze any public GitHub repo

Fetch stars, forks, contributors

Display a “Wall of Fame” with contributor avatars

Deliver real-time data using async API calls

Run everything in Docker with production-ready structure

Why I Built It

I wanted to practice real-world API building, data processing, and backend-first thinking — and also create something that devs can actually use or extend.

This wasn’t just for fun. I treated it like a product:
CI/CD, error handling, database schema design, deployment — all included.

Tech Stack Used

Backend: FastAPI, BeautifulSoup, GitHub API

Database: PostgreSQL

DevOps: Docker, GitHub Actions

Frontend: HTML/CSS (basic — can be extended with React or Next.js)
**
Live Demo + Source Code**

👉 Live Demo: https://repovista.vercel.app
👉 GitHub Repo: https://github.com/DRAKEN-1974/repovista
**
How It Works (Simple Flow)**

User inputs a GitHub repo like vercel/next.js

FastAPI fetches data via GitHub API and scraping

Data is structured and saved to PostgreSQL

Frontend displays stats + contributors in a clean format

Async logic ensures it’s fast, non-blocking, and scalable.

What I Learned While Building It

Async programming and API design with FastAPI

Clean, maintainable database models with PostgreSQL

How to responsibly scrape and use external APIs

Writing Dockerfiles and creating CI pipelines with GitHub Actions

Structuring a full stack backend-first project for real deployment
**
What’s Next?**

I’m working on improving it with:

GitHub OAuth (for private repo analysis)

Time-series charts to show repo growth

Next.js frontend for a more dynamic UI

If anyone wants to collab or fork it — it's all open source and ready to roll.

Let’s Connect!

I’m actively looking for remote internships or freelance work, and I love building clean, useful tools.

Feel free to reach out or connect here:
GitHub: https://github.com/DRAKEN-1974
Email: gudhalarya@gmail.com

Thanks for reading!
If you have ideas, suggestions, or questions, feel free to comment.
And if you’re working on something cool, I’d love to see it too 🚀

Top comments (1)

Collapse
 
gudhalarya profile image
gudhalarya

Dm me if you are intrested in this project