Agent-Skills.md

Agent Skills: database-analyzer

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

UncategorizedID: Niller2005/PolyFlup/database-analyzer

Repository

Niller2005/PolyFlup
Niller2005
172

Install this agent skill to your local

pnpm dlx add-skill https://github.com/Niller2005/PolyFlup/tree/HEAD/.opencode/skill/database-analyzer

Skill Files

Browse the full folder contents for database-analyzer.

Download Skill

Loading file tree…

.opencode/skill/database-analyzer/SKILL.md

Skill Metadata

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.