StudioFlow
a full-stack workflow platform for creative teams to manage projects, tasks, comments, and shared assets.
Next.js · React · TypeScript · Node.js · Express · Tailwind CSS · shadcn/ui · Radix UI · Prisma · PostgreSQL · Clerk · Docker · AWS
why i built it
StudioFlow gives creative teams a structured, permissioned workspace for content work — projects, tasks, comments, and shared assets all live in one place, with role-based access control across 3 user roles enforcing who can see and touch what at the API level.
selected details
- designed normalized PostgreSQL schemas with Prisma and implemented role-based access control for 3 user roles, enforcing team and project permissions across API routes
- built 10+ REST API endpoints with validation, error handling, and reusable service logic for projects, tasks, collaboration, and metadata
- optimized project views with server-side filtering, pagination, and tuned Prisma queries to cut down database reads
- containerized the app with Docker and deployed it on AWS