Inspect the schema of the local finbridge database (SQLite with ingested KR/US company fundamentals, filings, and daily prices): tables, views, columns, per-table row counts (cached 5 minutes), and ready-to-run example queries for query_db.
Args: (none)
Returns: {tables: [{name, columns: [{name, type}], rows}], views: [{name, columns: [{name, type}]}], examples: [sql_string]}
Key objects:
- companies: KR companies have source='dart' + stock_code (6-digit), US companies source='edgar' + ticker
- financials: one row per company x fiscal_year x quarter (quarter=0 = annual); raw unscaled KRW/USD amounts
- prices_daily: daily OHLCV per company_id
- views v_financials (financials joined with company name/ticker/stock_code) and v_latest_annual (latest annual row per company) — prefer these in query_db
Examples:
- Call before writing SQL for query_db, to learn table/column names.
- Check row counts to see how much data the nightly ingest has loaded.
Use when: preparing a query_db, or checking ingest coverage. Don't use for live market data (use the dart_/edgar_/fred_/crypto_ tools).
Errors: 'database has not been built yet' — the ingest pipeline has not run on the server.