alvinquach
Alvin

Alvin

I’m a full stack engineer with a strong foundation in building performant, scalable, and user-centric web applications. My technical skillset spans modern front-end frameworks like React and Next.js, to robust back-end technologies such as FastAPI, Node.js, and GraphQL. I have hands-on experience designing full-stack applications from scratch, integrating third-party services, optimizing performance, and implementing end-to-end testing for production readiness.

My approach balances thoughtful UI/UX design with technical architecture that prioritizes maintainability and performance. I thrive in collaborative environments and value clean, well-documented code that scales with the product.

Whether it’s implementing real-time features, building AI-assisted tools, integrating payment systems, or visualizing complex datasets, I bring a detail-oriented mindset and a user-first perspective to every project.

With a diverse professional background that includes front-end engineering, DevOps support, product coordination, and technical community management, I bring both the technical acumen and cross-functional communication skills that help projects move forward efficiently and successfully.

My Skills

Explore the skills that power my work and creativity.

Supabase
Supabase
PostgreSQL
PostgreSQL
MySQL
MySQL
SQLite
SQLite
Drizzle
Drizzle
MongoDB
MongoDB
Firebase Realtime Database
Firebase Realtime Database
Prisma
Prisma
TypeScript
TypeScript
Python
Python
FastAPI
FastAPI
spaCy
spaCy
Express.js
Express.js
Node.js
Node.js
AWS S3
AWS S3
Docker
Docker
Jest
Jest
Cypress
Cypress
Playwright
Playwright
GSAP
GSAP
Bash
Bash
Linux
Linux
Git
Git
Mapbox
Mapbox
Twilio
Twilio
Stripe
Stripe
Figma
Figma
TailwindCSS
TailwindCSS
Material UI
Material UI
Salesforce
Salesforce
Supabase
Supabase
PostgreSQL
PostgreSQL
MySQL
MySQL
SQLite
SQLite
Drizzle
Drizzle
MongoDB
MongoDB
Firebase Realtime Database
Firebase Realtime Database
Prisma
Prisma
TypeScript
TypeScript
Python
Python
FastAPI
FastAPI
spaCy
spaCy
Express.js
Express.js
Node.js
Node.js
AWS S3
AWS S3
Docker
Docker
Jest
Jest
Cypress
Cypress
Playwright
Playwright
GSAP
GSAP
Bash
Bash
Linux
Linux
Git
Git
Mapbox
Mapbox
Twilio
Twilio
Stripe
Stripe
Figma
Figma
TailwindCSS
TailwindCSS
Material UI
Material UI
Salesforce
Salesforce

Projects

Main image for Play Plan Craft

Play Plan Craft

Built an AI-powered teaching assistant that helps educators create personalized, developmentally appropriate lesson plans tailored to specific age groups and subjects. Streamlines planning with integrated lesson scheduling via Google Calendar and iCal sync, and automatically generates shopping links for required materials. It also supports real-time collaboration between teachers, co-teachers, and assistants, making it easy to plan and coordinate lessons together.

TypeScriptNext.jsOpenAISupabaseApollo ClientApollo ServerGraphql-yogaDrizzle
Main image for Hone Your Craft

Hone Your Craft

Developed a full-stack recruitment platform featuring a FastAPI backend with spaCy-powered NLP for intelligent skill extraction from job descriptions. Designed a hybrid rule-based and embedding-driven keyword matching engine using custom EntityRuler patterns and word vector similarity, integrated with MongoDB and Prisma ORM. Enabled real-time application tracking via AWS S3 and D3.js dashboards visualizing interview pipelines and skill alignment metrics. Enhanced UX with a Kanban-style drag-and-drop board using hello-pangea/dnd.

PythonTypeScriptNext.jsFastAPIspaCyMongoDBPrismaD3.jsDocker
Main image for SculptQL

SculptQL

Developed a privacy-first SQL CLI and web interface supporting MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Built a context-aware autocomplete engine with syntax highlighting for faster query composition. Implemented query history with local storage to enable offline persistence without a backend. Added export capabilities (CSV, JSON, Markdown) and data visualization with D3.js for immediate insights. Designed an intuitive, real-time query builder combining CLI flexibility with a modern GUI.

TypeScriptReactNext.jsCodemirrorD3.jsGraphQL

Blogs

Featured
Featured
Your Gateway to Mastering SQL Querying

Your Gateway to Mastering SQL Querying

SculptQL is a friendly tool that turns your terminal into a web-based playground for learning PostgreSQL queries with one command. Featuring an intuitive interface with autocomplete, a data explorer, and query history saved to JSON, it’s perfect for beginners, teachers, or anyone eager to dive into SQL. In this post, I’ll guide you through the basics of querying with SculptQL, share a hands-on demo, and show how it makes learning SQL a fun, visual adventure!

PostgresSupabaseSQLCLINext.js
Read More