Drillr — The financial MCP for AI agents

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'page': {'type': 'integer', 'minimum': 1, 'description': 'One-based page number. Default 1.'}, 'limit': {'type': 'integer', 'maximum': 10, 'minimum': 1, 'description': 'Results per page. Default 10, max 10.'}, 'since': {'type': 'string', 'description': 'Only return observations with update_date on or after this date. Use YYYY-MM-DD.'}, 'ticker': {'anyOf': [{'type': 'string', 'pattern': '^[A-Z0-9]+(?:[.-][A-Z0-9]+)*$', 'maxLength': 16}, {'type': 'array', 'items': {'$ref': '#/properties/ticker/anyOf/0'}, 'maxItems': 10, 'minItems': 1}], 'description': 'Optional US ticker filter, up to 10 symbols. Accepts one symbol or a list. Company names are not resolved.'}, 'company_name': {'type': 'string', 'maxLength': 200, 'description': 'Case-insensitive partial company-name match. Empty means no filter.'}, 'application_name': {'type': 'string', 'maxLength': 200, 'description': 'Case-insensitive partial application-name match. Empty means no filter.'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['query'], 'properties': {'query': {'type': 'string', 'minLength': 1, 'description': 'Natural-language company description'}, 'market': {'anyOf': [{'enum': ['us', 'jp', 'hk', 'cn', 'kr'], 'type': 'string'}, {'type': 'array', 'items': {'$ref': '#/properties/market/anyOf/0'}, 'maxItems': 5}], 'description': "Optional market filter. Pass one lowercase value or a list from 'us' | 'jp' | 'hk' | 'cn' | 'kr'. Omit or pass [] for all five; list order does not set priority."}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['ticker'], 'properties': {'ticker': {'type': 'string', 'description': 'Stock ticker, e.g. NVDA, 6758.T, 00700.HK, 600519.SH'}, 'filing_types': {'type': 'array', 'items': {'type': 'string'}, 'description': 'Filter by filing type. Omit for default (periodic reports + IPO/shelf registrations + amendments; excludes ad-hoc disclosures). Pass [] for all indexed types. Pass an explicit allowlist to override — use values from the `filing_type` column of a prior unfiltered call.'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['query', 'ticker'], 'properties': {'as_of': {'$ref': '#/properties/period_start', 'description': 'Publication cutoff date YYYY-MM-DD. Rows with missing published_at still appear; not a strict point-in-time snapshot'}, 'query': {'type': 'string', 'minLength': 1, 'description': 'Natural-language financial metric query'}, 'top_k': {'type': 'integer', 'maximum': 30, 'minimum': 1, 'description': 'Max results; 1-30, default 10'}, 'ticker': {'type': 'string', 'minLength': 1, 'description': 'Required. Canonical or historical ticker; one only. Resolve company names with ticker_lookup first'}, 'period_end': {'$ref': '#/properties/period_start', 'description': 'Calendar end date YYYY-MM-DD (calendar, not fiscal)'}, 'period_type': {'enum': ['instant', 'duration'], 'type': 'string', 'description': 'instant or duration'}, 'period_start': {'type': 'string', 'description': 'Calendar start date YYYY-MM-DD (calendar, not fiscal; resolve fiscal periods via financial_statements period_start/period_end)'}, 'fiscal_period': {'anyOf': [{'enum': ['Q1', 'Q2', 'Q3', 'Q4', 'H', '9M', 'FY'], 'type': 'string'}, {'type': 'array', 'items': {'$ref': '#/properties/fiscal_period/anyOf/0'}, 'maxItems': 7, 'minItems': 1}], 'description': 'Q1 | Q2 | Q3 | Q4 | H | 9M | FY, or a list of those'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['table_name'], 'properties': {'table_name': {'enum': ['financial_statements', 'company_snapshot', 'price_volume_history', 'earning_call_summary', 'insider_and_institution_activities', 'index_price', 'equity_extended_rt', 'analyst_ratings', 'analyst_ratings_consensus', 'earning_call_calendar', 'executive_profile', 'executive_compensation', 'executive_change', 'company_deal_events', 'debt_issuance', 'securities_offering', 'eia_generators', 'eia_retail_prices', 'eia_regional_hourly', 'epochai_data_centers', 'epochai_data_center_timelines', 'epochai_gpu_clusters', 'epochai_dc_cooling_towers', 'epochai_dc_chillers', 'epochai_chip_types', 'epochai_ml_hardware', 'epochai_chip_organizations', 'epochai_chip_sales_cumulative', 'epochai_chip_sales_by_chip', 'epochai_chip_sales_by_designer', 'epochai_chip_owners_cumulative_by_chip', 'epochai_chip_owners_cumulative_by_designer', 'epochai_chip_owners_quarters_by_chip', 'tsmc_revenue', 'twcustoms_trade', 'computeprices_gpus_dim', 'computeprices_gpu_offer_daily', 'computeprices_gpu_offers', 'computeprices_providers_dim', 'skypilot_ondemand_price', 'skypilot_spot_price', 'skypilot_instance_dim', 'epochai_models', 'epochai_benchmark_scores', 'epochai_benchmark_runs', 'epochai_ai_companies', 'epochai_ai_companies_revenue_reports', 'epochai_ai_companies_usage_reports', 'epochai_ai_companies_staff_reports', 'epochai_ai_companies_funding_rounds', 'epochai_ai_companies_compute_spend', 'epochai_polling', 'arena_leaderboard', 'litellm_price_history', 'litellm_models_dim', 'computeprices_llm_prices', 'computeprices_llm_price_daily', 'computeprices_llms_dim', 'comtrade_country', 'comtrade_hs_code', 'census_import_export', 'fred_series', 'fred_observations', 'fred_macro_daily', 'polymarket_events', 'polymarket_markets', 'polymarket_outcomes', 'polymarket_trades', 'polymarket_daily', 'polymarket_volume_daily', 'polymarket_holders_daily', 'kalshi_events', 'kalshi_markets', 'kalshi_trades', 'kalshi_daily', 'kalshi_volume_daily', 'mineral_deposit', 'mineral_deposit_commodity', 'mineral_deposit_operator', 'mineral_country_supply', 'mineral_critical_snapshot', 'fiscal_year_config'], 'type': 'string'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'page': {'type': 'integer', 'minimum': 1, 'description': 'One-based page number. Default 1.'}, 'limit': {'type': 'integer', 'maximum': 10, 'minimum': 1, 'description': 'Results per page. Default 10, max 10.'}, 'ticker': {'anyOf': [{'type': 'string', 'pattern': '^[A-Z0-9]+(?:[.-][A-Z0-9]+)*$', 'maxLength': 16}, {'type': 'array', 'items': {'$ref': '#/properties/ticker/anyOf/0'}, 'maxItems': 10, 'minItems': 1}], 'description': 'Optional company filter, up to 10 US ticker symbols. Returns themes where any supplied ticker is a source company or an affected company. Use symbols such as AAPL, not company names.'}, 'keyword': {'type': 'string', 'maxLength': 200, 'minLength': 1, 'description': 'Optional case-insensitive text contained in the theme name or research summary, up to 200 characters.'}, 'impact_companies': {'type': 'boolean', 'default': False, 'description': 'Include the per-company company_impacts list. Default false.'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'categories': {'type': 'array', 'items': {'enum': ['Energy & Power', 'Data Centers', 'Semiconductors', 'Compute Pricing', 'Model Development', 'Inference Economics', 'Macro & Trade', 'Prediction Markets', 'Critical Minerals', 'all'], 'type': 'string'}, 'maxItems': 5, 'description': 'Altdata category names (see tool description for the list). Omit, or pass "all", for the category index.'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'query': {'type': 'string', 'description': 'Semantic query (English). One of query/theme/ticker/since/until required.'}, 'since': {'type': 'string', 'description': 'ISO8601; filter time_event >= since.'}, 'theme': {'type': 'string', 'description': 'Theme word, resolved to the nearest canonical theme. Not valid with search_type=claims.'}, 'top_k': {'type': 'integer', 'maximum': 50, 'minimum': 1, 'description': 'Story count. Default 10, max 50.'}, 'until': {'type': 'string', 'description': 'ISO8601; filter time_event < until.'}, 'ticker': {'anyOf': [{'type': 'string'}, {'type': 'array', 'items': {'type': 'string'}}], 'description': 'Exact ticker symbol(s) — a single symbol, an array, or a comma-separated string; multiple tickers are an OR/overlap filter. Exchange-suffixed (AAPL, 7203.T, 600519.SH). Company names/brands are NOT resolved here.'}, 'order_by': {'enum': ['relevance', 'event_time', 'create_time'], 'type': 'string', 'description': 'Result ordering. relevance (default) | event_time (newest event time first) | create_time (most recently ingested first).'}, 'search_type': {'enum': ['all', 'events', 'claims'], 'type': 'string', 'description': 'all (default) | events | claims (opinions/statements only).'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['sql'], 'properties': {'sql': {'type': 'string', 'description': 'PostgreSQL SELECT query'}}, 'additionalProperties': False}

{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['query'], 'properties': {'query': {'type': 'string', 'minLength': 1, 'description': 'Company name or ticker substring (case-insensitive). Matches historical names + tickers too.'}, 'market': {'enum': ['us', 'jp', 'hk', 'cn', 'kr'], 'type': 'string', 'description': "Optional market filter: 'us' | 'jp' | 'cn'. Omit to search all markets."}}, 'additionalProperties': False}