database-analyzer

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.