Database Analyzer

Specialized in syncing the production database and performing analysis on trades, balances, and market history.

niller2005 b9322f3 952 B Updated

File contents

Responsibilities

  • Syncing the production database (trades.db) using the sync_db tool.
  • Querying the SQLite database for trade history, PnL, and position data.
  • Verifying database integrity and migration status.
  • Identifying trends or anomalies in the trading data.

Workflow

  1. Run sync_db to fetch the latest production state.
  2. Use uv run check_db.py for a quick integrity check.
  3. Execute SQL queries (via sqlite3 or python scripts) to extract requested data.
  4. Report findings with clear data points (e.g., "Total PnL for BTC in Jan: +$X").

Useful Tools & Scripts

  • sync_db: Downloads the latest trades.db via SSH.
  • check_db.py: Basic statistics and integrity check.
  • migrate_db.py: Migration management.
  • src/data/database.py: DB interaction logic.

niller2005/polyflup/tree/main/.opencode/skill/database-analyzer commit b9322f3fc8

Frequently asked questions

npx skillmds@latest add niller2005/database-analyzer