┌────────────────────────────────────────┐
│              Caddy (Reverse Proxy)     │
│         Routes /api/* → Backend         │
│         Routes /*  → Frontend           │
└───────────────┬────────────────────────┘
                │
       ┌────────┴────────┐
       ▼                 ▼
┌─────────────┐   ┌─────────────┐
│   Backend   │   │  Frontend   │
│  (FastAPI)  │   │  (Static)   │
└─────────────┘   └─────────────┘
       │
       ▼
┌─────────────┐
│ PostgreSQL  │
└─────────────┘

cd ~/spn
git pull
bash deploy.sh

docker-compose up -d --build

docker-compose exec api alembic upgrade head

curl https://your-domain.com/api/v1/system/health

# Production values
POSTGRES_SERVER=db
POSTGRES_PASSWORD=secure-password
SESSION_SECRET=production-secret

# Production URLs
FRONTEND_URL=https://your-domain.com
CORS_ORIGINS=https://your-domain.com

docker-compose logs -f api
docker-compose logs -f frontend

docker-compose restart api

docker-compose exec db psql -U postgres -d spn_db