--- name: gateway.drillr.ai description: gateway.drillr.ai provides access to Drillr's financial data platform via three skills: a company search endpoint returning fundamental metrics, a SQL runner for querying structured financial datasets (income statements, balance sheets, cash flows), and a trading signal feed returning event-driven narrative signals for equities. All data access is read-only and batch-oriented, not real-time. host: gateway.drillr.ai --- # gateway.drillr.ai Drillr is a financial data platform targeting agents that need to perform fundamental analysis on equities. It serves use cases requiring company lookup by name or ticker, flexible SQL-based querying of financial statements, and event-driven signal retrieval (news, macro, M&A). It is distinct from market-data or exchange APIs in that it focuses on structured fundamentals and narrative signals rather than live prices or order book data. ## When to use this host Use gateway.drillr.ai when an agent needs fundamental financial data (valuation ratios, margins, growth metrics, financial statements) or event-driven equity signals for named companies or tickers. The SQL runner is especially useful when the agent needs to construct custom queries across financial statement tables rather than relying on a fixed schema. Do not use this host for real-time or streaming stock price quotes, OHLCV candlestick data, order book data, or technical chart indicators — use a dedicated market data or exchange API for those. Do not use it for write operations or bulk data exports. If the agent only needs a live price, this host is the wrong choice. ## Capabilities ### Company Discovery and Fundamentals Enables lookup of companies by name or ticker and retrieves key financial metadata including market cap, valuation ratios, margins, growth rates, and dividend yield. - **`search-companies`** — Searches a company database by name or ticker and returns matching records with market cap, valuation ratios, margins, and growth metrics. ### Structured Financial Data Query Allows arbitrary read-only SQL execution against Drillr's financial datasets, returning tabular results covering income statements, balance sheets, and cash flow data. - **`run-sql-query`** — Executes a read-only SQL query against Drillr financial datasets and returns column names plus row data as structured JSON. ### Equity Trading Signals Returns event-driven narrative signals — news headlines, macro digests, M&A activity — with scores and sector tags for one or more specified equity tickers. - **`fetch-trading-signal-list`** — Returns a list of trading signals with headlines, summaries, scores, suggested tickers, sector tags, and source URLs for a given set of ticker symbols. ## Workflows ### Company Fundamental Deep-Dive with Signal Context *Use when an agent needs to evaluate a company by first resolving its ticker, then pulling detailed financial statement data, and finally enriching the analysis with current event-driven signals.* 1. **`search-companies`** — Resolve the company name or partial ticker to a confirmed ticker symbol and retrieve top-level fundamental metrics such as P/E, margins, and revenue growth. 2. **`run-sql-query`** — Execute targeted SQL queries against Drillr datasets to retrieve detailed income statement, balance sheet, or cash flow data for the confirmed ticker. 3. **`fetch-trading-signal-list`** — Fetch current event-driven trading signals for the confirmed ticker to surface relevant news, macro, or M&A context alongside the fundamental data. ## Skill reference ### `search-companies` **Company Search API** — Searches a company database by name or ticker and returns matching records with market cap, valuation ratios, margins, and growth metrics. *Use when:* Use when an agent needs to look up a company by name or ticker symbol to retrieve financial metadata such as market capitalization, P/E ratios, gross profit margin, EBIT margin, revenue growth, ROE, and dividend yield. *Not for:* Do not use for real-time stock price quotes or live trading data; use a market data or exchange API instead. Not suitable for bulk financial statement retrieval. **Inputs:** - `query` (string, required) — Company name or ticker symbol to search for. - `limit` (integer) — Maximum number of results to return. **Returns:** Returns a results array with matched company records including ticker, company name, match reason, market cap, industry, P/E ratios (TTM and forward), gross profit margin, EBIT margin, revenue growth, ROE, and dividend yield, plus a total count. **Example:** `{"query": "AAPL", "limit": 5}` --- ### `run-sql-query` **Drillr SQL Runner** — Executes a read-only SQL query against Drillr financial datasets and returns column names plus row data as structured JSON. *Use when:* Use when an agent needs to query Drillr financial data (e.g. income statements, balance sheets, cash flows) using arbitrary SQL, and requires structured tabular results with explicit column names and row arrays. *Not for:* Do not use for write operations (INSERT, UPDATE, DELETE) or for real-time streaming price feeds; this is a single-shot read-only SQL execution endpoint. **Inputs:** - `sql` (string, required) — The SQL query string to execute against the Drillr database. Must be a valid SELECT statement. **Returns:** Returns a data object with a columns array of 90+ field names and a rows array of matching record arrays drawn from the financial_statements table. **Example:** `{"sql": "SELECT ticker, period_end, revenue, net_income, eps FROM financial_statements LIMIT 5;"}` --- ### `fetch-trading-signal-list` **Signal List API** — Returns a list of trading signals with headlines, summaries, scores, suggested tickers, sector tags, and source URLs for a given set of ticker symbols. *Use when:* Use when an agent needs structured trading signal data — including news-driven events, macro digests, and M&A activity — for one or more specific equity tickers to support analysis or decision-making. *Not for:* Do not use for real-time streaming price feeds or technical chart indicators; this returns event-driven narrative signals, not OHLCV or order book data. **Inputs:** - `tickers` (array, required) — List of ticker symbols to retrieve trading signals for. Each element is a string equity ticker (e.g. 'AAPL'). **Returns:** Returns a data.items array where each element is a signal with a headline, summary, score, suggested_tickers, sector tags, ISO timestamps, trigger source URLs, and a tags object with entity and event-type metadata. **Example:** `{"tickers":["AAPL","MSFT","NVDA","TSLA","AMD"]}` ---