# captain-coding74/dab architecture

> Architecture diagram of the GitHub repository captain-coding74/dab, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/captain-coding74/dab
- Repository: https://github.com/captain-coding74/dab

## Overview

Data Analysis Bot is a web application for uploading messy, often Thai-exported data and exploring analysis through a React dashboard. The main flow is upload or select a demo dataset, request analysis, and view findings, quality scores, charts, and prompts; signed-in users can also run inferential tests on stored datasets. The README also documents chat, sharing, workspaces, scheduled reports, and privacy-safe telemetry. Several route implementations were not sampled, so those feature links rely on README documentation; the graph avoids asserting unshown internal calls.

Main entry points: [`backend/src/services/analysisPipeline.js`](https://github.com/captain-coding74/dab/blob/main/backend/src/services/analysisPipeline.js) (Analysis Pipeline), [`frontend/src/components/dashboard/index.jsx`](https://github.com/captain-coding74/dab/blob/main/frontend/src/components/dashboard/index.jsx) (Analysis Dashboard), [`frontend/src/hooks/useAnalysis.js`](https://github.com/captain-coding74/dab/blob/main/frontend/src/hooks/useAnalysis.js) (Analysis Actions), [`backend/src/routes/inference.js`](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/inference.js) (Inference Routes)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_frontend["Dashboard"]
  node_dashboard["Analysis Dashboard<br/>[index.jsx]"]
  node_analysis_hook["Analysis Actions<br/>[useAnalysis.js]"]
  node_api_client["API Client<br/>[api.js]"]
  node_app_shell["App Router<br/>[App.jsx]"]
  node_charts["Charts<br/>[index.jsx]"]
  node_chat_ui["Chat Panel<br/>[index.jsx]"]
  node_workspace_ui["Workspace UI<br/>[index.jsx]"]
end

subgraph group_analysis["Analysis Engine"]
  node_analysis_api["Analysis Routes<br/>[analysis.js]"]
  node_demo_api["Demo Routes<br/>[demo.js]"]
  node_pipeline["Analysis Pipeline"]
  node_parser["Streaming Parser<br/>[streaming.js]"]
  node_normalizer["Data Normalization<br/>[normalize.js]"]
  node_insights["Insights Engine<br/>[insights.js]"]
  node_quality["Quality Scoring<br/>[qualityScore.js]"]
  node_prompts["Prompt Suggestions"]
  node_inference_api["Inference Routes<br/>[inference.js]"]
  node_inference["Statistical Tests<br/>[inference.js]"]
end

subgraph group_platform["Accounts and Data"]
  node_server_app["Express App<br/>[app.js]"]
  node_repository["Data Repository<br/>[repository.js]"]
  node_dataset_repo["Dataset Repository"]
  node_database[("SQL Database<br/>[pool.js]")]
  node_object_storage[("File Storage<br/>[storage.js]")]
  node_auth_routes["Authentication<br/>[auth.js]"]
end

subgraph group_collaboration["Team Features"]
  node_chat_routes["Chat API<br/>[chat.js]"]
  node_sharing["Shared Reports<br/>[shares.js]"]
  node_workspaces["Team Workspaces<br/>[workspaces.js]"]
  node_schedules["Scheduled Reports<br/>[scheduler.js]"]
  node_telemetry["Usage Telemetry<br/>[telemetry.js]"]
end

node_user(("Analyst"))

node_user -->|"uses"| node_dashboard
node_dashboard -->|"invokes"| node_analysis_hook
node_analysis_hook -->|"requests through"| node_api_client
node_analysis_hook -->|"uploads for analysis"| node_analysis_api
node_analysis_hook -->|"requests demo"| node_demo_api
node_analysis_api -.->|"runs"| node_pipeline
node_demo_api -.->|"uses"| node_pipeline
node_pipeline -->|"parses rows"| node_parser
node_pipeline -->|"normalizes values"| node_normalizer
node_pipeline -->|"generates findings"| node_insights
node_pipeline -->|"scores quality"| node_quality
node_pipeline -->|"suggests prompts"| node_prompts
node_dashboard -->|"renders charts"| node_charts
node_dashboard -->|"renders panel"| node_chat_ui
node_app_shell -->|"routes to"| node_dashboard
node_app_shell -->|"routes to"| node_workspace_ui
node_server_app -->|"mounts routes"| node_analysis_api
node_server_app -->|"mounts routes"| node_auth_routes
node_server_app -.->|"initializes database"| node_repository
node_repository -->|"queries"| node_database
node_dataset_repo -->|"queries"| node_database
node_dataset_repo -->|"stores files"| node_object_storage
node_inference_api -->|"loads dataset"| node_dataset_repo
node_inference_api -->|"parses stored rows"| node_parser
node_inference_api -->|"runs tests"| node_inference
node_user -.->|"manages teams"| node_workspaces
node_user -.->|"shares reports"| node_sharing
node_user -.->|"chats about data"| node_chat_routes
node_workspaces -.->|"configures reports"| node_schedules
node_user -.->|"contributes usage"| node_telemetry

click node_dashboard "https://github.com/captain-coding74/dab/blob/main/frontend/src/components/dashboard/index.jsx"
click node_analysis_hook "https://github.com/captain-coding74/dab/blob/main/frontend/src/hooks/useAnalysis.js"
click node_api_client "https://github.com/captain-coding74/dab/blob/main/frontend/src/lib/api.js"
click node_app_shell "https://github.com/captain-coding74/dab/blob/main/frontend/src/App.jsx"
click node_charts "https://github.com/captain-coding74/dab/blob/main/frontend/src/components/charts/index.jsx"
click node_chat_ui "https://github.com/captain-coding74/dab/blob/main/frontend/src/components/chat/index.jsx"
click node_workspace_ui "https://github.com/captain-coding74/dab/blob/main/frontend/src/components/workspace/index.jsx"
click node_analysis_api "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/analysis.js"
click node_demo_api "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/demo.js"
click node_pipeline "https://github.com/captain-coding74/dab/blob/main/backend/src/services/analysisPipeline.js"
click node_parser "https://github.com/captain-coding74/dab/blob/main/backend/src/services/streaming.js"
click node_normalizer "https://github.com/captain-coding74/dab/blob/main/backend/src/services/normalize.js"
click node_insights "https://github.com/captain-coding74/dab/blob/main/backend/src/services/insights.js"
click node_quality "https://github.com/captain-coding74/dab/blob/main/backend/src/services/qualityScore.js"
click node_prompts "https://github.com/captain-coding74/dab/blob/main/backend/src/services/promptSuggestions.js"
click node_inference_api "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/inference.js"
click node_inference "https://github.com/captain-coding74/dab/blob/main/backend/src/services/inference.js"
click node_server_app "https://github.com/captain-coding74/dab/blob/main/backend/src/app.js"
click node_repository "https://github.com/captain-coding74/dab/blob/main/backend/src/db/repository.js"
click node_dataset_repo "https://github.com/captain-coding74/dab/blob/main/backend/src/db/datasetRepository.js"
click node_database "https://github.com/captain-coding74/dab/blob/main/backend/src/db/pool.js"
click node_object_storage "https://github.com/captain-coding74/dab/blob/main/backend/src/services/storage.js"
click node_auth_routes "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/auth.js"
click node_chat_routes "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/chat.js"
click node_sharing "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/shares.js"
click node_workspaces "https://github.com/captain-coding74/dab/blob/main/backend/src/routes/workspaces.js"
click node_schedules "https://github.com/captain-coding74/dab/blob/main/backend/src/services/scheduler.js"
click node_telemetry "https://github.com/captain-coding74/dab/blob/main/backend/src/services/telemetry.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dashboard,node_analysis_hook,node_api_client,node_app_shell,node_charts,node_chat_ui,node_workspace_ui toneBlue
class node_analysis_api,node_demo_api,node_pipeline,node_parser,node_normalizer,node_insights,node_quality,node_prompts,node_inference_api,node_inference toneAmber
class node_server_app,node_repository,node_dataset_repo,node_database,node_object_storage,node_auth_routes toneMint
class node_chat_routes,node_sharing,node_workspaces,node_schedules,node_telemetry toneRose
class node_user toneIndigo
```

## Components

### Dashboard

- [Analysis Dashboard](https://github.com/captain-coding74/dab/blob/main/frontend/src/components/dashboard/index.jsx): `frontend/src/components/dashboard/index.jsx`
- [Analysis Actions](https://github.com/captain-coding74/dab/blob/main/frontend/src/hooks/useAnalysis.js): `frontend/src/hooks/useAnalysis.js`
- [API Client](https://github.com/captain-coding74/dab/blob/main/frontend/src/lib/api.js): `frontend/src/lib/api.js`
- [App Router](https://github.com/captain-coding74/dab/blob/main/frontend/src/App.jsx): `frontend/src/App.jsx`
- [Charts](https://github.com/captain-coding74/dab/blob/main/frontend/src/components/charts/index.jsx): `frontend/src/components/charts/index.jsx`
- [Chat Panel](https://github.com/captain-coding74/dab/blob/main/frontend/src/components/chat/index.jsx): `frontend/src/components/chat/index.jsx`
- [Workspace UI](https://github.com/captain-coding74/dab/blob/main/frontend/src/components/workspace/index.jsx): `frontend/src/components/workspace/index.jsx`

### Analysis Engine

- [Analysis Routes](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/analysis.js): `backend/src/routes/analysis.js`
- [Demo Routes](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/demo.js): `backend/src/routes/demo.js`
- [Analysis Pipeline](https://github.com/captain-coding74/dab/blob/main/backend/src/services/analysisPipeline.js): `backend/src/services/analysisPipeline.js`
- [Streaming Parser](https://github.com/captain-coding74/dab/blob/main/backend/src/services/streaming.js): `backend/src/services/streaming.js`
- [Data Normalization](https://github.com/captain-coding74/dab/blob/main/backend/src/services/normalize.js): `backend/src/services/normalize.js`
- [Insights Engine](https://github.com/captain-coding74/dab/blob/main/backend/src/services/insights.js): `backend/src/services/insights.js`
- [Quality Scoring](https://github.com/captain-coding74/dab/blob/main/backend/src/services/qualityScore.js): `backend/src/services/qualityScore.js`
- [Prompt Suggestions](https://github.com/captain-coding74/dab/blob/main/backend/src/services/promptSuggestions.js): `backend/src/services/promptSuggestions.js`
- [Inference Routes](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/inference.js): `backend/src/routes/inference.js`
- [Statistical Tests](https://github.com/captain-coding74/dab/blob/main/backend/src/services/inference.js): `backend/src/services/inference.js`

### Accounts and Data

- [Express App](https://github.com/captain-coding74/dab/blob/main/backend/src/app.js): `backend/src/app.js`
- [Data Repository](https://github.com/captain-coding74/dab/blob/main/backend/src/db/repository.js): `backend/src/db/repository.js`
- [Dataset Repository](https://github.com/captain-coding74/dab/blob/main/backend/src/db/datasetRepository.js): `backend/src/db/datasetRepository.js`
- [SQL Database](https://github.com/captain-coding74/dab/blob/main/backend/src/db/pool.js): `backend/src/db/pool.js`
- [File Storage](https://github.com/captain-coding74/dab/blob/main/backend/src/services/storage.js): `backend/src/services/storage.js`
- [Authentication](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/auth.js): `backend/src/routes/auth.js`

### Team Features

- [Chat API](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/chat.js): `backend/src/routes/chat.js`
- [Shared Reports](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/shares.js): `backend/src/routes/shares.js`
- [Team Workspaces](https://github.com/captain-coding74/dab/blob/main/backend/src/routes/workspaces.js): `backend/src/routes/workspaces.js`
- [Scheduled Reports](https://github.com/captain-coding74/dab/blob/main/backend/src/services/scheduler.js): `backend/src/services/scheduler.js`
- [Usage Telemetry](https://github.com/captain-coding74/dab/blob/main/backend/src/services/telemetry.js): `backend/src/services/telemetry.js`

### Other components

- **Analyst**

## Connections

- Analyst → Analysis Dashboard: uses
- Analysis Dashboard → Analysis Actions: invokes (evidence: `frontend/src/components/dashboard/index.jsx`)
- Analysis Actions → API Client: requests through (evidence: `frontend/src/hooks/useAnalysis.js`)
- Analysis Actions → Analysis Routes: uploads for analysis (evidence: `frontend/src/hooks/useAnalysis.js`)
- Analysis Actions → Demo Routes: requests demo (evidence: `frontend/src/hooks/useAnalysis.js`)
- Analysis Routes → Analysis Pipeline: runs
- Demo Routes → Analysis Pipeline: uses
- Analysis Pipeline → Streaming Parser: parses rows (evidence: `backend/src/services/analysisPipeline.js`)
- Analysis Pipeline → Data Normalization: normalizes values (evidence: `backend/src/services/analysisPipeline.js`)
- Analysis Pipeline → Insights Engine: generates findings (evidence: `backend/src/services/analysisPipeline.js`)
- Analysis Pipeline → Quality Scoring: scores quality (evidence: `backend/src/services/analysisPipeline.js`)
- Analysis Pipeline → Prompt Suggestions: suggests prompts (evidence: `backend/src/services/analysisPipeline.js`)
- Analysis Dashboard → Charts: renders charts (evidence: `frontend/src/components/dashboard/index.jsx`)
- Analysis Dashboard → Chat Panel: renders panel (evidence: `frontend/src/components/dashboard/index.jsx`)
- App Router → Analysis Dashboard: routes to (evidence: `frontend/src/App.jsx`)
- App Router → Workspace UI: routes to (evidence: `frontend/src/App.jsx`)
- Express App → Analysis Routes: mounts routes (evidence: `backend/src/app.js`)
- Express App → Authentication: mounts routes (evidence: `backend/src/app.js`)
- Express App → Data Repository: initializes database (evidence: `backend/src/app.js`)
- Data Repository → SQL Database: queries (evidence: `backend/src/db/repository.js`)
- Dataset Repository → SQL Database: queries (evidence: `backend/src/db/datasetRepository.js`)
- Dataset Repository → File Storage: stores files (evidence: `backend/src/db/datasetRepository.js`)
- Inference Routes → Dataset Repository: loads dataset (evidence: `backend/src/routes/inference.js`)
- Inference Routes → Streaming Parser: parses stored rows (evidence: `backend/src/routes/inference.js`)
- Inference Routes → Statistical Tests: runs tests (evidence: `backend/src/routes/inference.js`)
- Analyst → Team Workspaces: manages teams
- Analyst → Shared Reports: shares reports
- Analyst → Chat API: chats about data
- Team Workspaces → Scheduled Reports: configures reports
- Analyst → Usage Telemetry: contributes usage
