database-analyzer
Specialized in syncing the production database and performing analysis on trades, balances, and market history.
Installation
Follow the repository instructions for this skill and your agent. Review the files and dependencies before adding it to your workflow.
View source ↗GuidesSkill instructions
Responsibilities
- Syncing the production database (
trades.db) using thesync_dbtool. - 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
- Run
sync_dbto fetch the latest production state. - Use
uv run check_db.pyfor a quick integrity check. - Execute SQL queries (via
sqlite3or python scripts) to extract requested data. - Report findings with clear data points (e.g., "Total PnL for BTC in Jan: +$X").
Useful Tools & Scripts
-
sync_db: Downloads the latesttrades.dbvia SSH. -
check_db.py: Basic statistics and integrity check. -
migrate_db.py: Migration management. -
src/data/database.py: DB interaction logic.
Examples
Read the usage examples in the source repository.
View source ↗Source history
- Indexed on
- 2026-01-20
- Index updated
- 2026-01-26
- Branch
- main
Index and sync dates describe this directory. View the source repository for code history.
GitHub ↗chat Comments (0)
Sign in to join the discussion and leave a comment.
No comments yet. Be the first to share your thoughts!