---
title: PharmaCircle AI Data Analyst
emoji: 💊
colorFrom: blue
colorTo: green
sdk: gradio
sdk_version: 4.19.1
app_file: app.py
pinned: false
---

# 💊 PharmaCircle AI Data Analyst

This is a Gradio application that acts as an AI-powered data analyst for the PharmaCircle 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.