ReddRadar
Agent skill
database-analyzer
Specialized in syncing the production database and performing analysis on trades, balances, and market history.
Install this agent skill to your Project
npx add-skill https://github.com/Niller2005/PolyFlup/tree/main/.opencode/skill/database-analyzer
SKILL.md
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.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
Niller2005/PolyFlup
svelte-ui-standards
Coding standards and UI guidelines for the PolyFlup Svelte dashboard.
Niller2005/PolyFlup
polyflup-ops
Operational commands, environment configuration, and deployment for PolyFlup.
Niller2005/PolyFlup
bookkeeper
Specialized in maintaining project documentation, ensuring it reflects the current state of the codebase and operational procedures.
Niller2005/PolyFlup
log-analyzer
Specialized in syncing logs from production and analyzing them to find trade history, errors, or performance metrics.
Niller2005/PolyFlup
python-bot-standards
Coding standards, modular architecture, and common execution patterns for the PolyFlup Python backend.
Niller2005/PolyFlup
database-sqlite
SQLite best practices, connection management, and migration system for PolyFlup.
Didn't find tool you were looking for?