Tdx2db Query

What it does

When your agent uses it

• Data & Analytics work in your project

Example prompts

• “/tdx2db-query”

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

1. 1code 一律 6 位纯数字。sh600036 / sz000001 是 stock_info 和文件名的格式，行情表里没有。
2. 2停牌日显式处理：WHERE date = :d 查不到就是停牌，需要回退到前一交易日时显式写，禁止用 <= :d ORDER BY date DESC LIMIT 1 静默错配。
3. 3价格不复权。除权除息造成的跳空是数据特征不是 bug。
4. 4股票名称：stock_info.name 为真实名称（含退市名）。注意 stock_info.code 带前缀（sz000001），与行情表按 code 关联要 RIGHT(stock_info.code, 6)。板块归属查 block_stock_relation。
5. 5统计结果踩到极端值（0%/100%/历史新低）先复核口径再下结论。

What it can do on your machine

Read from SKILL.md and the folder at commit 2123165. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  No scripts in the folder and no shell commands in SKILL.md (its code samples are sql and bash).

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Tdx2db Query loads about 896 tokens when it runs. Until then it costs about 25 tokens; SKILL.md has 125 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~25

When it runs · the whole SKILL.md, loaded when a task matches

~896

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NoteMentions a .env fileSKILL.md:8

  写入（PostgreSQL / MySQL / SQLite，连接配置见项目 `.env`）。查询前先读 `AGENTS.md` 的 schema 与陷阱清单；本 skill 提供可直接套用的操作模板。

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from xbfighting/tdx2db at commit 2123165, republished under its MIT licence (© xbfighting). 125 words, ~896 tokens.

name

tdx2db-query

description

查询 tdx2db 同步的 A 股行情数据库（daily_data / minute*_data）。取日线分钟线、均线截面筛选、检查数据新鲜度/完整性、排查同步问题时使用。

tdx2db status --json

SELECT date, open, high, low, close, volume, amount,
       ma5, ma13, ma21, ma34, ma55, ma89, ma144, ma233
FROM daily_data
WHERE code = :code6      -- 6 位纯数字，如 '600036'，不带 sh/sz 前缀！
  AND date BETWEEN :start AND :end
ORDER BY date;

SELECT code, close, ma5, ma13, ma21, ma34, ma55, ma89, ma144, ma233
FROM daily_data
WHERE date = :d AND ma233 IS NOT NULL;   -- ma233 非空 ≈ 上市满一年，天然剔除次新股

SELECT MAX(date) FROM daily_data WHERE ma5 IS NOT NULL;

SELECT datetime, open, high, low, close, volume, amount
FROM minute30_data
WHERE code = :code6 AND datetime BETWEEN :start AND :end
ORDER BY datetime;

-- 板块 → 成分（行业为 881 研究行业，一/二/三级各一行，按名或 block_code 定位）
SELECT code FROM block_stock_relation
WHERE block_type = '行业' AND block_name = '煤炭开采';

-- 全部二级行业（≈ 通达信导出 CSV 的行业口径，板块强弱迭代用这个）
SELECT DISTINCT block_name FROM block_stock_relation
WHERE block_type = '行业' AND block_level = 2;

-- 个股 → 全部板块归属
SELECT block_type, block_code, block_name FROM block_stock_relation WHERE code = :code6;

-- 板块成分 JOIN 行情（北交所成员在行情表无数据，JOIN 自然过滤）
SELECT d.code, d.close, d.ma233
FROM block_stock_relation b JOIN daily_data d ON d.code = b.code
WHERE b.block_type = '概念' AND b.block_name = '人形机器人' AND d.date = :d;

-- 换手率(%)：volume(手)/ltag(万股) 单位差恰好抵消；股本变动点前的历史值失真
SELECT d.date, d.volume / s.ltag AS turnover_pct
FROM daily_data d JOIN stock_info s ON RIGHT(s.code, 6) = d.code
WHERE d.code = :code6 ORDER BY d.date DESC LIMIT 20;

-- 剔除次新股（上市不足 500 天）
SELECT RIGHT(code, 6) FROM stock_info WHERE list_date < CURRENT_DATE - 500;

SELECT
  (SELECT COUNT(*) FROM daily_data WHERE date = (SELECT MAX(date) FROM daily_data)) AS today_n,
  (SELECT COUNT(*) FROM daily_data
   WHERE date = (SELECT MAX(date) FROM daily_data
                 WHERE date < (SELECT MAX(date) FROM daily_data))) AS prev_n;
-- |today_n - prev_n| / prev_n > 5% ⇒ 疑似同步不完整，先重跑 tdx2db sync 再分析

© xbfighting, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .claude/skills/tdx2db-query of xbfighting/tdx2db.

Open the folder on GitHubat commit 2123165