V2 Retail ‚Äî Data Sync Orchestrator

SYNC MODE

T-1 DAILY

Full sync every night at 2am IST

SQL TABLES IN MANIFEST

‚Üí 43 Supabase targets across 8 projects

MAX SQL CONNECTIONS

Hard cap ‚Äî Server 28 protected

SUPABASE PROJECTS

Active ¬∑ 3 Lovable-hosted

END-TO-END PIPELINE

SQL Server 28

192.168.151.28

DataV2 ¬∑ V2 HQ

‚ö† Overloaded

5 connections
max pool

SQL Proxy

Node.js :3000

V2 on-prem server

‚è≥ Install tomorrow

CF Tunnel
HTTP

sql28.v2retail.net

CF Tunnel #4e2e7c09

DNS live ‚úÖ

‚è≥ cloudflared needed

cache layer
5-30 min

v2-data-api

data.v2retail.net

CF Worker ¬∑ Edge

‚úÖ Live

2am IST
daily

v2-sync-engine

sync.v2retail.net

CF Worker ¬∑ Cron

‚úÖ Live

batch upsert
500 rows

Supabase

8 active projects

T-1 fresh by 2:30am

‚úÖ Ready

REST / SDK
realtime

All Apps

SRM ¬∑ SCM ¬∑ Finance

RetailHub + Lovable

‚óè In production

SERVER 28 PROTECTION

Active

Max SQL connections5 hard cap

Reads go through v2-data-api KV cache80%+ cache hits

Between table syncs500ms pause

Between waves2 minute pause

Rows per page500 (masters) ¬∑ 500 (txn)

Max pages per table200 (100k row safety)

Failed tables retry3am IST automatic

Sync reads bypass KVnocache=1 always fresh

NIGHTLY WAVE PLAN

2:00am IST ‚Äî Wave 1: Core Masters

ArticleMaster, VendorMaster, StoreMaster, CategoryMaster, ProductMaster ‚Äî the foundation everything else depends on. Runs first.

2:15am IST ‚Äî Wave 2: Stock & Inventory

InventorySnapshot, StoreStock, BinStock, BinMaster, WHInventory ‚Äî stock positions from end of day.

2:30am IST ‚Äî Wave 3: T-1 Transactions

DailySales, GRC, PO ‚Äî yesterday's core business data. What teams review first thing in the morning.

2:45am IST ‚Äî Wave 4: Supporting Masters

Color, Size, Brand, Season, SubCategory, Division, Region, State, FinanceSummary ‚Äî supporting data for enrichment and filters.

TOMORROW MORNING ‚Äî YOUR CHECKLIST

STEP 1 ‚Äî Download cloudflared (Windows)


              # Download MSI from:

              https://github.com/cloudflare/cloudflared/releases/latest/download/
cloudflared-windows-amd64.msi


              # Install it (double-click MSI or silent):

              msiexec /i cloudflared-windows-amd64.msi /quiet

STEP 2 ‚Äî Copy SQL Proxy to server


              # Copy v2-sql-proxy folder to C:\\V2SqlProxy\\

              # Then install dependencies:

              cd C:\\V2SqlProxy

              npm install

STEP 3 ‚Äî Start SQL Proxy (test first)


              node index.js

              # Should print: SQL pool ready ‚úÖ

              # Then test locally:

              curl http://127.0.0.1:3000/health -H "x-proxy-key: v2ret@il-sql-proxy-2026"

STEP 4 ‚Äî Install cloudflared as Windows service


              cloudflared.exe service install --config C:\\V2SqlProxy\\cloudflared-config.yml

              cloudflared.exe service start

STEP 5 ‚Äî Verify full pipeline ‚úÖ


              curl https://sql28.v2retail.net/health -H "x-proxy-key: v2ret@il-sql-proxy-2026"

              # Expected: {"status":"ok","server":"V2DC-SQL28",...}


              curl https://data.v2retail.net/health -H "x-api-key: v2-sync-engine-2026"

              # Expected: {"proxy_status":"‚úÖ reachable",...}


              curl https://sync.v2retail.net/health -H "x-api-key: v2-sync-engine-2026"

              # Expected: {"sql_proxy":"‚úÖ reachable",...}

SUPABASE API KEYS NEEDED

The sync engine needs service_role keys for each Supabase project to upsert data. Add them to the Worker as environment variables.

How to add keys to Worker


            # For each key, run in terminal:

            wrangler secret put SUPABASE_KEY_SRM

            wrangler secret put SUPABASE_KEY_SCM

            # ... etc


            # Or I can add them via API once you share the keys.

For Lovable-hosted projects

Open Lovable ‚Üí Project Settings ‚Üí Supabase ‚Üí API Keys ‚Üí Copy the service_role key. These have full DB write access.

V2 RETAIL ‚Äî DATA SYNC ORCHESTRATOR