AgentSkillsCN

database-analyzer

专门同步生产数据库，并对交易、余额和市场历史进行分析。

SKILL.md
--- frontmatter
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.