Sherlock Theory

Sherlock Ops Dashboard

Read-only monitoring for rolling databases, VPS bots, and maintenance health.

Inventory

Configured Sherlock VPS estate

Expected rolling databases, bots, evidence sources, and live VPS validation readiness.

VPS checks enabled access local ready

VPS check readiness

Host: local-vps

User: trader

SSH key: not required

MEXC Perps

mexc_perps | confidence high

vps mexc
Database
sherlock_mexc_perps
DB endpoint
localhost:5432
Always-on roles
2
Scheduled roles
2
Live seen
4
Runtime missing
0
Scheduled overdue
2
Unhealthy live
2

Notes: Isolated rolling perps DB with compose project sherlock-mexc-perps and parity/history references in the repo.

Evidence:

../.env ../docker-compose.yml ../local_db_maintenance.md ../mexc_perps_project_handoff.md

Configured roles

always-on: postgres always-on: websocket scheduled: history scheduled: timeframes

Live VPS processes

sherlock-mexc-perps-postgres (running) sherlock-mexc-perps-mexc-history-bot (missing) sherlock-mexc-perps-mexc-websocket-bot (running) sherlock-mexc-perps-timeframes-bot (missing)

Scheduled roles overdue: history, timeframes

MEXC Spot

mexc_spot | confidence high

vps mexc_spot
Database
sherlock_mexc_spot_vps
DB endpoint
localhost:5434
Always-on roles
2
Scheduled roles
2
Live seen
4
Runtime missing
0
Scheduled overdue
1
Unhealthy live
1

Notes: Dedicated VPS rolling MEXC spot stack.

Evidence:

../.env.spot.vps ../docker-compose.yml ../mexc_spot_vps_rolling_db_runbook.md ../local_db_maintenance.md

Configured roles

always-on: polling always-on: postgres scheduled: history scheduled: timeframes

Live VPS processes

sherlock-mexc-spot-vps-postgres (running) sherlock-mexc-spot-vps-mexc-spot-history-bot (running) sherlock-mexc-spot-vps-mexc-spot-polling-bot (running) sherlock-mexc-spot-vps-mexc-spot-timeframes-bot (missing)

Scheduled roles overdue: timeframes

OKX Perps

okx_perps | confidence high

vps okx
Database
sherlock_okx_perps
DB endpoint
localhost:5435
Always-on roles
2
Scheduled roles
3
Live seen
5
Runtime missing
0
Scheduled overdue
3
Unhealthy live
3

Notes: Clear isolated OKX perps DB and bot suite with history, websocket, timeframe, and progress services.

Evidence:

../.env.okx.perps ../docker-compose.yml ../local_db_maintenance.md ../watch-okx-progress.ps1

Configured roles

always-on: postgres always-on: websocket scheduled: history scheduled: progress scheduled: timeframes

Live VPS processes

sherlock-okx-perps-postgres (running) sherlock-okx-perps-okx-history-bot (missing) sherlock-okx-perps-okx-websocket-bot (running) sherlock-okx-perps-okx-timeframes-bot (missing) sherlock-okx-perps-okx-progress-bot (missing)

Scheduled roles overdue: history, progress, timeframes

Bybit Perps

bybit_perps | confidence high

vps bybit
Database
sherlock_bybit_perps
DB endpoint
localhost:5436
Always-on roles
2
Scheduled roles
1
Live seen
3
Runtime missing
0
Scheduled overdue
1
Unhealthy live
1

Notes: Dedicated isolated Bybit perps compose stack with separate Postgres and websocket/history bots.

Evidence:

../ByBit/.env.bybit.perps ../ByBit/docker-compose.bybit-perps.yml ../bybit_vps_db_thread.md ../local_db_maintenance.md

Configured roles

always-on: postgres always-on: websocket scheduled: history

Live VPS processes

sherlock-bybit-perps-postgres (running) sherlock-bybit-perps-history-bot (missing) sherlock-bybit-perps-websocket-bot (running)

Scheduled roles overdue: history

Binance Spot

binance_spot | confidence high

vps binance_spot
Database
sherlock_binance_spot
DB endpoint
localhost:5437
Always-on roles
1
Scheduled roles
4
Live seen
5
Runtime missing
0
Scheduled overdue
4
Unhealthy live
4

Notes: Isolated Binance spot DB with history, timeframe, progress, and audit tasks.

Evidence:

../.env.binance.spot ../docker-compose.yml ../binance_spot_thread.md ../local_db_maintenance.md

Configured roles

always-on: postgres scheduled: audit scheduled: history scheduled: progress scheduled: timeframes

Live VPS processes

sherlock-binance-spot-postgres (running) sherlock-binance-spot-binance-spot-history-bot (missing) sherlock-binance-spot-binance-spot-timeframes-bot (missing) sherlock-binance-spot-binance-spot-progress-bot (missing) sherlock-binance-spot-binance-spot-audit-bot (missing)

Scheduled roles overdue: audit, history, progress, timeframes

Hyperliquid

hyperliquid | confidence high

vps hype
Database
hype
DB endpoint
localhost:5432
Always-on roles
0
Scheduled roles
0
Live seen
0
Runtime missing
0
Scheduled overdue
0
Unhealthy live
0

Notes: Hyperliquid runs as an isolated Python upkeep workflow on the VPS with dedicated candle tables and cron-based refresh jobs.

Evidence:

../.env.hype ../local_db_maintenance.md ../Code/hype/README.md ../Defi Trading/Code/hype/README.md

Configured roles

No Docker roles configured

Live VPS processes

No live processes discovered