How dnosoro/openstore works
OpenStore is a data analytics application with a CSV-to-PostgreSQL data path and a web dashboard for both monthly revenue and natural-language analytics queries. The query endpoint generates SQL through OpenRouter, validates it, executes it, and returns rows for display; other endpoints expose prebuilt analytics views. The pipeline modules also implement raw-data checks and raw-to-staging transformations, but the sampled sources do not establish how those jobs are orchestrated or how core transformations consume staging data. No README content was provided.
Main entry points: main.py FastAPI Routes · upload_to_seaweed.py CSV Uploader · load_to_postgres.py Raw Loader · llm_service.py SQL Generation
Components 15
Data Ingestion
- CSV Sources
- CSV Uploader
src/ingestion/upload_to_seaweed.py - SeaweedFS
- Raw Loader
src/loading/load_to_postgres.py
Data Preparation
- Raw Data Checks
src/quality/validate_data.py - Staging Transforms
src/transform/staging_transform.py - Core Transforms
src/transform/core_transform.py
Analytics Serving
- Analytics Views
src/analytics/create_views.py - FastAPI Routes
src/api/main.py - SQL Generation
src/api/llm_service.py - SQL Guardrails
src/api/guardrails.py
Dashboard
- Analytics Dashboard
frontend/src/app/page.tsx
Other components
- PostgreSQL
- OpenRouter
- Dashboard User
Connections 14
- CSV Sources → CSV Uploader: supplies CSVs
src/ingestion/upload_to_seaweed.py - CSV Uploader → SeaweedFS: uploads files
src/ingestion/upload_to_seaweed.py - SeaweedFS → Raw Loader: serves CSVs
src/loading/load_to_postgres.py - Raw Loader → PostgreSQL: writes raw tables
src/loading/load_to_postgres.py - Raw Data Checks → PostgreSQL: reads raw tables
src/quality/validate_data.py - Staging Transforms → PostgreSQL: reads raw; writes staging
src/transform/staging_transform.py - Analytics Views → PostgreSQL: creates analytics views
src/analytics/create_views.py - FastAPI Routes → SQL Generation: requests SQL
src/api/main.py - SQL Generation → OpenRouter: requests completion
src/api/llm_service.py - FastAPI Routes → SQL Guardrails: validates and executes
src/api/main.py - SQL Guardrails → PostgreSQL: runs safe query
src/api/guardrails.py - FastAPI Routes → PostgreSQL: queries analytics views
src/api/main.py - Dashboard User → Analytics Dashboard: uses dashboard
frontend/src/app/page.tsx - Analytics Dashboard → FastAPI Routes: fetches analytics
frontend/src/app/page.tsx