Gemini SQL Dashboard

A Flask & SQL Server Real-Time Monitoring Console

Gemini SQL Dashboard is a Windows-friendly web application that:

• Queries any SQL Server table on demand and in real time.
• Displays live data in the browser using Flask-SocketIO and WebSockets.
• Offers filtered views, auto-refresh, and exportable logs.
• Automates setup with a single Windows .bat installer.

---

🚀 Key Features

• Real-Time Updates: Instantly push new query results to all connected clients.
• Flexible Queries: Configure the dashboard to read from any specified table or view.
• Filtering & Search: Filter rows by column values directly in the UI.
• Export Logs: Download session logs or snapshots as CSV.
• Clean Responsive UI: Built with Bootstrap for desktop and tablet compatibility.

---

📋 Prerequisites

• Windows 10 or 11
• Python 3.8+
• Access to a SQL Server instance
• Git (to clone or update the repo)

---

🔧 Installation

1. Clone the repository:

   git clone https://github.com/YourUser/gemini-sql-dashboard.git
   cd gemini-sql-dashboard

2. Edit sql_credentials.txt to point at your database:

   SERVER=your_server_address
   DATABASE=your_database_name
   UID=your_username
   PWD=your_password
   

3. Run the Windows installer:

   • Double-click Install.bat, or in PowerShell:

     .\Install.bat

   This will:

   • Create and activate a Python virtual environment
   • Install required packages (Flask, Flask-SocketIO, pyodbc)
   • Launch the dashboard automatically

---

📂 Install.bat Script

@echo off
REM === Gemini SQL Dashboard Installer ===

REM 1. Create & activate virtual environment
python -m venv venv
call venv\Scripts\activate

echo Installing Python packages...
%venv%\Scripts\pip install --upgrade pip
%venv%\Scripts\pip install -r requirements.txt

echo Generating default SQL credentials if missing...
if not exist sql_credentials.txt (
  echo SERVER=127.0.0.1>sql_credentials.txt
  echo DATABASE=master>>sql_credentials.txt
  echo UID=SA>>sql_credentials.txt
  echo PWD=>>sql_credentials.txt
)

echo Launching Dashboard...
%venv%\Scripts\python app.py

pause

---

🎬 Usage

1. Run Install.bat or manually:

   venv\Scripts\activate
   python app.py

2. Open your browser at http://127.0.0.1:8050.

3. Interact with real-time query results, apply filters, and export logs.

---

🛠️ Project Structure

gemini-sql-dashboard/
├── app.py                # Main Flask + SocketIO app
├── requirements.txt      # Python dependencies
├── sql_credentials.txt   # Database connection info
├── Install.bat           # One-click Windows installer
├── templates/
│   └── index.html        # Dashboard UI
└── static/
    ├── css/
    └── js/

---

📄 License

MIT License

Copyright (c) 2025 Jose Perez

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.