🌟 Project Overview

Welcome to DataInsightAI! This project is a powerful Postgres + OpenAI-based data analysis and insight tool. It empowers users to seamlessly connect to any Postgres database, execute complex queries, and leverage the data to ask insightful questions and generate meaningful insights. By harnessing the capabilities of OpenAI, this application provides intelligent analysis and stunning visualizations, making it easier for users to derive valuable conclusions from their datasets.

🚀 Installation Steps

Follow these simple steps to get started:

1. Clone the repository:

   git clone <repository-url>
   cd DataInsightAI

2. Install dependencies:

   pip install streamlit openai plotly psycopg2-binary sqlalchemy pandas

3. Configure OpenAI: Add your OpenAI API key in the AI Analysis page of the application.

🏃‍♂️ Running the Application

1. Start the Streamlit server:

   streamlit run main.py

2. Open your browser and navigate to:

   http://localhost:8501
   

📁 Project Structure

├── .streamlit/          # Streamlit configuration
├── assets/              # Static assets and styles
├── pages/               # Application pages
│   ├── 01_database_connection.py
│   ├── 02_query_builder.py
│   └── 03_ai_analysis.py
├── utils/               # Utility functions
│   ├── database.py      # Database connection handling
│   ├── mock_data.py     # Sample data generation
│   └── openai_helper.py  # OpenAI integration
└── main.py              # Application entry point