database-analyzer

- Syncing the production database (trades.db ) using the sync_db tool.

Safety Notice

This listing is imported from skills.sh public index metadata. Review upstream SKILL.md and repository scripts before running.

Copy this and send it to your AI assistant to learn

Install skill "database-analyzer" with this command: npx skills add niller2005/polyflup/niller2005-polyflup-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

  • Run sync_db to fetch the latest production state.

  • Use uv run check_db.py for a quick integrity check.

  • Execute SQL queries (via sqlite3 or 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 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.

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Open in GitHubOpen in ClawHub

Related Skills

Related by shared tags or category signals.

General

polymarket-trading

No summary provided by upstream source.

Repository SourceNeeds Review
108-niller2005
General

database-sqlite

No summary provided by upstream source.

Repository SourceNeeds Review
12-niller2005
General

svelte-ui-standards

No summary provided by upstream source.

Repository SourceNeeds Review
11-niller2005
General

trainer

No summary provided by upstream source.

Repository SourceNeeds Review
10-niller2005