requirements.txt

# Core FastAPI and web framework
fastapi>=0.104.0
uvicorn[standard]>=0.24.0

# Database and ORM - PostgreSQL/Supabase only
sqlalchemy>=2.0.0
alembic>=1.12.0

# PostgreSQL support for Supabase
psycopg2-binary>=2.9.0
asyncpg>=0.29.0

# Testing and validation
pytest>=7.0.0
pytest-asyncio>=0.21.0
httpx>=0.24.0

# Data validation and serialization
pydantic>=2.0.0
pydantic[email]>=2.0.0
pydantic-settings>=2.0.0
email-validator>=2.0.0

# Authentication and security
passlib[bcrypt]>=1.7.4
python-jose[cryptography]>=3.3.0
python-multipart>=0.0.6

# Environment and configuration
python-dotenv>=1.0.0

# Document processing
python-docx>=0.8.11
reportlab>=4.0.0

# Task queue and background jobs
celery>=5.3.0

# OpenAI integration
openai>=1.0.0

# LangChain and RAG components
langchain>=0.1.0
langchain-openai>=0.1.0
langchain-community>=0.1.0
faiss-cpu>=1.7.4
chromadb>=0.4.0

# Hugging Face integration
huggingface-hub>=0.19.0
transformers>=4.35.0
torch>=2.0.0
accelerate>=0.24.0

# Optional: For Redis backend (if using Redis with Celery)
# redis>=5.0.0