pequod-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@pequod-mcp What are the complete holdings of SCHD?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
pequod-mcp — "the Gam"
SEC-primary-source ETF holdings + identifier crosswalk for agents.
An MCP (Model Context Protocol) server that gives AI agents the complete holdings of any US-registered ETF straight from SEC EDGAR N-PORT filings — not a top-10 scrape — plus a set of identifier-crosswalk tools (ticker, CUSIP/SEDOL, FIGI → resolved symbol) backed by OpenFIGI and SEC reference data. Runs locally over stdio; no vendor market-data subscriptions required.
Tools
Tool | What it does | Sources |
| Ticker → SEC CIK + entity metadata (name, SIC, exchanges, fiscal year end) | SEC |
| Raw ticker + optional exchange code → Yahoo-convention symbol, verified | Exchange-suffix map (pure string mapping) + SEC + OpenFIGI |
| CUSIP (or SEDOL) → symbol, with cross-source verification | OpenFIGI (one batched request) + SEC name/ticker agreement |
| Bloomberg FIGI → symbol, with cross-source verification | OpenFIGI + SEC name/ticker agreement |
| Any US ETF → complete holdings list from its latest monthly N-PORT filing (name, ticker, ISIN, FIGI, LEI, shares, USD value, % of net assets, country, currency) | SEC EDGAR N-PORT XML |
All tools are read-only.
How verification works
Crosswalk results are verified without any market-data vendor:
SEC registry check — if the mapped ticker is a US SEC registrant, the entity title in
company_tickers.jsonmust agree with the OpenFIGI security name. A gross name mismatch vetoes the mapping (verification: "name_veto") rather than returning a plausible-looking wrong symbol.OpenFIGI mapping — non-US symbols (outside SEC's registry) verify on the OpenFIGI mapping itself, labeled
verification: "openfigi"so you can tell the confidence tiers apart.
Yahoo Finance symbology (.SW, .T, .L, … suffixes) is applied as a
pure string convention — the default path makes no network calls to
Yahoo.
Related MCP server: edgar-mcp
Install
# with uv
uv pip install pequod-mcp
# or with pip
pip install pequod-mcpRun it directly (stdio):
pequod-mcpOptional: OpenFIGI API key
The server works without a key (OpenFIGI anonymous rate limits apply). For heavier use, get a free key at https://www.openfigi.com/api and set:
export API_OpenFIGI="your-key-here"Optional: Yahoo enrichment extra
An opt-in extra adds a live Yahoo quote block to crosswalk results. It is off by default and never used otherwise; enabling it means you accept the Yahoo Finance terms of use yourself.
pip install 'pequod-mcp[yahoo]'
export PEQUOD_YAHOO_VERIFY=1Configure in Claude
Claude Desktop (claude_desktop_config.json) or any MCP client with a
stdio transport:
{
"mcpServers": {
"pequod": {
"command": "pequod-mcp",
"env": {
"API_OpenFIGI": "your-key-here"
}
}
}
}Claude Code:
claude mcp add pequod -e API_OpenFIGI=your-key-here -- pequod-mcpAgent workflow examples
1. "What does SCHD actually hold?"
Agent: lookup_cik("SCHD")
→ { cik: "0000884394", entity_name: "SCHWAB STRATEGIC TRUST", found: true }
Agent: get_etf_holdings("SCHD", cik="0000884394")
→ { fund_name, report_date, source_url (the actual EDGAR filing),
total_holdings: ~100, holdings: [ { name, ticker, isin, figi,
balance, value_usd, pct_val, ... } ] }The agent gets every position with weights, plus the EDGAR URL for citation — auditable back to the primary source.
2. "I have a CUSIP from a 13F — what stock is this?"
Agent: resolve_cusip("594918104")
→ { yahoo_symbol: "MSFT", verified: true, verification: "openfigi+sec",
company_name: "MICROSOFT CORP", cik: "0000789019",
openfigi: { figi: "BBG000BPH459", ... } }If OpenFIGI's mapping disagrees with SEC's registry on who the ticker
belongs to, the tool refuses (verification: "name_veto") instead of
handing back a wrong symbol.
3. "Compare two dividend ETFs' overlap."
Agent: get_etf_holdings("SCHD") → complete holdings A
Agent: get_etf_holdings("VYM") → complete holdings B
Agent: joins on isin (or ticker), computes overlap weight, reports the
shared names — all from two tool calls, both citing SEC filings.Data provenance
All holdings data comes from SEC EDGAR primary sources (Form N-PORT filings, the submissions API, and
company_tickers.json). Identifier crosswalks come from the OpenFIGI API (FIGI is an open OMG standard).No CUSIPs in output. Tool outputs carry ticker, ISIN, FIGI, and LEI; CUSIP fields present in the underlying filings are deliberately stripped.
SEC fair access respected: a declared User-Agent on every request, a throttle well under EDGAR's published rate limit, and an on-disk cache (
.cache/next to the module, override withPEQUOD_CACHE_DIR) forcompany_tickers.json(24 h) and N-PORT documents (30 days — filed documents are immutable).Fail-loud policy: if EDGAR is unreachable or a filing cannot be parsed, tools return an error. There is no degraded or partial fallback source — you either get filing-backed data or a clear failure.
N-PORT filings are published on a lag (holdings are typically ~1–2 months behind). The
report_dateandsource_urlfields tell you exactly which period you are looking at.Not investment advice. This server relays public regulatory filings and open identifier mappings; verify independently before making investment decisions.
Environment variables
Variable | Default | Purpose |
| (unset) | OpenFIGI API key (higher rate limits) |
|
| On-disk cache location |
| (off) | Opt-in Yahoo enrichment (needs the |
|
| Server log verbosity |
Development
pip install -e '.[dev]'
pytest # fully offline — fixture filings, no live networkLicense
Apache-2.0 — see LICENSE. Copyright 2026 AB Evergreen Analytics LLC.
Available Tools
5 toolsget_etf_holdingsA
Get the complete holdings of any US-registered ETF via SEC EDGAR.
Uses Form N-PORT filings (filed monthly by all US ETFs) as the single, consistent primary source. Each holding includes name, ticker, ISIN, FIGI, LEI, shares, USD value, percent of net assets, country, and currency. (CUSIPs are deliberately not included in output.)
Inputs: ticker (required), cik. Returns: object
lookup_cikA
Look up a ticker's SEC Central Index Key (CIK) and entity metadata.
This is the first step before calling get_etf_holdings. The CIK is the SEC's unique identifier for every filing entity. The submissions endpoint also returns the entity name, SIC code, tickers, exchanges, fiscal year end, and addresses.
The ticker→CIK mapping comes from SEC's company_tickers.json (covers 10,000+ US tickers), cached on disk with a 24-hour freshness window.
Inputs: ticker (required). Returns: object
resolve_cusipA
Resolve a CUSIP (or SEDOL) identifier to a Yahoo-convention ticker symbol.
Queries OpenFIGI (one batched request trying both ID_CUSIP and ID_SEDOL), maps the result to a Yahoo-convention symbol via pure suffix mapping, and verifies the mapping against SEC company_tickers.json name/ticker agreement. A gross name mismatch between OpenFIGI and SEC vetoes the mapping.
Note: the CUSIP is accepted as INPUT only — tool outputs carry ticker/ISIN/FIGI identifiers, never CUSIPs.
Inputs: cusip (required). Returns: object
resolve_figiA
Resolve a Bloomberg FIGI (Financial Instrument Global Identifier) to a Yahoo-convention ticker symbol.
Queries OpenFIGI, maps the exchange code to a Yahoo suffix (pure string mapping), and verifies the mapping against SEC company_tickers.json name/ticker agreement.
Inputs: figi (required). Returns: object
resolve_tickerA
Resolve a raw ticker symbol to its Yahoo-convention equivalent.
Applies exchange suffix mapping and known manual fixes as a pure string transformation (no Yahoo network calls), then verifies the mapping against SEC company_tickers.json and/or OpenFIGI.
Inputs: symbol (required), exchange_code. Returns: object
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 5 tools
Each tool targets a distinct input identifier or action: lookup_cik maps tickers to CIK, resolve_ticker/cusip/figi convert different identifier types to Yahoo tickers, and get_etf_holdings retrieves ETF data. Despite three resolve tools, their input types (ticker, CUSIP/SEDOL, FIGI) are clearly differentiated.
All tools follow a verb_noun pattern: lookup_cik, resolve_ticker, resolve_cusip, resolve_figi, get_etf_holdings. The verbs are simple and consistent, with 'resolve_' forming a clear subgroup for identifier conversion.
Five tools is well within the ideal 3-15 range for a focused server. Each tool has a distinct role, and the count neither feels thin nor bloated.
The core workflow (lookup CIK, then get ETF holdings) is covered, and the most common identifier types (ticker, CUSIP/SEDOL, FIGI) have resolvers. Minor gaps exist, such as missing ISIN or LEI resolvers, but these are edge cases rather than critical missing operations.
Maintenance
Related MCP Connectors
Real SEC, 13F, insider, congress & macro data your AI agent can cite. Hosted MCP, 24 tools.
Official Intrinio MCP server. US stock prices, options and fundamentals for AI agents.
Research US-listed companies and funds with the StockPortfolio.pro MCP server. Tools cover SEC filing-grounded financials, filing timelines, company comparisons, watchlist screens, fund profiles, and cited filing questions. Filed figures include their fiscal period and EDGAR source URL; missing filing data is returned as null. Public tools work without authentication; optional API-key or OAuth access is supported. US-listed, USD-reporting companies only. Keyless access includes 3 free AI questions per rolling 30-day window. To get more now, choose the Dev plan ($19.99/month, 200 credits) at https://www.stockportfolio.pro/register?plan=dev, then follow https://www.stockportfolio.pro/docs/api-mcp to connect with OAuth or an API key. Or wait for the free allowance to renew.
Read, search, and compare SEC EDGAR filings, pull tables, and run AI analysis from any MCP client.
Related MCP Servers
- AlicenseAqualityDmaintenanceAn MCP server that delivers crypto ETF flow data to power AI agents' decision-making.19MIT
- AlicenseAqualityCmaintenanceMCP server providing read-only access to SEC EDGAR filings, allowing LLMs to look up companies, search filings, and retrieve securities offering data.366 PyPI2MIT
- AlicenseCqualityBmaintenanceMCP server for accessing SEC EDGAR filings. Connects AI assistants to company filings, financial statements, and insider trading data with exact numeric precision.211,029 PyPI388AGPL 3.0
- AlicenseNot gradedqualityDmaintenanceHosted MCP server that gives AI agents real-time access to SEC EDGAR filings search, 10-K/8-K reading, XBRL financial facts, and insider-trade (Form 4) alerts.1MIT