How angelmendoz/sog2-2s26_grupo8 works
Practica_1 is a PostgreSQL sales-analysis project with a conversational interface: users ask the local web agent questions, which are handled by analysis tools and returned as structured results or charts. Its analysis stages cover exploration, trends, customer segmentation, correlation, and visual summaries. The sampled code shows MCP tool dispatch and the agent’s native chart-artifact path. The tree also contains a separate RPA project, but its runtime wiring was not excerpted, so its relationships are not inferred here.
Main entry points: punto_02.py Exploratory analysis · mcp_server.py MCP server · main.py Agent web app · agent.py Sales agent
Components 17
User interface
- Agent web app
Practica_1/app/main.py - Sales agent
Practica_1/app/ventas_agent/agent.py - MCP server
Practica_1/app/mcp_server.py - Session store
Analysis tools
- Exploration tools
Practica_1/app/herramientas/punto_02.py - Trend tools
Practica_1/app/herramientas/punto_03.py - Segmentation tools
Practica_1/app/herramientas/punto_04.py - Correlation tools
Practica_1/app/herramientas/punto_05.py - Finding tools
Practica_1/app/herramientas/punto_06.py
Sales analysis
- Shared config
Practica_1/app/config.py - Exploratory analysis
Practica_1/app/analisis/punto_02.py - Trend analysis
Practica_1/app/analisis/punto_03.py - Customer segments
Practica_1/app/analisis/punto_04.py - Correlation analysis
Practica_1/app/analisis/punto_05.py - Finding visuals
Practica_1/app/analisis/punto_06.py
Other components
- Analyst
- PostgreSQL
Connections 22
- Analyst → Agent web app: asks
Practica_1/app/main.py - Agent web app → Sales agent: serves
Practica_1/app/main.py - Agent web app → Session store: stores sessions
Practica_1/app/main.py - Sales agent → Exploration tools: uses tools
Practica_1/app/ventas_agent/agent.py - Sales agent → Finding tools: uses tools
Practica_1/app/ventas_agent/agent.py - MCP server → Exploration tools: dispatches
Practica_1/app/mcp_server.py - MCP server → Trend tools: dispatches
Practica_1/app/mcp_server.py - MCP server → Segmentation tools: dispatches
Practica_1/app/mcp_server.py - MCP server → Correlation tools: dispatches
Practica_1/app/mcp_server.py - MCP server → Finding tools: dispatches
Practica_1/app/mcp_server.py - Exploration tools → Exploratory analysis: calls
Practica_1/app/herramientas/punto_02.py - Trend tools → Trend analysis: calls
Practica_1/app/herramientas/punto_03.py - Segmentation tools → Customer segments: calls
Practica_1/app/herramientas/punto_04.py - Correlation tools → Correlation analysis: calls
Practica_1/app/herramientas/punto_05.py - Finding tools → Finding visuals: reads findings
Practica_1/app/herramientas/punto_06.py - Trend tools → Exploratory analysis: loads data
Practica_1/app/herramientas/punto_03.py - Segmentation tools → Exploratory analysis: loads data
Practica_1/app/herramientas/punto_04.py - Correlation tools → Exploratory analysis: loads data
Practica_1/app/herramientas/punto_05.py - Finding visuals → Exploratory analysis: uses distributions
Practica_1/app/analisis/punto_06.py - Finding visuals → Correlation analysis: uses correlations
Practica_1/app/analisis/punto_06.py - Exploratory analysis → PostgreSQL: queries
Practica_1/app/analisis/punto_02.py - Agent web app → Shared config: loads settings
Practica_1/app/main.py