Automart

An enterprise dealership management system featuring a tool-based streaming AI assistant, a DB-backed 56-permission authorization engine, and a resilient, circuit-breaking cache architecture.

🚧Internal Services Demo Coming Soon!

LIVE

PHOTO

Overview

Automart solves the complex data and operational demands of modern automotive dealerships. Built with Next.js 16 and React 19, the architecture prioritizes high availability, strict security boundaries, and intelligent automation. It secures operations using a hybrid authorization model that supersedes rigid RBAC systems, optimizes performance through data-prefetching and racing cache timeouts, and protects data integrity using isolated database transactions.

Technical Stack

Next.js 16 (App Router)

React 19

TypeScript

PostgreSQL (Neon) with Drizzle ORM

Key Features

Server-defined tools for staff, inventory, customer, notification, and reporting queries via Vercel AI SDK 6 and Google Gemini.
Advanced dynamic SQL report builder featuring automated query joins, aggregations, and strict field-level permission redaction.
Queries execute through tightly-scoped server tools with sandboxed database access, ensuring complete system isolation and safety.
Streams markdown tokens, live tool outputs, and structured source references with full stop-generation capability.

Architectural Highlights

Designed a resilient cache-first architecture utilizing Upstash Redis with 250ms racing timeouts, a 60s circuit breaker, and PostgreSQL fallbacks.
Engineered a tool-based streaming AI architecture leveraging sandboxed server tools and field-level permission redaction for safe data access.
Developed a custom hybrid authorization system handling a 56-permission catalog, role defaults, and per-user allow/deny overrides.
Maintained a verified testing ecosystem containing 87 passing files and 403 active tests via Vitest and strict TypeScript validation.
Built a unified, high-performance data table engine that drives 9 application views with normalized URL paging and debounced filtering.

Project Status

Robust hybrid authorization engine and matrix-view security control panel.
Tool-based AI conversational companion with sandboxed server-tool database access.
Resilient circuit-breaking cache architecture protecting stateful session layers.
Bilingual announcement workflows, CRM customer registries, and VIN-decoding vehicle engines.
Full Vitest suite tracking 403 tests across strict no-emit code baselines.