SPACInsider

Resolve a participant name to one canonical standardized name — use before participant_spacs. Case, punctuation and spacing are ignored ("White & Case LLP" finds WHITE CASE LLP, "J.P. Morgan" finds JP MORGAN) and % and _ are literal. An exact match wins, then the name as whole words of a stored name, then as any substring; ties go to the participant linked to the most SPACs, then the shorter name. Returns {name, raw_name, match} where match is exact, word or substring; a word or substring match is a guess, so check it or use participant_search for the alternatives. No match is an error naming the closest participants.

participant_get

Search participants by name fragment. Returns JSON rows of matches; default limit 10.

participant_search

SPACs tied to a participant. Returns JSON SPAC rows. Omitting relationship counts EVERY role the participant has (sponsor, underwriter, investor, ...) and overcounts any single one — pass relationship=underwriter for "how many SPACs has X underwritten". Filter the linked SPACs with statuses, industries, or `condition`; rank with sort_by + sort_dir (unsorted order is not a ranking). Use count_only for totals. A name that is not a known participant is an error naming the closest standardized names.

participant_spacs

Private placement league for an announced_date window. Returns JSON rows, ranked by total_funding_proceeds_raised_mm, which holds dollars despite its name.

leagues_private_placement

List 13F filings from the SEC pipeline (accession_number, cik, company, date_filed). Filter by cik and/or date_filed window. Use count_only for totals. Not for SPAC universe IPO counts — use spac_list + ipo_date_* instead.

sec_13f_filing_list

Summary for one 13F filing (period_of_report, table_entry_total, table_value_total) by accession_number.

sec_13f_filing_summary

