# vikash-vk/ai-ecommerce-operations-platform architecture

> Architecture diagram of the GitHub repository vikash-vk/ai-ecommerce-operations-platform, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/vikash-vk/ai-ecommerce-operations-platform
- Repository: https://github.com/vikash-vk/ai-ecommerce-operations-platform

## Overview

ShopKart Operations Assistant is a unified Streamlit interface for business-data questions, uploaded-PDF search, membership prediction, and BI report access. The main flow is a user request through the app’s agent to a selected tool, then to SQL generation/execution, document retrieval, or model inference. A separate data-preparation stage cleans CSVs and builds the SQLite database. The dashboard is provided as Power BI files. Relationships reflect the excerpts and README; unsampled dashboard internals and model training details are not inferred.

Main entry points: [`app.py`](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/app.py) (Streamlit assistant), [`tools/database_query.py`](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/database_query.py) (Database query tool), [`database/connection.py`](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/connection.py) (SQLite connection), [`database/create_database.py`](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/create_database.py) (Database builder)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_interface["Assistant interface"]
  node_app["Streamlit assistant<br/>[app.py]"]
  node_config["LLM configuration<br/>[config.py]"]
end

subgraph group_analytics["Database analytics"]
  node_dbtool["Database query tool<br/>[database_query.py]"]
  node_schema["Schema discovery<br/>[schema.py]"]
  node_sqlgen["SQL generation<br/>[llm.py]"]
  node_executor["SQL execution<br/>[execute.py]"]
  node_connection["SQLite connection<br/>[connection.py]"]
  node_store[("ShopKart database<br/>[shopkart.db]")]
end

subgraph group_documents["Document search"]
  node_pdf_tool["PDF search tool<br/>[pdf_search.py]"]
  node_indexer["PDF indexing<br/>[embeddings.py]"]
  node_pdfs["PDF documents"]
end

subgraph group_prediction["Membership prediction"]
  node_membership_tool["Membership prediction"]
  node_model[("Trained model")]
end

subgraph group_data["Data and reporting"]
  node_builder["Database builder<br/>[create_database.py]"]
  node_etl["CSV cleaning<br/>[etl.py]"]
  node_rawdata["Raw business CSVs"]
  node_schemafile["Database schema<br/>[schema.sql]"]
  node_dashboard["Power BI reports"]
end

node_user(("Business user"))

node_user -->|"asks"| node_app
node_app -->|"configures model"| node_config
node_app -->|"dispatches queries"| node_dbtool
node_app -->|"dispatches search"| node_pdf_tool
node_app -->|"dispatches prediction"| node_membership_tool
node_app -->|"indexes uploads"| node_indexer
node_dbtool -->|"gets schema"| node_schema
node_dbtool -->|"generates SQL"| node_sqlgen
node_dbtool -->|"executes SQL"| node_executor
node_schema -->|"opens connection"| node_connection
node_executor -->|"opens connection"| node_connection
node_sqlgen -->|"uses model settings"| node_config
node_connection -->|"connects to"| node_store
node_pdf_tool -->|"searches vectors"| node_indexer
node_indexer -->|"indexes uploaded files"| node_pdfs
node_membership_tool -->|"loads model"| node_model
node_builder -->|"loads cleaned data"| node_etl
node_builder -->|"creates database"| node_connection
node_builder -->|"executes schema"| node_schemafile
node_etl -->|"reads CSVs"| node_rawdata
node_app -->|"offers report downloads"| node_dashboard

