# Data Talks - Backend (Python + LLM, no Supabase/Langflow)
fastapi==0.115.6
uvicorn[standard]==0.32.1
python-multipart==0.0.17
pydantic[email]==2.10.3
pydantic-settings==2.6.1
email-validator>=2.0.0

# Auth (bcrypt<4.1 required for passlib compatibility on Windows)
python-jose[cryptography]==3.3.0
passlib[bcrypt]==1.7.4
bcrypt>=4.0,<4.1

# DB: SQLite default (aiosqlite). For PostgreSQL set DATABASE_URL and use asyncpg + psycopg2-binary
sqlalchemy==2.0.36
aiosqlite==0.20.0
alembic==1.14.0
asyncpg==0.30.0
psycopg2-binary==2.9.10
greenlet==3.1.1

# LLM (API and/or local)
openai==1.55.3
httpx==0.28.1

# Data
pandas==2.2.3
openpyxl==3.1.5
matplotlib==3.10.1

# Optional: BigQuery, Google Sheets, SQL, Firebase
# google-cloud-bigquery==3.25.0
gspread==6.1.2
google-auth==2.36.0
# sqlalchemy (above) + drivers: pymysql, psycopg2-binary
firebase-admin>=6.5.0
