Storefront Copilot

Open-source portfolio project — built with Next.js, Supabase & Gemini

Your store’s catalog, with an AI copilot on top

Storefront Copilot gives merchants a catalog-aware AI assistant, one-click product copywriting, and a live sales dashboard — multi-tenant, secured with Row Level Security, and deployable on free tiers.

Try it with a demo storeView the code

Everything a small store needs from AI

Catalog-aware AI assistant

Ask anything about your products. Questions are embedded with Gemini and matched against your catalog using pgvector cosine search, so answers are grounded in your real data — never invented.

AI product descriptions

Generate on-brand product copy in four tones from a title, category, and a few keywords, or let the AI improve the description you already have.

Sales dashboard

Revenue trend, order volume, average order value, and top products — computed live from your orders with a clean, readable chart.

Multi-tenant by design

Every table is protected by Postgres Row Level Security. Your API routes never leak another merchant's data — the database enforces it.

One-click demo store

Seed a complete outdoor-gear store — 16 products and 60 days of order history — and explore every feature in under a minute.

Free-tier friendly

Runs entirely on free tiers: Supabase (Postgres, Auth, pgvector), Google Gemini, and Vercel. No credit card needed to self-host.

Built on a modern, free stack