Full-Stack RAG App for Cited, Multi-Tenant Document Q&AFull-Stack RAG App for Cited, Multi-Tenant Document Q&A
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
A full-stack RAG application that answers questions from a team's own documents, with every answer cited to the source document and page. I designed, built, tested and deployed it end to end:
document ingestion with content-based file validation;
semantic search with PostgreSQL + pgvector;
streaming answers over Server-Sent Events, with server-side citation verification;
multi-tenant workspaces with role-based access;
usage metering with quotas and a cost dashboard;
a crash-safe PostgreSQL job queue.
Deployed as a public demo on free tiers (Vercel, Render, Supabase) with hard caps on AI spend. Citations verified against the retrieved passages; unsupported answers return "not found"
Tenant isolation in every query; Supabase Data API locked down (verified on production)
Durable ingestion queue (SKIP LOCKED, leases, retries): kill -9 under load lost nothing
Costs reserved before every AI call; per-user, per-workspace and deployment-wide caps
Data-driven model migration (5 configurations evaluated; about 74% cheaper per answer)
1,099 backend + 393 frontend tests; load-tested; encrypted, restore-verified backups https://knowledgepilot-ai-olive.vercel.app/
Maksim's avatar
IDM logo
The reservation before the AI call is the detail most teams miss: you can add cost metering later, but you cannot un-spend the money after a runaway loop. On the crash-safe queue, with SKIP LOCKED plus leases, what happens to a lease held by a worker that is alive but stuck, do...
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started