菜单
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.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
基于 SOC 职业分类
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/adam-s/volatio --skill docker-db-queries命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
正在显示 SKILL.md
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).
| 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)