メニュー
Volatio database inspection via docker exec psql (volatio-postgres-1, db volatio_market), common queries for tables/enums/hypertables, schema drift checks, fast debug workflow. Use when checking counts, recent rows, missing relations, or TimescaleDB hypertables.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Market data integrity rules — gap filling, look-forward bias prevention, and stock split handling. Use when writing or reviewing code that loads prices, fills missing data, computes returns, backtests strategies, or makes trading decisions. Applies across Python, TypeScript, SQL, and TimescaleDB.
Analyze Volatio debug logs from /tmp/volatio-debug/. Use when the user asks to check debug logs, analyze problems, or diagnose simulation issues.
Apply bottom-up systematic testing to a multi-layer system. Use when asked to test, debug, or verify a pipeline that spans multiple layers (e.g., Python worker → bridge → processor → API → UI).
Drizzle Kit workflow for Volatio using idempotent migrations (generate + edit + migrate), never use push. Idempotent patterns prevent partial failure issues, enable safe re-runs, and work cleanly in CI. Use when schema changes, migration errors, or database sync issues occur.
Template for creating Volatio research experiments with Optuna optimization and portfolio backtesting. Includes proper train/test splits, lookahead bias prevention, results saving, and validated patterns from Exp 051-053.
Financial research look-ahead bias verification for Volatio ML pipelines, mandatory baseline comparisons, timezone handling, feature leakage detection. Use when model accuracy seems too good or validating prediction experiments.
| name | docker-db-queries |
| description | Volatio database inspection via docker exec psql (volatio-postgres-1, db volatio_market), common queries for tables/enums/hypertables, schema drift checks, fast debug workflow. Use when checking counts, recent rows, missing relations, or TimescaleDB hypertables. |
docker compose ps
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c "SELECT now();"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY 1;"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT typname FROM pg_type WHERE typtype = 'e';"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT COUNT(*) FROM news_articles;"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT * FROM news_articles ORDER BY created_at DESC LIMIT 5;"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c "\d table_name"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT * FROM timescaledb_information.hypertables;"
docker exec volatio-postgres-1 psql -U volatio -d volatio_market -c \
"SELECT * FROM drizzle.__drizzle_migrations ORDER BY created_at;"
psql "$DATABASE_URL" on host - socket/auth issuesbun --eval for DB queries - hangs on connection cleanuppsql -h localhost - use docker exec insteadvolatio, not postgres)volatio-postgres-1volatiovolatio_market (NOT volatio)