Connected Agents
Loading...
Registered Agents
Loading...
Add Agent
Agent Setup
Configure DB credentials and sync jobs here. The agent downloads this config from the server automatically — no manual file editing needed.
Sign in to the Admin Console
Configure DB credentials and sync jobs here. The agent downloads this config from the server automatically — no manual file editing needed.
Runs the sync job now for yesterday's data.
Re-sync past data day by day into storage. Runs in the background on the agent — may take several minutes for large date ranges.
Requires backfill_query in agent config.json using @sync_date parameter.
Assign a dedicated S3 bucket or local path to a specific merchant. If not configured, the merchant uses the global storage above.
Pre-computed DuckDB summaries written back to object storage after analytics jobs run.
Stored under analytics/{merchant}/{db}/{job}/{date}_{summary}.json.
Analytics servers run DuckDB to pre-compute summaries from raw sync data stored in object storage. Object storage credentials are inherited automatically from the Storage settings above.
Uses DuckDB inside this process to pre-compute summaries. No separate analytics VM required.
Requires duckdb, node-cron, axios to be installed
(npm install in the server/ folder, then restart).
A dedicated analytics server registered above will always take priority for its assigned merchants.
0 2 * * * = 2:00 AM daily ·
0 */6 * * * = every 6 hours ·
30 1 * * * = 1:30 AM daily
Define which merchant / database / jobs the scheduler auto-computes each night, and which summary types to generate for each job.
Assign a dedicated analytics server to specific merchants. Unassigned merchants use the default server.
Trigger analytics computation for a specific merchant / database / job / date. Use Compute All Dates to backfill analytics for all available data.
Daily, weekly and monthly config snapshots to S3-compatible object storage.
⚠ Store this passphrase safely — you will need it to restore backups on a new server. When set, .env is included in every encrypted backup.
Paste your SELECT queries → auto-generates sync_jobs and queries config for config.json
Click any Copy button to copy the SQL — then paste into the PowerShell wizard (right-click in the terminal window)
Replace the sync_jobs and queries sections in your config.json with the content below.
Paste your config.json below to check for syntax errors and structural issues
before saving to the agent machine.