The SPAC and de-SPAC positions in one 13F filing: its line items whose security is a SPAC or a company that merged with one, not the whole portfolio (Berkshire Hathaway's filings return none). filing_entry_total is the filing's full line-item count, so a client can say how much of the portfolio this is. Requires accession_number from sec_13f_filing_list.

sec_13f_holdings_list

Point-in-time SPAC market snapshot as of a past date (SPAC History). Requires as_of_date (YYYY-MM-DD, single past date — not today or future, no ranges). Do not use spac_list for historical universe questions — use this tool. Optional filters: cik, spac_status, spac_name, spac_share_symbol, industry, special_status, sub-industry, target_company, despac_share_symbol, announced_date_start/end; free-form `condition` (data_discover topic=condition_dsl); sort_by + sort_dir to rank (unsorted order is by cik, not a ranking). Default limit 10. Snapshots taken before 2026-09-30 may carry an "ANNOUNCED " prefix on target_company / archived_combination. SPAC History runs from its first to its latest snapshot (mcp_health history_earliest_snapshot / history_latest_snapshot): a date outside that range is an error, and a window that runs past either end returns earliest_snapshot or latest_snapshot.

spac_history_list

Aggregations over a point-in-time SPAC History cohort — count/sum/avg/min/max, or a time series — in ONE call, instead of paging raw rows from spac_history_list and reducing them client-side. Anchor in time (mutually exclusive): as_of_date for a single snapshot, or ts_start/ts_end for a window (required for a date_histogram time series). Over a ts_start/ts_end window each SPAC counts once, at its latest snapshot in the window that matches the filters (per bucket for a date_histogram; a day interval keeps every snapshot), so min, max and avg describe those snapshots, not every day: Q1's lowest share_close_price needs interval day, or spac_history_by_cik for one SPAC. Filters apply before that pick, so a SPAC counts in a window or bucket if it matched on any day in it: spac_status=SEARCHING by quarter counts every SPAC that was searching at some point in the quarter, not at quarter end; for status on a date use as_of_date. Cohort filters as spac_history_list, plus a ciks set (pipe in a current-universe cohort from spac_list) and free-form `condition` (data_discover topic=condition_dsl). The aggs body is an Elasticsearch-style subset — see data_discover topic=aggregates. Snapshots taken before 2026-09-30 may carry an "ANNOUNCED " prefix on target_company / archived_combination. SPAC History runs from its first to its latest snapshot (mcp_health history_earliest_snapshot / history_latest_snapshot): a date outside that range is an error, and a window that runs past either end returns earliest_snapshot or latest_snapshot.

spac_history_aggregate

Point-in-time history for ONE SPAC by CIK. Pass start_date and/or end_date for a date-range window (e.g. closing prices over time), as_of_date for a single snapshot, or none for the full timeline (newest first). as_of_date is mutually exclusive with start_date/end_date. All dates are past calendar dates (YYYY-MM-DD). For the whole universe at one date use spac_history_list instead. Filter snapshots with `condition` (data_discover topic=condition_dsl). Default limit 10 — paginate for scans. Snapshots taken before 2026-09-30 may carry an "ANNOUNCED " prefix on target_company / archived_combination. SPAC History runs from its first to its latest snapshot (mcp_health history_earliest_snapshot / history_latest_snapshot): a date outside that range is an error, and a window that runs past either end returns earliest_snapshot or latest_snapshot.

spac_history_by_cik

Fetch one SPAC by CIK. Returns a single JSON object. Use spac_search first if you only have name or ticker.

spac_by_cik

Compact SPAC profile for a CIK (fixed column set: status, symbols, key dates, and spac_page_url — the absolute SPACInsider profile link to cite as the source). extend=trust adds trust/proceeds columns (IPO size = total_public_proceeds) plus share_close_price and current_implied_cash_per_share for the cash-backing comparison. Returns one JSON object.

spac_profile

List participants linked to a SPAC CIK for a relationship type (e.g. sponsor, underwriter). Returns JSON rows; paginate with limit/offset.

spac_relationship

Resolve names, symbols, or CUSIPs to CIKs. Requires at least one of names, symbols, or cusips (each an array of non-blank strings). A name matches any SPAC name containing it (% and _ are literal); a symbol must equal a stored unit, share, warrant, right or de-SPAC symbol (any case); a CUSIP must match exactly. Returns the best match per term: term -> {query -> cik}, e.g. {"name": {"Churchill": "0002074973"}}, and unmatched lists the terms with no match — not full SPAC rows. Follow with spac_by_cik or spac_profile.

spac_search

Aggregations over the CURRENT SPAC universe — count/sum/avg/min/max, or a distribution over time — in ONE call, instead of paging raw rows from spac_list and reducing them client-side. Same cohort filters as spac_list (ciks, statuses, industries, ipo_date_*, announced_date_*, closing_date_*) plus free-form `condition` (data_discover topic=condition_dsl). A date_histogram bins by ANY date field, bounded either by that field's range filter (e.g. ipo_date_start/end) or by inline 'min'/'max' (YYYY-MM-DD) inside the date_histogram (the window filters the cohort and caps the bucket count). For a point-in-time snapshot use spac_history_aggregate. The aggs body is an Elasticsearch-style subset — see data_discover topic=aggregates.

spac_aggregate

List SPAC rows from the universe. IPO-year totals: ipo_date_start/end + count_only (not corporate_action_list). Also filter by ciks, statuses, industries, announced_date_start/end; columns via CSV; free-form `condition` (data_discover topic=condition_dsl). Rank with sort_by + sort_dir (e.g. sort_by=total_public_proceeds for the largest) — without a sort, row order is by cik and is NOT a ranking. Default limit 10 — paginate for scans; the response carries row_count and truncated (true only when more rows exist after this page).

spac_list

Serial sponsor league for an announced_date window (completed deals, sponsor groups with more than one). Returns JSON rows. A SPAC tagged with several sponsor groups (e.g. an owner and their team) counts toward each group, so two rows can carry identical figures — never sum deal_count across rows for a market total. Ranked by avg_return_on_share_price, a percent: (unadjusted de-SPAC share price - trust per unit) / trust per unit x 100. avg_share_price is the adjusted de-SPAC share price in dollars, and avg_percent_redeemed is a 0-1 fraction.

leagues_serial_sponsor

Aggregations over terminated De-SPAC deals — count/sum/avg/min/max, or a distribution over time — in ONE call, instead of paging raw rows from terminations_list. Optional cohort filters: cik, termination_date_start/end. Group by terminated_target_industry with a terms bucket, or bin termination_date with a date_histogram (bounded by termination_date_start/end). Example: {"by_industry": {"terms": {"field": "terminated_target_industry", "size": 20}, "aggs": {"avg_equity": {"avg": {"field": "pro_forma_equity_value"}}, "n": {"value_count": {"field": "cik"}}}}}. The aggs body is the same Elasticsearch-style subset as spac_aggregate — see data_discover topic=aggregates.

terminations_aggregate

Terminated De-SPAC deals — original announcement date, terminated target name, termination date, pro-forma equity/enterprise value, and terminated target industry. Filter by cik and/or termination_date_start/end. Use count_only for totals; sort_by + sort_dir to rank (e.g. sort_by=pro_forma_equity_value, sort_dir=desc for the largest terminated deals). For termination counts/averages grouped by industry use terminations_aggregate.

terminations_list

Return SPACInsider MCP usage text. Use topic=workflow or dates before guessing; topic=anti_patterns for do-not-use table (includes spac_history_list vs spac_list). Not overview-only loops. Response is markdown in JSON text content.

get_usage_guide