database-analyzer skill

---
name: database-analyzer
description: Specialized in syncing the production database and performing analysis on trades, balances, and market history.
---

## 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.