env.example

# ---------------- DATABASE CONFIGURATION ----------------
# Set USE_SUPABASE to "true" to use the Supabase PostgreSQL database.
# If set to "false" or not present, the application will default to a local SQLite database.
USE_SUPABASE=false

# ----------------- LOCAL SQLITE DATABASE -----------------
# The name of the local SQLite database file.
# This is only used if USE_SUPABASE is set to "false".
SQLITE_DB_NAME=analytics_agent.db

# ----------------- SUPABASE (POSTGRESQL) -----------------
# These details are required only if USE_SUPABASE is set to "true".
# You can find these in your Supabase project's settings under "Database".
DB_HOST=your_supabase_host
DB_PORT=5432
DB_NAME=postgres
DB_USER=postgres
DB_PASSWORD=your_supabase_password

# ----------------- SUPABASE STORAGE -----------------
# These are required for file uploads if you are using Supabase.
# You can find these in your Supabase project's settings under "API".
SUPABASE_URL=your_supabase_url
SUPABASE_KEY=your_supabase_key

# ----------------- GOOGLE GENERATIVE AI -----------------
# This is required for the "suggestion_generator" node.
# You can get your API key from Google AI Studio.
GEMINI_API_KEY=your_gemini_api_key

# ----------------- GOOGLE LOGIN AUTH -----------------
# OAuth 2.0 Web Client ID from Google Cloud Console (same value used in frontend env).
GOOGLE_CLIENT_ID=your_google_web_client_id.apps.googleusercontent.com

# ----------------- ORCHESTRATOR MEMORY -----------------
# Number of previous input-output pairs to provide as LLM context.
# Example: CONTEXT_SIZE=3 means 3 user+assistant pairs (6 messages).
CONTEXT_SIZE=3

# ----------------- FRONTEND (VITE) -----------------
# With frontend/vite.config.ts envDir set to '..', these values can live in the root .env.
VITE_API_URL=http://localhost:8000/api
VITE_API_BASE_URL=http://localhost:8001/api
VITE_API_ROOT_URL=http://localhost:8001
VITE_APP_NAME=Analytics & Forecasting Agent
VITE_GOOGLE_CLIENT_ID=your_google_web_client_id.apps.googleusercontent.com

# ----------------- OPTIONAL SELF-PING BACKUP -----------------
# IMPORTANT: This does not wake a fully sleeping free-tier service by itself.
# Keep an external monitor (e.g. UptimeRobot) as primary.
SELF_PING_ENABLED=false
SELF_PING_INTERVAL_SECONDS=600
# Prefer explicit public health URL for production:
# SELF_PING_URL=https://your-app.onrender.com/api/health