Papertrend Extractor LLM Documentation

This directory contains comprehensive technical documentation for the full workspace.

Scope

This documentation covers:

• Root Python ingestion and graph runtime
• Python node service and queue endpoints
• Next.js dashboard application
• Next.js API routes
• Worker queue processors
• Analysis pipeline internals
• Prompt contracts
• Supabase schema and data contracts
• Deployment and operations runbooks
• Testing coverage and quality gaps
• Module-by-module catalog

Document Map

1. System Overview and Architecture
2. Setup and Local Development
3. Frontend and API Architecture
4. Python Graphs and Nodes
5. Worker Queue and Analysis Pipeline
6. Data Model and Supabase Schema
7. Testing and Quality
8. Deployment and Operations Runbook
9. Module Catalog
10. Google Cloud Migration Plan
11. Google Cloud Phase 6: Cloud SQL Dual-Write And Shadow Verification
12. Google Cloud Phase 7: Frontend Hosting
13. Google Cloud Phase 8: Final Data And Service Cutover
14. Project Handoff - 2026-09-20
15. Firebase Production Hostname

Reading Order

Recommended order for new contributors:

1. System Overview and Architecture
2. Setup and Local Development
3. Frontend and API Architecture
4. Python Graphs and Nodes
5. Worker Queue and Analysis Pipeline
6. Data Model and Supabase Schema
7. Deployment and Operations Runbook
8. Module Catalog

Security Note

Never commit real secrets in environment files. If secrets have been committed at any time, rotate them immediately in provider dashboards and replace repository values with placeholders.