---
title: Pc Ai Data Analyst V2
emoji: 📈
colorFrom: purple
colorTo: yellow
sdk: gradio
sdk_version: 5.37.0
app_file: app.py
pinned: false
---

# 💊 PharmaCircle AI Data Analyst v2 

This is a Gradio application that acts as an AI-powered data analyst for the PharmaCircle Solr database. It uses a Large Language Model (LLM) to translate natural language questions into Solr queries, executes them, and then generates visualizations and reports based on the results.

## Required Secrets

To run this space, you will need to set the following secrets in the "Settings" tab of your Hugging Face Space:

- `SSH_HOST`: The hostname or IP address of the SSH server for the tunnel.
- `SSH_USER`: The username for the SSH connection.
- `SSH_PASS`: The password for the SSH connection.
- `SOLR_USER`: The username for the Solr database.
- `SOLR_PASS`: The password for the Solr database.
- `GEMINI_API_KEY`: Your Google Gemini API key.