New_Coders - PS ID - SIH26023 Demo Video

Comprehensive AI-Powered Geological & Mining Reporting Engine: A secure, on-premise RAG (Retrieval-Augmented Generation) platform to automate ingestion, analysis, and synthesis of geological PDFs, borehole Excel logs, and legacy mining data with 100% strict source verifiability and zero cloud dependency. Local-First AI Generation: Leverages local Ollama integration (Llama-3-8B or Mistral-7B) with intelligent fallback synthesis when offline, ensuring continuous operation in air-gapped PSU deployments without external cloud API dependencies. Citation-Aware Semantic Search: Every indexed chunk carries explicit metadata (PDF filename, page number, Excel sheet, row, cell reference). Automated Report Synthesis: Generates structured geological mining reports in Markdown with section organization (lithology analysis, coal quality metrics, stripping ratio assessment, borehole survey summaries) directly from multi-format ingested data. Domain-Specific Analytics Engine: Extracts word frequencies, key mining phrases (e.g., "overburden removal", "coal seam depth"), and topic clustering using TF-IDF + LSA for automated thematic organization of geological datasets.