Stock Analyst
1. Auto-enhance schema context
Prompt:
Run bruin ai enhance stock-analyst/ and let me know when it's done. It should enhance assets across all three layers - raw.*, staging.*, and reports.*. Then show me the changes it made to fmp_fundamentals.asset.yml (raw) and reports/ticker_quarterly.sql (reports) so I can spot-check the descriptions.
This command looks at each table, asks an LLM to describe what it sees, and writes column descriptions directly into the asset YAML - across all three layers. After it runs, your fmp_fundamentals.asset.yml will have a columns: block like:
columns:
- name: symbol
type: varchar
description: "Stock ticker symbol (e.g. AAPL)"
- name: date
type: date
description: "Fiscal period end date, not calendar quarter"
- name: revenue
type: bigint
description: "Total revenue in USD for the fiscal quarter"
# ...many more
These descriptions become part of the MCP context the agent reads before every query. You don't need to memorize any of this - the agent will look it up when it needs to.
If the agent got a description wrong (e.g. it misread what a column means), just ask it to fix that specific line. The YAML is yours to edit.