env.example

# Text2SQL Evaluation Toolkit - Environment Variables
# Copy this file to .env and fill in your actual credentials
# .env is already in .gitignore and will not be committed

# ===== WatsonX AI Credentials =====
# Required for wxai: prefixed models (e.g., wxai:meta-llama/llama-3-3-70b-instruct)
WATSONX_APIKEY=your_watsonx_api_key_here
WATSONX_API_BASE=https://us-south.ml.cloud.ibm.com
WATSONX_PROJECTID=your_project_id_here

# ===== Anthropic Claude API =====
# Required for anthropic: prefixed models (e.g., anthropic:claude-opus-4-1-20250805)
ANTHROPIC_API_KEY=your_anthropic_api_key_here

# ===== GEMINI API =====
# Required for google gemini: prefixed models (e.g., gemini:gemini-3-flash-preview or gemini:gemini-3.1-pro-preview)
GEMINI_API_KEY=your_gemini_api_key_here

# ===== vLLM API =====
# Required for vllm: prefixed models
VLLM_API_BASE=http://localhost:8000/v1
VLLM_API_KEY=optional_api_key_here

# ===== RITS API =====
# Required for rits prefixed models
RITS_API_KEY=your_rits_api_key_here

# ===== Database Connection Strings =====

# PostgreSQL (for PostgreSQL-based benchmarks)
POSTGRES_CONNECTION_STRING=postgresql://user:password@host:port/database

# MySQL (for benchmarks like beaver)
MYSQL_CONNECTION_STRING=mysql://user:password@host:port/database

# DB2 (for DB2-based benchmarks)
DB2_CONNECTION_STRING=DATABASE=dbname;HOSTNAME=host;PORT=port;PROTOCOL=TCPIP;UID=user;PWD=password;

# Presto (for Presto-based benchmarks)
PRESTO_CONNECTION_STRING=presto://user:password@host:port/catalog/schema

# ===== Optional Settings =====
# Logging level (DEBUG, INFO, WARNING, ERROR)
LOG_LEVEL=INFO