# simijain23/insurance-ai-sql-assistant architecture

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

- Interactive diagram: https://gitdiagram.com/simijain23/insurance-ai-sql-assistant
- Repository: https://github.com/simijain23/insurance-ai-sql-assistant

## Overview

Insurance AI SQL Assistant is a Spring Boot backend for natural-language insurance queries and customer data management. Its principal workflow accepts a chat prompt, uses Groq to generate read-only SQL, executes the query against MySQL, and returns results through REST. It also exposes customer management and stores/retrieves chat history. The README documents these capabilities and the high-level flow; source excerpts were not available, so internal call ownership and finer validation details cannot be verified.

Main entry points: [`src/main/java/com/example/demo/ai/GroqController.java`](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/ai/GroqController.java) (REST API), [`src/main/java/com/example/demo/service/SqlQueryService.java`](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/SqlQueryService.java) (SQL Execution), [`src/main/java/com/example/demo/controller/CustomerController.java`](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/controller/CustomerController.java) (Customer API), [`src/main/java/com/example/demo/service/CustomerService.java`](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/CustomerService.java) (Customer Service)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_api["REST and Chat"]
  node_rest["REST API"]
  node_chatdto["Chat DTOs"]
  node_history["Chat History"]
end

subgraph group_query["AI Query Flow"]
  node_groq["Groq LLM"]
  node_queryservice["SQL Execution"]
end

subgraph group_data["Insurance Data"]
  node_mysql[("MySQL")]
  node_customerapi["Customer API"]
  node_customerservice["Customer Service"]
  node_customerrepo[("Customer Repository")]
  node_policyrepo[("Policy Repository")]
  node_entities["Insurance Entities"]
end

subgraph group_support["Application Support"]
  node_config["App Configuration<br/>[AppConfig.java]"]
  node_errors["Exception Handling"]
end

node_user(("User"))

node_user -->|"sends prompt"| node_rest
node_rest -->|"requests SQL"| node_groq
node_groq -->|"generates SQL"| node_queryservice
node_queryservice -->|"executes read-only"| node_mysql
node_mysql -->|"returns results"| node_rest
node_rest -->|"uses DTOs"| node_chatdto
node_rest -->|"stores and retrieves"| node_history
node_user -->|"creates customer"| node_customerapi
node_customerapi -.->|"delegates"| node_customerservice
node_customerservice -.->|"uses repository"| node_customerrepo
node_customerrepo -.->|"persists data"| node_mysql
node_policyrepo -.->|"accesses data"| node_mysql
node_mysql -.->|"stores records"| node_entities

click node_rest "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/ai/GroqController.java"
click node_chatdto "https://github.com/simijain23/insurance-ai-sql-assistant/tree/main/src/main/java/com/example/demo/dto"
click node_history "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/ChatHistoryRepository.java"
click node_queryservice "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/SqlQueryService.java"
click node_customerapi "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/controller/CustomerController.java"
click node_customerservice "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/CustomerService.java"
click node_customerrepo "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/CustomerRepository.java"
click node_policyrepo "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/PolicyRepository.java"
click node_entities "https://github.com/simijain23/insurance-ai-sql-assistant/tree/main/src/main/java/com/example/demo/entity"
click node_config "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/config/AppConfig.java"
click node_errors "https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/exception/GlobalExceptionHandler.java"

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_rest,node_chatdto,node_history,node_user toneBlue
class node_groq,node_queryservice toneAmber
class node_mysql,node_customerapi,node_customerservice,node_customerrepo,node_policyrepo,node_entities toneMint
class node_config,node_errors toneRose
```

## Components

### REST and Chat

- [REST API](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/ai/GroqController.java): `src/main/java/com/example/demo/ai/GroqController.java`
- [Chat DTOs](https://github.com/simijain23/insurance-ai-sql-assistant/tree/main/src/main/java/com/example/demo/dto): `src/main/java/com/example/demo/dto`
- [Chat History](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/ChatHistoryRepository.java): `src/main/java/com/example/demo/repository/ChatHistoryRepository.java`

### AI Query Flow

- **Groq LLM**
- [SQL Execution](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/SqlQueryService.java): `src/main/java/com/example/demo/service/SqlQueryService.java`

### Insurance Data

- **MySQL**
- [Customer API](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/controller/CustomerController.java): `src/main/java/com/example/demo/controller/CustomerController.java`
- [Customer Service](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/service/CustomerService.java): `src/main/java/com/example/demo/service/CustomerService.java`
- [Customer Repository](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/CustomerRepository.java): `src/main/java/com/example/demo/repository/CustomerRepository.java`
- [Policy Repository](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/repository/PolicyRepository.java): `src/main/java/com/example/demo/repository/PolicyRepository.java`
- [Insurance Entities](https://github.com/simijain23/insurance-ai-sql-assistant/tree/main/src/main/java/com/example/demo/entity): `src/main/java/com/example/demo/entity`

### Application Support

- [App Configuration](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/config/AppConfig.java): `src/main/java/com/example/demo/config/AppConfig.java`
- [Exception Handling](https://github.com/simijain23/insurance-ai-sql-assistant/blob/main/src/main/java/com/example/demo/exception/GlobalExceptionHandler.java): `src/main/java/com/example/demo/exception/GlobalExceptionHandler.java`

### Other components

- **User**

## Connections

- User → REST API: sends prompt (evidence: `README.md`)
- REST API → Groq LLM: requests SQL (evidence: `README.md`)
- Groq LLM → SQL Execution: generates SQL (evidence: `README.md`)
- SQL Execution → MySQL: executes read-only (evidence: `README.md`)
- MySQL → REST API: returns results (evidence: `README.md`)
- REST API → Chat DTOs: uses DTOs (evidence: `README.md`)
- REST API → Chat History: stores and retrieves (evidence: `README.md`)
- User → Customer API: creates customer (evidence: `README.md`)
- Customer API → Customer Service: delegates
- Customer Service → Customer Repository: uses repository
- Customer Repository → MySQL: persists data
- Policy Repository → MySQL: accesses data
- MySQL → Insurance Entities: stores records
