Tools

20 MCP tools available to subscribers. Most answer a question about one company. One, run_sql, queries the whole record at once: every company, every filing type, every year, in a single query. That is where the screens and market-wide questions live that no per-company tool can answer.

Each tool returns structured JSON. Every answer is drawn from disclosure filings on record; where a response carries a filing identifier, it resolves to the exact source document. Ticker-keyed tools include a company block (ticker, EDINET code, Japanese and English names, sector) so your agent never has to infer a company's identity from a ticker number.

Limits

SQL queries time out after 10 seconds and return at most 200 rows unless you set a lower LIMIT. Each API key may make 120 requests per minute. Responses that would exceed the size cap shrink and set "truncated": true.

A worked example

What is Elliott pushing for at Nippon Express?

get_holding_actions("9147")

{
  "success": true,
  "ticker": "9147",
  "company": {
    "ticker_4": "9147",
    "ticker_t": "9147.T",
    "edinet_code": "E36706",
    "name_jp": "ＮＩＰＰＯＮ　ＥＸＰＲＥＳＳホールディングス株式会社",
    "name_en": "NIPPON EXPRESS HOLDINGS, INC.",
    "sector": "Land Transportation"
  },
  "truncated": false,
  "filings": [
    {
      "date": "2026-05-20",
      "filer": "エリオット・インベストメント・マネージメント・エルピー（Elliott Investment Management L.P.）",
      "pct": 6.05,
      "purpose": "Consideration of a new M&A strategy and profit improvement plan; Real estate spin-off; Partial sale (including potential sale and leaseback transactions) and/or other methods to monetize real estate a",
      "filer_name_en": null,
      "filer_sector": "Others",
      "is_joint_filing": false,
      "joint_holder_count": 1,
      "change_proposals": [
        "Consideration of a new M&A strategy and profit improvement plan",
        "Real estate spin-off",
        "Partial sale (including potential sale and leaseback transactions) and/or other methods to monetize real estate and unlock its intrinsic value",
        "Capital allocation to a large-scale share buyback program"
      ]
    }
  ]
}
# (single filing in the past 12mo window — nothing else was cut)

The response names the filer, the stake, and the filing date. The filing behind it is EDINET document S100Y53L, on the public record. Every answer traces back to a specific filing.

Company & financials

get_capital_policy(ticker: str) -> str

get_cashflows(ticker: str) -> str

get_filing_text(ticker: str, section: Optional[str] = None) -> str

get_financials(ticker: str) -> str

get_quality_trends(ticker: str) -> str

get_related_party_transactions(ticker: str) -> str

get_segments(ticker: str, period: str = 'latest') -> str

Ownership & stakes

get_cross_holdings(ticker: str) -> str

get_holding_actions(ticker: str) -> str

get_large_holder_timeline(ticker: str, window_months: int = 36) -> str

get_large_holders(ticker: str) -> str

get_ownership(ticker: str) -> str

get_shareholder_register(ticker: str, periods: int = 3, include_changes: bool = False) -> str

Events & signals

get_buybacks(ticker: str) -> str

get_material_events(ticker: str) -> str

get_tender_offer_history(ticker: str) -> str

Filing index & query

find_companies(search_term: str) -> str

get_briefing() -> str

get_filings(ticker: str, window_months: int = 24, doc_type: str = None) -> str

run_sql(sql: str) -> str

Two things worth knowing

Filing year vs fiscal year. A securities report filed in June 2025 covers the fiscal year ended March 2025. Filters on filing dates and fiscal-year-end dates answer different questions.

Ticker formats. Tools take the 4-digit code (7203). In SQL, securities_reports.ticker carries a .T suffix (7203.T) and registry tables carry the 5-digit securities code (72030) — the canonical_company_ids view resolves any format.