dolt-db-skills

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

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-new-company-sql TICKER [CIK]".

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 only, which the user applies manually to their local Dolt clone. Run /verify-dolt-db-financials first to produce the report file. Triggered by "/create-verified-dolt-db-financials-sql TICKER YEAR" (single year) or "/create-verified-dolt-db-financials-sql TICKER" (all years from a multi-year analysis).

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 non-American companies, uses Yahoo Finance only. Triggered by "/download-new-year-data TICKER".

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 a private company (e.g. ACE Hardware) from PDF sources. Triggered by "/find-financials-from-pdfs COMPANY NAME".

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).

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 reconciled values ready for the Dolt database. Use when validating or adding financial data for any company tracked in the BusMgmtBenchmarks project. Triggered by commands like "/verify-dolt-db-financials TICKER YEAR" or "/verify-dolt-db-financials TICKER" (all years) or requests to fetch, check, or validate financials for a company in the project.