Skip to content

Latest commit

 

History

History
50 lines (40 loc) · 1.3 KB

README.md

File metadata and controls

50 lines (40 loc) · 1.3 KB

AI Data Analyst

An intelligent platform that allows users to analyze data through natural language queries, generating instant charts and insights from SQL and ClickHouse databases.

Features

  • Natural language to SQL query conversion
  • Interactive data visualization
  • Support for both SQL and ClickHouse databases
  • Real-time chart generation
  • Intelligent data insights

Setup

  1. Create a virtual environment:
python -m venv venv
source venv/bin/activate  # On Windows: .\venv\Scripts\activate
  1. Install dependencies:
pip install -r requirements.txt
  1. Create a .env file with your database credentials:
SQL_DATABASE_URL=your_sql_database_url
CLICKHOUSE_HOST=your_clickhouse_host
CLICKHOUSE_PORT=your_clickhouse_port
CLICKHOUSE_USER=your_clickhouse_user
CLICKHOUSE_PASSWORD=your_clickhouse_password
OPENAI_API_KEY=your_openai_api_key
  1. Run the application:
uvicorn app.main:app --reload

Project Structure

  • /app: Main application directory
    • main.py: FastAPI application entry point
    • database.py: Database connection handlers
    • models.py: Database models
    • schemas.py: Pydantic models for request/response
    • ai_service.py: AI query processing service
    • chart_service.py: Chart generation service
  • /frontend: React frontend application