# jainsamyak15/chat-csv architecture

> Architecture diagram of the GitHub repository jainsamyak15/chat-csv, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-05-24). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jainsamyak15/chat-csv
- Repository: https://github.com/jainsamyak15/chat-csv

## Overview

##### Project Type and Purpose
- This is a full-stack, local-only, chat-based data analytics web application.
- Built with Next.js (React + API routes), SQLite (via Prisma), Redis for caching, and a locally hosted LLM (Ollama).
- Users upload CSV files, interact via a chat interface, and view interactive visualizations.

##### File Structure Analysis
- Top-level config: Dockerfile, docker-compose.yml, next.config.mjs, Prisma files under /prisma, Tailwind and PostCSS config.
- Frontend & Backend combined under /src/app:
- React pages/layouts in app/layout.tsx, app/page.tsx, components under /src/components/ui, chat, upload, visualization.
- Next.js API routes in /src/app/api: chat, chat/messages, files, upload, visualization.
- Generated Prisma client under /src/generated/prisma.
- Utility libraries in /src/lib: db client, Redis client, helpers.
- uploads directory holds user CSVs.

##### README Insights
- Describes tech stack, features (CSV management, chat, visualizations), prerequisites, setup steps, API routes, env vars.
- Architecture is monolithic Next.js with integrated API layer, Prisma ORM, local Redis, and external LLM calls to Ollama.

a. Main Components
- User’s Browser (React UI)
- Next.js Server (handles SSR/SSG, routing, API endpoints)
- File Storage (local filesystem: /uploads)
- SQLite Database (persistent storage via Prisma)
- Redis Cache
- Local LLM Service (Ollama)
- Docker Compose (orchestration)

b. Relationships & Data Flows
1. User → Browser: interacts with React UI (pages, chat interface, upload form, visualization panel).
2. Browser → Next.js API: HTTP calls to /api/upload, /api/chat, /api/chat/messages, /api/visualization.
3. /api/upload → saves CSV to local filesystem & writes metadata to SQLite via Prisma.
4. /api/chat → retrieves chat history from SQLite, checks/sets cache in Redis, composes prompt, calls Ollama API, returns LLM response.
5. /api/chat/messages → reads/writes message records in SQLite.
6. /api/visualization → queries processed data (from CSV stored or in-memory), returns chart data to frontend.
7. Next.js ORM layer (Prisma client) ↔ SQLite DB for persistent data.
8. Next.js Redis client ↔ Redis for caching frequent queries or LLM responses.
9. Next.js → Ollama (HTTP) for local LLM inference.

c. Architectural Patterns & Principles
- Layered architecture: Presentation (React), API/Business Logic (Next.js), Data Access (Prisma), Persistence (SQLite/Redis).
- Separation of concerns: file storage vs. structured data in DB; caching layer to improve performance.
- Monolithic service containerized for easy local deployment via Docker Compose.

