GFS Platform Architecture

NetSuite ERP → Cloudflare Edge → Dashboards & AI · 185K rows · 20 endpoints

01 / Source 02 / Extract 03 / Store 04 / Serve 05 / Consume NetSuite ERP Account 4656898 · 102K txns SuiteAPI #2948 RESTlet gateway MCP Server Claude ↔ NetSuite N/llm Module Cohere Command R Chartstone Pro localhost API · Pro tier sync.sh + wrangler launchd */15m · delta upserts Worker Crons */15 sync · 19:00 report D1 Database 185K rows · 18 tables · 29.6 MB KV Cache Hot data (ready) R2 Storage Files/PDFs (ready) CF Worker 20 REST endpoints · Auth · CORS Custom Domain api.ai-globalfoodsolutions.co CF Pages (16) Static hosting · CDN edge System Guide gfs-system-guide.pages.dev Dashboards Infra + Executive + Tools Workers AI Phase 4: NL → D1 queries Mobile Access All pages responsive SuiteQL REST RESTlet JSON response SQL upserts sync_log SQL queries cached data file serve route static JSON API JSON API NL queries HTML/CSS/JS direct query native AI Legend primary data policy / PII async batch data store

Data Volume

  • • 185,487 rows synced from NetSuite
  • • 102,367 transactions · 20 types
  • • 78,962 line items across 3 tables
  • • Entity backfill: 78,616 patched (100%)

API Security

  • • 20 endpoints · Bearer auth
  • • CORS restricted to 4 origins
  • • 6 security headers (CSP, X-Frame, XSS)
  • • All SQL parameterized · input validated

Known Gaps

  • • Custom domain SSL provisioning
  • • KV/R2 bound but unused
  • • Worker sync cron is stub
  • • vb_lines 50.7% coverage