click node_app "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/app.py"
click node_config "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/config.py"
click node_dbtool "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/database_query.py"
click node_schema "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/schema.py"
click node_sqlgen "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/llm.py"
click node_executor "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/execute.py"
click node_connection "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/connection.py"
click node_store "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/shopkart.db"
click node_pdf_tool "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/pdf_search.py"
click node_indexer "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/rag/embeddings.py"
click node_pdfs "https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/data/pdfs"
click node_membership_tool "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/membership_prediction.py"
click node_model "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/models/membership_model.pkl"
click node_builder "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/create_database.py"
click node_etl "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/etl.py"
click node_rawdata "https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/data/raw"
click node_schemafile "https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/schema.sql"
click node_dashboard "https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/Dashboard"

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_app,node_config,node_user toneBlue
class node_dbtool,node_schema,node_sqlgen,node_executor,node_connection,node_store toneAmber
class node_pdf_tool,node_indexer,node_pdfs toneMint
class node_membership_tool,node_model toneRose
class node_builder,node_etl,node_rawdata,node_schemafile,node_dashboard toneIndigo
```

## Components

### Assistant interface

- [Streamlit assistant](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/app.py): `app.py`
- [LLM configuration](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/config.py): `config.py`

### Database analytics

- [Database query tool](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/database_query.py): `tools/database_query.py`
- [Schema discovery](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/schema.py): `database/schema.py`
- [SQL generation](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/llm.py): `database/llm.py`
- [SQL execution](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/execute.py): `database/execute.py`
- [SQLite connection](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/connection.py): `database/connection.py`
- [ShopKart database](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/shopkart.db): `database/shopkart.db`

### Document search

- [PDF search tool](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/pdf_search.py): `tools/pdf_search.py`
- [PDF indexing](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/rag/embeddings.py): `rag/embeddings.py`
- [PDF documents](https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/data/pdfs): `data/pdfs`

### Membership prediction

- [Membership prediction](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/tools/membership_prediction.py): `tools/membership_prediction.py`
- [Trained model](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/models/membership_model.pkl): `models/membership_model.pkl`

### Data and reporting

- [Database builder](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/create_database.py): `database/create_database.py`
- [CSV cleaning](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/etl.py): `database/etl.py`
- [Raw business CSVs](https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/data/raw): `data/raw`
- [Database schema](https://github.com/vikash-vk/ai-ecommerce-operations-platform/blob/main/database/schema.sql): `database/schema.sql`
- [Power BI reports](https://github.com/vikash-vk/ai-ecommerce-operations-platform/tree/main/Dashboard): `Dashboard`

### Other components

- **Business user**

## Connections

- Business user → Streamlit assistant: asks (evidence: `README.md`)
- Streamlit assistant → LLM configuration: configures model (evidence: `app.py`)
- Streamlit assistant → Database query tool: dispatches queries (evidence: `app.py`)
- Streamlit assistant → PDF search tool: dispatches search (evidence: `app.py`)
- Streamlit assistant → Membership prediction: dispatches prediction (evidence: `app.py`)
- Streamlit assistant → PDF indexing: indexes uploads (evidence: `app.py`)
- Database query tool → Schema discovery: gets schema (evidence: `tools/database_query.py`)
- Database query tool → SQL generation: generates SQL (evidence: `tools/database_query.py`)
- Database query tool → SQL execution: executes SQL (evidence: `tools/database_query.py`)
- Schema discovery → SQLite connection: opens connection (evidence: `database/schema.py`)
- SQL execution → SQLite connection: opens connection (evidence: `database/execute.py`)
- SQL generation → LLM configuration: uses model settings (evidence: `database/llm.py`)
- SQLite connection → ShopKart database: connects to (evidence: `database/connection.py`)
- PDF search tool → PDF indexing: searches vectors (evidence: `tools/pdf_search.py`)
- PDF indexing → PDF documents: indexes uploaded files
- Membership prediction → Trained model: loads model (evidence: `tools/membership_prediction.py`)
- Database builder → CSV cleaning: loads cleaned data (evidence: `database/create_database.py`)
- Database builder → SQLite connection: creates database (evidence: `database/create_database.py`)
- Database builder → Database schema: executes schema (evidence: `database/create_database.py`)
- CSV cleaning → Raw business CSVs: reads CSVs (evidence: `database/etl.py`)
- Streamlit assistant → Power BI reports: offers report downloads (evidence: `app.py`)
