@cyanheads/secedgar-mcp-server
Provides SQL analytics over materialized dataframes using DuckDB, enabling queries, joins, and aggregations on SEC filing data.
Click on "Install 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., "@@cyanheads/secedgar-mcp-serverGet financial data for Microsoft"
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.
Public Hosted Server: https://secedgar.caseyjhand.com/mcp
Tools
Eight tools for querying SEC EDGAR data, plus three for SQL analytics over the DuckDB-backed canvas dataframes those tools materialize:
Tool | Description |
| Find companies and retrieve entity info with optional recent filings |
| Full-text search across all EDGAR filing documents since 1993 |
| Fetch a specific filing's metadata and document content |
| Get historical XBRL financial data for a company |
| Form 3/4/5 insider transactions (buys, sells, grants, exercises) parsed from ownership XML |
| 13F-HR quarterly institutional holdings parsed from the information table |
| Fetch SEC XBRL frames for one concept × one period across all reporting companies |
| Discover supported XBRL concept names or reverse-lookup a raw tag |
| List canvas dataframes with provenance, TTL, and schema |
| Run a single-statement SELECT across dataframes |
| Drop a canvas dataframe by name. Opt-in via |
secedgar_company_search
Entry point for most EDGAR workflows — resolve tickers, names, or CIKs to entity details.
Supports ticker symbols (
AAPL), company names (Apple), or CIK numbers (320193)Optionally includes recent filings with form type filtering
Returns entity metadata: SIC code, exchanges, fiscal year end, state of incorporation
secedgar_search_filings
Full-text search across all EDGAR filing documents since 1993.
Exact phrases (
"material weakness"), boolean operators (revenue OR income), wildcards (account*)Entity targeting within query string (
cik:320193orticker:AAPL)Date range filtering, form type filtering, pagination up to 10,000 results
Returns form distribution for narrowing follow-up searches
When post-filter hits exceed the inline limit, the already-fetched EFTS window (entity-filtered when
ticker:/cik:is used) is materialized as adf_<id>dataframe — query it withsecedgar_dataframe_query
secedgar_get_filing
Fetch a specific filing's metadata and document content by accession number.
Accepts accession numbers in dash or no-dash format
Converts HTML filings to readable plain text
Configurable content limit (1K–200K characters, default 50K)
Can fetch specific exhibits by document name
secedgar_get_financials
Get historical XBRL financial data for a company with friendly concept name resolution.
Friendly names like
"revenue","net_income","eps_diluted"auto-resolve to correct XBRL tagsHandles historical tag changes (e.g., ASC 606 revenue recognition)
Automatic deduplication to one value per standard calendar period
Filter by annual, quarterly, or all periods
See
secedgar://conceptsresource for the full mapping
secedgar_get_insider_transactions
Surface Form 3/4/5 insider activity for a company by parsing ownership XML.
Reporting person, relationship to issuer (director, officer + title, 10% owner), and transaction date
Transaction code mapped to a readable type (purchase, sale, gift, award, exercise, …); shares signed by acquired/disposed
Price per share and shares owned after each transaction; covers non-derivative (open-market) and derivative (option/RSU) lines
Filter by
transaction_type(purchase,sale,all); scans newest filings first
secedgar_get_institutional_holdings
Surface 13F-HR quarterly institutional holdings by parsing the information table.
Pass an institution (CIK or name) to see what it holds, or a company CIK to find its own 13F filings
Per position: issuer name, CUSIP, market value (thousands USD), shares/principal, put/call, and investment discretion
Resolves the filing-manager name and reporting quarter from the cover page; target a specific quarter with
quarter(e.g."2025-Q4")total_holdings_in_filingreports the full position count beforelimit
secedgar_fetch_frames
Fetch SEC XBRL frames for one concept × one period across all reporting companies.
Same friendly concept names as
secedgar_get_financialsSupports annual (
CY2023), quarterly (CY2024Q2), and instant (CY2023Q4I) periodsInline response returns the top N ranked companies (sort + limit), with ticker enrichment
The full frames response (all reporters, typically 2k–10k rows) is materialized as a
df_<id>dataframe — query it withsecedgar_dataframe_query
secedgar_search_concepts
Discover supported XBRL concept names before querying financials or cross-company comparisons.
Search by friendly name, label, or raw XBRL tag
Filter by statement group (
income_statement,balance_sheet,cash_flow,per_share,entity_info) or taxonomyReverse-lookup raw tags like
NetIncomeLossto the supported friendly namesReturns the same catalog used by
secedgar_get_financials,secedgar_fetch_frames, andsecedgar://concepts
secedgar_dataframe_describe / secedgar_dataframe_query / secedgar_dataframe_drop
In-conversation SQL analytics over the dataframes that secedgar_fetch_frames, secedgar_search_filings, and secedgar_get_financials materialize on a shared DuckDB-backed canvas. Each data-returning call adds a dataset field with a df_XXXXX_XXXXX handle; pass that handle to secedgar_dataframe_query for joins, aggregates, window functions, percentiles — standard DuckDB SQL.
Read-only by default. Writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file table functions are rejected by the framework SQL gate. System catalogs (
information_schema,pg_catalog,sqlite_master,duckdb_*) are denied at the bridge layer so callers can't enumerate dataframes they don't already hold a handle for.secedgar_dataframe_dropis the only destructive tool and is opt-in (EDGAR_DATAFRAME_DROP_ENABLED=true); TTL handles cleanup otherwise.Per-table TTL. Each dataframe ages on its own clock (default 24h, override with
EDGAR_DATASET_TTL_SECONDS). The canvas itself uses the framework's sliding TTL.register_aschaining.secedgar_dataframe_querycan persist its result as a new dataframe (df_XXXXX_XXXXX) with a fresh TTL — pipe analyses without re-running the source query.
Resources
URI | Description |
| Common XBRL financial concepts grouped by statement, mapping friendly names to XBRL tags |
| Common SEC filing types with descriptions, cadence, and use cases |
Prompts
Prompt | Description |
| Guides a structured analysis of a public company's SEC filings: identify recent filings, extract financial trends, surface risk factors, and note material events |
Features
Built on @cyanheads/mcp-ts-core:
Declarative tool definitions — single file per tool, framework handles registration and validation
Structured output schemas with automatic formatting for human-readable display
Unified error handling across all tools
Pluggable auth (
none,jwt,oauth)Structured logging with request-scoped context
Runs locally (stdio/HTTP) from the same codebase
SEC EDGAR–specific:
Rate-limited HTTP client respecting SEC's 10 req/s limit with automatic inter-request delay
CIK resolution from tickers, company names, or raw CIK numbers with local caching
Friendly XBRL concept name mapping with historical tag change handling
Searchable concept catalog with statement-group metadata and reverse XBRL tag lookup
HTML-to-text conversion for filing documents via
html-to-textIn-conversation SQL analytics:
secedgar_fetch_frames,secedgar_search_filings, andsecedgar_get_financialsmaterialize their full upstream response as a DuckDB-backed canvas dataframe queryable viasecedgar_dataframe_queryNo API keys required — SEC EDGAR is a free, public API
Getting started
Public Hosted Instance
A public instance is available at https://secedgar.caseyjhand.com/mcp — no installation required. Point any MCP client at it via Streamable HTTP:
{
"mcpServers": {
"secedgar-mcp-server": {
"type": "streamable-http",
"url": "https://secedgar.caseyjhand.com/mcp"
}
}
}Self-Hosted / Local
Add the following to your MCP client configuration file.
{
"mcpServers": {
"secedgar-mcp-server": {
"type": "stdio",
"command": "bunx",
"args": ["@cyanheads/secedgar-mcp-server@latest"],
"env": {
"EDGAR_USER_AGENT": "YourAppName your-email@example.com",
"MCP_TRANSPORT_TYPE": "stdio"
}
}
}
}Or with npx (no Bun required):
{
"mcpServers": {
"secedgar-mcp-server": {
"type": "stdio",
"command": "npx",
"args": ["-y", "@cyanheads/secedgar-mcp-server@latest"],
"env": {
"EDGAR_USER_AGENT": "YourAppName your-email@example.com",
"MCP_TRANSPORT_TYPE": "stdio"
}
}
}
}For Streamable HTTP, set the transport and start the server:
MCP_TRANSPORT_TYPE=http MCP_HTTP_PORT=3010 bun run start:http
# Server listens at http://localhost:3010/mcpPrerequisites
Bun v1.3.0 or higher.
Installation
Clone the repository:
git clone https://github.com/cyanheads/secedgar-mcp-server.gitNavigate into the directory:
cd secedgar-mcp-serverInstall dependencies:
bun installBuild:
bun run buildConfiguration
All configuration is validated at startup via Zod schemas in src/config/server-config.ts. Key environment variables:
Variable | Description | Default |
| Required. User-Agent header for SEC compliance. Format: | — |
| Max requests/second to SEC APIs. Do not exceed 10. |
|
| Seconds to cache the company tickers lookup file. |
|
| Per-table TTL for canvas-registered dataframes. Sliding window touched on every dataframe op. |
|
| Set to |
|
| Canvas engine. Defaults to |
|
| Transport: |
|
| HTTP server port |
|
| Authentication: |
|
| Log level ( |
|
| Directory for log files (Node.js only). |
|
Running the server
Local development
Build and run the production version:
bun run rebuild bun run start:http # or start:stdioRun checks and tests:
bun run devcheck # Lints, formats, type-checks bun run test # Runs test suite
Docker
docker build -t secedgar-mcp-server .
docker run -e EDGAR_USER_AGENT="MyApp my@email.com" -p 3010:3010 secedgar-mcp-serverProject structure
Directory | Purpose |
| Tool definitions ( |
| Resource definitions. XBRL concepts and filing types. |
| Prompt definitions. Company analysis prompt. |
| SEC EDGAR API client, XBRL concept mapping, HTML-to-text conversion. |
| Adapter over the framework |
| Server-specific environment variable parsing and validation with Zod. |
| Unit and integration tests, mirroring the |
Development guide
See CLAUDE.md and AGENTS.md for development guidelines and architectural rules. The short version:
Handlers throw, framework catches — no
try/catchin tool logicUse
ctx.logfor logging,ctx.statefor storageRegister new tools and resources in the
createApp()arrays
Contributing
Issues and pull requests are welcome. Run checks and tests before submitting:
bun run devcheck
bun run testLicense
This project is licensed under the Apache 2.0 License. See the LICENSE file for details.
This server cannot be installed
Maintenance
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/cyanheads/secedgar-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server