d. Key Technologies & Frameworks
- Next.js 13+ (App Router, Server Components)
- React + Tailwind CSS
- Prisma ORM → SQLite
- Redis (node-redis)
- Ollama local LLM via REST API
- Docker & Docker Compose

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Presentation Tier
    subgraph "Presentation Tier"
        direction TB
        Browser["User Browser (React UI)"]:::presentation
        Layout["app/layout.tsx"]:::presentation
        Page["app/page.tsx"]:::presentation
        ChatUI["ChatInterface.tsx"]:::presentation
        UploadUI["FileUpload.tsx"]:::presentation
        FileListUI["FileList.tsx"]:::presentation
        VizUI["VisualizationPanel.tsx"]:::presentation
        ButtonUI["button.tsx"]:::presentation
    end

    %% Application Tier
    subgraph "Application Tier (Next.js Server)"
        direction TB
        UploadAPI["/api/upload"]:::app
        FilesAPI["/api/files"]:::app
        ChatAPI["/api/chat"]:::app
        ChatMsgsAPI["/api/chat/messages"]:::app
        VizAPI["/api/visualization"]:::app
        PrismaClient["Prisma Client (src/lib/prisma.ts)"]:::app
        RedisClient["Redis Client (src/lib/redis/client.ts)"]:::app
        DBClient["DB Client Wrapper (src/lib/db/client.ts)"]:::app
        Utils["Utils (src/lib/utils.ts)"]:::app
    end

    %% Data Tier
    subgraph "Data Tier"
        direction TB
        SQLiteDB["SQLite Database (prisma/data.db)"]:::db
        RedisDB["Redis Cache"]:::cache
        UploadsFS["File Storage (uploads/)"]:::storage
    end

    %% External Services
    subgraph "External Services"
        direction TB
        Ollama["Ollama LLM Service"]:::external
    end

    %% Container Orchestration
    subgraph "Container Orchestration"
        direction TB
        DockerCompose["Docker Compose"]:::orchestration
    end

    %% Flows Presentation → Application
    ChatUI -->|"calls API"| ChatAPI
    UploadUI -->|"calls API"| UploadAPI
    FileListUI -->|"calls API"| FilesAPI
    VizUI -->|"calls API"| VizAPI
    Layout -->|"renders UI"| Browser
    Page -->|"renders UI"| Browser
    ButtonUI -->|"UI component"| Browser

    %% Application internal flows
    UploadAPI -->|"writes file"| UploadsFS
    UploadAPI -->|"writes metadata"| PrismaClient
    FilesAPI -->|"reads metadata"| PrismaClient
    ChatAPI -->|"reads/writes msgs"| PrismaClient
    ChatAPI -->|"cache lookup"| RedisClient
    ChatAPI -->|"LLM call"| Ollama
    ChatMsgsAPI -->|"reads/writes msgs"| PrismaClient
    VizAPI -->|"reads data"| PrismaClient

    %% Data access flows
    PrismaClient -->|"connects"| SQLiteDB
    RedisClient -->|"connects"| RedisDB

    %% Cross-cutting utilities
    UploadAPI -->|"uses"| DBClient
    FilesAPI -->|"uses"| DBClient
    ChatAPI -->|"uses"| DBClient
    ChatMsgsAPI -->|"uses"| DBClient
    VizAPI -->|"uses"| DBClient
    UploadAPI -->|"uses"| Utils
    FilesAPI -->|"uses"| Utils
    ChatAPI -->|"uses"| Utils
    ChatMsgsAPI -->|"uses"| Utils
    VizAPI -->|"uses"| Utils

    %% Orchestration links
    DockerCompose -->|network| Browser
    DockerCompose -->|network| UploadAPI
    DockerCompose -->|network| FilesAPI
    DockerCompose -->|network| ChatAPI
    DockerCompose -->|network| ChatMsgsAPI
    DockerCompose -->|network| VizAPI
    DockerCompose -->|network| SQLiteDB
    DockerCompose -->|network| RedisDB
    DockerCompose -->|network| Ollama

    %% Click Events - Presentation
    click Layout "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/layout.tsx"
    click Page "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/page.tsx"
    click ChatUI "https://github.com/jainsamyak15/chat-csv/blob/main/src/components/chat/ChatInterface.tsx"
    click UploadUI "https://github.com/jainsamyak15/chat-csv/blob/main/src/components/upload/FileUpload.tsx"
    click FileListUI "https://github.com/jainsamyak15/chat-csv/blob/main/src/components/upload/FileList.tsx"
    click VizUI "https://github.com/jainsamyak15/chat-csv/blob/main/src/components/visualization/VisualizationPanel.tsx"
    click ButtonUI "https://github.com/jainsamyak15/chat-csv/blob/main/src/components/ui/button.tsx"

    %% Click Events - API
    click UploadAPI "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/api/upload/route.ts"
    click FilesAPI "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/api/files/route.ts"
    click ChatAPI "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/api/chat/route.ts"
    click ChatMsgsAPI "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/api/chat/messages/route.ts"
    click VizAPI "https://github.com/jainsamyak15/chat-csv/blob/main/src/app/api/visualization/route.ts"

    %% Click Events - Prisma
    click PrismaClient "https://github.com/jainsamyak15/chat-csv/blob/main/src/lib/prisma.ts"
    click SQLiteDB "https://github.com/jainsamyak15/chat-csv/blob/main/prisma/data.db"
    click RedisClient "https://github.com/jainsamyak15/chat-csv/blob/main/src/lib/redis/client.ts"
    click DBClient "https://github.com/jainsamyak15/chat-csv/blob/main/src/lib/db/client.ts"
    click Utils "https://github.com/jainsamyak15/chat-csv/blob/main/src/lib/utils.ts"
    click UploadsFS "https://github.com/jainsamyak15/chat-csv/tree/main/uploads/"

    %% Click Events - Orchestration
    click DockerCompose "https://github.com/jainsamyak15/chat-csv/blob/main/docker-compose.yml"

    %% Styles
    classDef presentation fill:#E0F7FA,stroke:#006064,stroke-width:1px
    classDef app fill:#E8F5E9,stroke:#2E7D32,stroke-width:1px
    classDef db fill:#FFF3E0,stroke:#EF6C00,stroke-width:1px
    classDef cache fill:#F3E5F5,stroke:#6A1B9A,stroke-width:1px
    classDef storage fill:#EFEBE9,stroke:#5D4037,stroke-width:1px
    classDef external fill:#EDE7F6,stroke:#4527A0,stroke-width:1px
    classDef orchestration fill:#ECEFF1,stroke:#37474F,stroke-width:1px
```
