—tRPC API Layer — End-to-end type-safe API with 20+ routers and 150+ procedures, TanStack Query for server state with optimistic updates.
—Go VIN Decoder — Gin HTTP service backed by a ~2GB local SQLite database (~1.6M pattern rows, ~8.7M valid-character rows). Multi-pass VDS pattern matching, check-digit validation, auto-correction for single-character errors.
—AI System — Natural language → DSL query builder with tenant-scoped execution, risk classification for write operations, approval token workflow for destructive actions, streaming chat via OpenRouter proxy.
—Real-time Collaboration — TipTap editor with extensions (code blocks, tables, task lists, KaTeX math, Mermaid diagrams), Yjs CRDT for conflict-free concurrent editing, Supabase Realtime as transport layer.
—Multi-Tenancy — PostgreSQL Row-Level Security on 30+ tables, tenant isolation via tenant_id scoping, role-based access control (admin, manager, tech, detailer, read_only).
—Runlist Upload — Streaming CSV processing with constant memory usage, dynamic column-to-field mapping, 500-record batch inserts with atomic guarantees — auto-deletes orphaned records on link failure.