菜单
Find SQL files in extract/2026/inserts/, clone the BusMgmtBenchmarks Dolt database, execute each SQL file against the local clone, show the diff, then commit and push. Triggered by "/insert-dolt-db-sql" (all files) or "/insert-dolt-db-sql FILE1 FILE2 ..." (specific files).
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/calvinw/dolt-db-skills --skill insert-dolt-db-sql命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
正在显示 SKILL.md
Interactive financial literacy quiz assistant for undergraduate business students. Pulls side-by-side financial data from the BusMgmtBenchmarks Dolt database, then quizzes students on Revenue, COGS, Gross Margin, SG&A, Operating Profit, Net Profit, Inventory, Total Assets, and ratios using multiple-choice and true/false questions. Triggered by "/basic-financials-quiz TICKER1 YEAR1 TICKER2 YEAR2".
Interactive ROA Analysis Quiz Assistant for undergraduate business students. Pulls side-by-side financial data from the BusMgmtBenchmarks Dolt database, then quizzes students on Return on Assets (ROA) and the Strategic Profit Model using multiple-choice and true/false questions. Triggered by "/roa-analysis-quiz TICKER1 YEAR1 TICKER2 YEAR2".
Interactive financial comparison assistant for undergraduate business students. Takes two company tickers each with their own year, pulls side-by-side income statement, ratio, and balance sheet data from the BusMgmtBenchmarks Dolt database, and stays open for student questions about what the numbers mean. Triggered by "/basic-financials TICKER1 YEAR1 TICKER2 YEAR2".
基于 SOC 职业分类
| name | insert-dolt-db-sql |
| version | 0.1 |
| description | Find SQL files in extract/2026/inserts/, clone the BusMgmtBenchmarks Dolt database, execute each SQL file against the local clone, show the diff, then commit and push. Triggered by "/insert-dolt-db-sql" (all files) or "/insert-dolt-db-sql FILE1 FILE2 ..." (specific files). |
Find SQL files in extract/2026/inserts/, clone the target Dolt database, execute each SQL file, show the diff, and commit+push to DoltHub.
This skill writes directly to the Dolt database. Use with caution.
dolt version)dolt config --global --add user.email and user.name)/insert-dolt-db-sql — find and apply all .sql files in extract/2026/inserts//insert-dolt-db-sql FILE1 FILE2 ... — apply only the named files (paths relative to extract/2026/inserts/)List all .sql files under extract/2026/inserts/. If specific filenames were provided, filter to only those (error if any are not found).
Display the list:
Found {N} SQL file(s): file1.sql, file2.sql, …
If no files found, stop and tell the user: "No SQL files found in extract/2026/inserts/."
Create a temporary directory and clone calvinw/BusMgmtBenchmarks into it:
TMPDIR=$(mktemp -d)
dolt clone calvinw/BusMgmtBenchmarks "$TMPDIR"
Confirm clone succeeded. If it fails, stop with an error.
For each SQL file (in alphabetical order):
dolt sql < "{SQL_FILE_PATH}"
Show the output of each execution. If any SQL file produces errors, display them but continue processing remaining files.
cd "$TMPDIR"
dolt diff
Display the full diff to the user for review.
cd "$TMPDIR"
dolt add -A
dolt commit -am "Apply SQL inserts from extract/2026/inserts/"
Show the commit hash.
cd "$TMPDIR"
dolt push origin main
If push fails due to missing credentials, tell the user to push manually:
Push requires DoltHub credentials. Run
dolt push origin mainfrom{TMPDIR}manually.
Remove the temporary clone directory:
rm -rf "$TMPDIR"
Applied {N} SQL file(s) to calvinw/BusMgmtBenchmarks/main:
Commit: {hash}
Diff summary: {N} rows changed across {N} tables.