# Database Analyzer

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

- Skill: `niller2005/database-analyzer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add niller2005/database-analyzer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/niller2005/database-analyzer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: niller2005 (https://skillmd.com/u/niller2005)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/niller2005/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.