# sourabh-virdi/ai-data-analyst architecture

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

- Interactive diagram: https://gitdiagram.com/sourabh-virdi/ai-data-analyst
- Repository: https://github.com/sourabh-virdi/ai-data-analyst

## Overview

AI-Powered Data Analyst exposes data access, analysis, and visualization through an MCP server for LLM clients. The principal workflow is a client request routed through MCP tools to locate or load data, analyze it, and return results; charting is a parallel output capability. The repository also documents SQL, file, and REST API sources, plus Snowflake support. Source excerpts show the connector and tool layers, but not all wiring between server tools and analysis implementations, so some documented relationships are cited to the README and uncertain integrations are marked optional.

Main entry points: [`src/mcp_server/server.py`](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/mcp_server/server.py) (MCP Server), [`src/tools/data_tools.py`](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/data_tools.py) (Data Tools), [`src/data_sources/database_connector.py`](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/database_connector.py) (SQL Connectors), [`src/data_sources/file_reader.py`](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/file_reader.py) (File Reader)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_entry["MCP Access"]
  node_server["MCP Server<br/>[server.py]"]
  node_main["Server Entry<br/>[main.py]"]
end

subgraph group_data["Data Access"]
  node_data_tools["Data Tools<br/>[data_tools.py]"]
  node_db_connector["SQL Connectors"]
  node_file_reader["File Reader<br/>[file_reader.py]"]
  node_config["Configuration<br/>[config_manager.py]"]
end

subgraph group_insights["Analytics"]
  node_analysis_tools["Analysis Tools<br/>[analysis_tools.py]"]
  node_stat_engine["Statistical Engine"]
  node_visual_tools["Visualization Tools"]
  node_logger["Structured Logging<br/>[logger.py]"]
end

node_client(("LLM Client"))
node_sql_sources[("SQL Sources")]
node_file_sources["CSV Excel JSON"]
node_api_sources["REST APIs"]

node_client -->|"sends requests"| node_server
node_main -->|"runs"| node_server
node_server -.->|"routes data tools"| node_data_tools
node_server -.->|"routes analysis"| node_analysis_tools
node_server -.->|"routes visualization"| node_visual_tools
node_data_tools -->|"uses"| node_db_connector
node_data_tools -->|"uses"| node_file_reader
node_db_connector -->|"queries"| node_sql_sources
node_file_reader -->|"reads"| node_file_sources
node_data_tools -.->|"may access"| node_api_sources
node_analysis_tools -.->|"may use"| node_stat_engine
node_analysis_tools -.->|"loads data"| node_data_tools
node_db_connector -->|"reads settings"| node_config
node_file_reader -->|"reads settings"| node_config
node_db_connector -->|"logs operations"| node_logger
node_file_reader -->|"logs reads"| node_logger

click node_server "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/mcp_server/server.py"
click node_main "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/main.py"
click node_data_tools "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/data_tools.py"
click node_db_connector "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/database_connector.py"
click node_file_reader "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/file_reader.py"
click node_analysis_tools "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/analysis_tools.py"
click node_stat_engine "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/analytics/statistical_engine.py"
click node_visual_tools "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/visualization_tools.py"
click node_config "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/utils/config_manager.py"
click node_logger "https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/utils/logger.py"

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_server,node_main,node_client toneBlue
class node_data_tools,node_db_connector,node_file_reader,node_config,node_sql_sources toneAmber
class node_analysis_tools,node_stat_engine,node_visual_tools,node_logger,node_api_sources toneMint
class node_file_sources toneIndigo
```

## Components

### MCP Access

- [MCP Server](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/mcp_server/server.py): `src/mcp_server/server.py`
- [Server Entry](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/main.py): `src/main.py`

### Data Access

- [Data Tools](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/data_tools.py): `src/tools/data_tools.py`
- [SQL Connectors](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/database_connector.py): `src/data_sources/database_connector.py`
- [File Reader](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/data_sources/file_reader.py): `src/data_sources/file_reader.py`
- [Configuration](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/utils/config_manager.py): `src/utils/config_manager.py`

### Analytics

- [Analysis Tools](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/analysis_tools.py): `src/tools/analysis_tools.py`
- [Statistical Engine](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/analytics/statistical_engine.py): `src/analytics/statistical_engine.py`
- [Visualization Tools](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/tools/visualization_tools.py): `src/tools/visualization_tools.py`
- [Structured Logging](https://github.com/sourabh-virdi/ai-data-analyst/blob/main/src/utils/logger.py): `src/utils/logger.py`

### Other components

- **LLM Client**
- **SQL Sources**
- **CSV Excel JSON**
- **REST APIs**

## Connections

- LLM Client → MCP Server: sends requests (evidence: `README.md`)
- Server Entry → MCP Server: runs (evidence: `src/main.py`)
- MCP Server → Data Tools: routes data tools (evidence: `README.md`)
- MCP Server → Analysis Tools: routes analysis (evidence: `README.md`)
- MCP Server → Visualization Tools: routes visualization (evidence: `README.md`)
- Data Tools → SQL Connectors: uses (evidence: `src/tools/data_tools.py`)
- Data Tools → File Reader: uses (evidence: `src/tools/data_tools.py`)
- SQL Connectors → SQL Sources: queries (evidence: `src/data_sources/database_connector.py`)
- File Reader → CSV Excel JSON: reads (evidence: `src/data_sources/file_reader.py`)
- Data Tools → REST APIs: may access (evidence: `README.md`)
- Analysis Tools → Statistical Engine: may use
- Analysis Tools → Data Tools: loads data
- SQL Connectors → Configuration: reads settings (evidence: `src/data_sources/database_connector.py`)
- File Reader → Configuration: reads settings (evidence: `src/data_sources/file_reader.py`)
- SQL Connectors → Structured Logging: logs operations (evidence: `src/data_sources/database_connector.py`)
- File Reader → Structured Logging: logs reads (evidence: `src/data_sources/file_reader.py`)
