Skill Swap Hub - Database & Portal

The Problem

Peer-to-peer exchange platforms struggle with poor matching performance, database bottlenecks, and data inconsistency when tracking complex multi-user skill exchanges, user reviews, and active swap schedules.

The Solution

Formulated a fully normalized relational database schema in PostgreSQL. Implemented indexes, constraints, and optimized SQL procedures, integrating with an Express backend using Prisma ORM to ensure fast transaction safety and efficient data queries.

Impact & Results

Yields sub-millisecond query response times and absolute data integrity, supporting highly scalable user match-making and smooth search features.