env.example

# Database Configuration (for Next.js Dashboard)
DB_HOST=localhost
DB_USER=root
DB_PASSWORD=your-password-here
DB_PORT=3306
DB_NAME=pdp_analytics

# Supabase Configuration
SUPABASE_URL=https://ebnptsplhfktzxsiuuyp.supabase.co
SUPABASE_SERVICE_ROLE_KEY=your-service-role-key-here
SUPABASE_ANON_KEY=your-anon-key-here

# Syntex AI Schools API
SYNTEX_API_BASE_URL=https://schools.syntex-ai.com
SYNTEX_API_KEY=your-syntex-api-key-if-needed

# OpenAI Configuration (for Next.js Dashboard LLM features)
OPENAI_API_KEY=your-openai-api-key-here
NEXT_PUBLIC_ENABLE_LLM=1

# ETL Configuration
BRONZE_SCHEMA=bronze
LOG_LEVEL=INFO
BATCH_SIZE=1000

# Pagination Configuration
PAGE_SIZE=100          # Records per page when fetching from API
MAX_PAGES=100          # Maximum number of pages to fetch per endpoint (safety limit)