League Intelligence Platform - MVP Simplification Plan

┌─────────────────────────────────────────────────────────────┐
│                    Single Backend (FastAPI)                  │
│  - PDF Upload → Contract Generation (Your IP!)              │
│  - Database Query Router (Vertex/Supabase/ChromaDB/etc.)    │
│  - League Pipeline Monitor                                   │
│  - League Comparison Engine                                  │
└─────────────────────────────────────────────────────────────┘
                              ↓
┌─────────────────────────────────────────────────────────────┐
│              Single Frontend (Next.js)                       │
│  - Upload questionnaire PDFs                                 │
│  - View generated contracts                                  │
│  - Query league intelligence (multi-DB)                      │
│  - Daily pipeline dashboard                                  │
│  - League comparison views                                   │
└─────────────────────────────────────────────────────────────┘

2.1-cloud-run-docker-mcp/
├── apps/
│   └── backend/                    # Single FastAPI backend
│       ├── main.py
│       ├── routers/
│       │   ├── contracts.py        # PDF → Contract generation
│       │   ├── database_query.py   # Multi-DB query router
│       │   ├── pipeline.py         # League pipeline monitoring
│       │   └── comparison.py       # League comparison
│       └── tools/
│           ├── sequential_contract_generator.py
│           ├── database/
│           │   ├── vertex_connector.py
│           │   ├── supabase_connector.py
│           │   ├── chromadb_connector.py
│           │   └── redshift_connector.py
│           └── pipeline/
│               ├── league_monitor.py
│               └── daily_standup_generator.py
│
├── clients/
│   └── frontend/                   # Single Next.js frontend
│       ├── app/
│       │   ├── contracts/         # Contract generation UI
│       │   ├── query/             # Database query UI
│       │   ├── pipeline/          # Pipeline dashboard
│       │   └── comparison/        # League comparison
│       └── components/
│
└── deploy/
    ├── Dockerfile.backend
    ├── deploy-gcloud-run.sh
    └── README.md

Upload PDF → Extract Data → Sequential AI Reasoning →
4 Pricing Tiers → DOCX/PDF Contracts → Download

{
  "database": "vertex|supabase|chromadb|redshift",
  "query": "Show me all T1 leagues in basketball",
  "context": {}
}

{
  "active_leagues": 47,
  "by_tier": {"T1": 12, "T2": 18, "T3": 17},
  "by_stage": {
    "questionnaire_received": 15,
    "under_analysis": 8,
    "contract_drafted": 12,
    "negotiation": 7,
    "signed": 5
  },
  "upcoming_events": [
    {"league": "PWHL", "event": "Contract expiry", "date": "2025-11-15"},
    {"league": "PLL", "event": "Renewal discussion", "date": "2025-11-20"}
  ]
}

# League Intelligence Daily Standup - Oct 3, 2025
 
## 🎯 Today's Priorities
- 3 contracts ready for review
- 5 leagues awaiting questionnaire analysis
- 2 renewals due within 30 days
 
## 📊 Pipeline Health
- Active Leagues: 47
- New This Week: 4
- Conversion Rate: 68%
 
## 🚨 Action Items
1. Review PWHL contract terms (T1 league)
2. Follow up with Premier Basketball (questionnaire incomplete)
3. Prepare renewal docs for Athletes Unlimited
 
## 🔥 High-Value Opportunities
- World Sevens Football: T1 classification, $2.4M LTV
- Battle League USA: Emerging tier, high growth potential

{
  "comparison_matrix": {
    "PWHL": {
      "tier": "T1",
      "market_size": "$45M",
      "data_quality": 92,
      "api_readiness": "High",
      "ltv_3yr": "$2.1M"
    },
    "PLL": { /* ... */ }
  },
  "recommendations": [
    "PWHL offers highest LTV and best API integration",
    "PLL has stronger social media presence"
  ]
}

# apps/backend/tools/database/base_connector.py
from abc import ABC, abstractmethod
 
class BaseDatabaseConnector(ABC):
    @abstractmethod
    async def query(self, query_text: str, context: dict) -> dict:
        """Execute query and return standardized response"""
        pass
 
    @abstractmethod
    async def health_check(self) -> bool:
        """Check database connectivity"""
        pass

# apps/backend/tools/database/vertex_connector.py
class VertexConnector(BaseDatabaseConnector):
    async def query(self, query_text: str, context: dict):
        # Vertex AI RAG query logic
        return {"results": [...], "source": "vertex"}
 
# apps/backend/tools/database/supabase_connector.py
class SupabaseConnector(BaseDatabaseConnector):
    async def query(self, query_text: str, context: dict):
        # Supabase query logic
        return {"results": [...], "source": "supabase"}
 
# Similar for ChromaDB, Redshift, etc.

# apps/backend/routers/database_query.py
@router.post("/query")
async def query_database(request: DatabaseQueryRequest):
    connector = get_connector(request.database)
    results = await connector.query(request.query, request.context)
    return results
 
def get_connector(db_name: str):
    connectors = {
        "vertex": VertexConnector(),
        "supabase": SupabaseConnector(),
        "chromadb": ChromaDBConnector(),
        "redshift": RedshiftConnector()
    }
    return connectors[db_name]

# Archive these entire directories
mv clients/frontend-app-versions/_archived/
mv apps/practice_backend_versions/_archived/
mv apps/practice_email_assistant_versions/_archived/
 
# Keep only:
# - clients/frontend/ (one Next.js app)
# - apps/backend/ (one FastAPI backend)

# Backend deployment
cd apps/backend
./deploy_to_cloud_run.sh
 
# Frontend deployment (Vercel)
cd clients/frontend
vercel --prod
 
# Or Cloud Run for frontend too
./deploy-gcloud-run.sh frontend

# Terminal 1: Backend
cd apps/backend
uv run python main.py
 
# Terminal 2: Frontend
cd clients/frontend
npm run dev
 
# Access:
# - Frontend: http://localhost:3000
# - Backend API: http://localhost:8000
# - API Docs: http://localhost:8000/docs

# Backend tests
cd apps/backend
pytest
 
# Frontend tests
cd clients/frontend
npm test