calvinw/dolt-db-skills

basic-financials-quiz

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,…

原文语言：英语

roa-analysis-quiz

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…

原文语言：英语

basic-financials

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…

原文语言：英语

create-new-company-sql

Fetch financial data from SEC 10-K filings and Yahoo Finance for a NEW company (2018 through current year), reconcile values, and generate SQL files to insert the company_info row and all financials rows. Does NOT write to the database directly. Triggered by…

原文语言：英语

create-verified-dolt-db-financials-sql

Generate a SQL file containing REPLACE INTO statements for the BusMgmtBenchmarks Dolt database, based on reconciled values from /verify-dolt-db-financials report files saved in reports/. Does NOT connect to or write to any database — output is a .sql file…

原文语言：英语

download-new-year-data

Check a specific company in the BusMgmtBenchmarks Dolt database for newly available fiscal year data not yet in the database, validate it for consistency, and generate a SQL INSERT file. For American companies, cross-checks SEC and Yahoo Finance. For…

原文语言：英语

find-financials-from-pdfs

Extract financial data from PDF annual reports for private companies not listed on public exchanges, standardize the data to match the BusMgmtBenchmarks schema, and generate SQL files for insertion into the company_info and financials tables. Use when adding…

原文语言：英语

insert-dolt-db-sql

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 ..."…

原文语言：英语

verify-dolt-db-financials

Fetch financial statements from SEC 10-K filings and Yahoo Finance for a BusMgmtBenchmarks retail company, compare all sources side by side, detect anomalies (especially SGA composite line items, restatements, and balance sheet mismatches), and produce…

原文语言：英语