How sourabh-virdi/ai-data-analyst works
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: server.py MCP Server · data_tools.py Data Tools · database_connector.py SQL Connectors · file_reader.py File Reader
Components 14
MCP Access
- MCP Server
src/mcp_server/server.py - Server Entry
src/main.py
Data Access
- Data Tools
src/tools/data_tools.py - SQL Connectors
src/data_sources/database_connector.py - File Reader
src/data_sources/file_reader.py - Configuration
src/utils/config_manager.py
Analytics
- Analysis Tools
src/tools/analysis_tools.py - Statistical Engine
src/analytics/statistical_engine.py - Visualization Tools
src/tools/visualization_tools.py - Structured Logging
src/utils/logger.py
Other components
- LLM Client
- SQL Sources
- CSV Excel JSON
- REST APIs
Connections 16
- LLM Client → MCP Server: sends requests
README.md - Server Entry → MCP Server: runs
src/main.py - MCP Server → Data Tools: routes data tools
README.md - MCP Server → Analysis Tools: routes analysis
README.md - MCP Server → Visualization Tools: routes visualization
README.md - Data Tools → SQL Connectors: uses
src/tools/data_tools.py - Data Tools → File Reader: uses
src/tools/data_tools.py - SQL Connectors → SQL Sources: queries
src/data_sources/database_connector.py - File Reader → CSV Excel JSON: reads
src/data_sources/file_reader.py - Data Tools → REST APIs: may access
README.md - Analysis Tools → Statistical Engine: may use
- Analysis Tools → Data Tools: loads data
- SQL Connectors → Configuration: reads settings
src/data_sources/database_connector.py - File Reader → Configuration: reads settings
src/data_sources/file_reader.py - SQL Connectors → Structured Logging: logs operations
src/data_sources/database_connector.py - File Reader → Structured Logging: logs reads
src/data_sources/file_reader.py