Release notes

v1.0.7

ADVmcp is a public explorer for SEC Form ADV data, served over the Model Context Protocol. Entries are dated; figures quoted in an entry reflect that release.

v1.0.7

27 October 2026

A second filing, kept separate. Form 13F is where managers with over $100 million in certain exchange-traded securities report their holdings each quarter. It is not part of Form ADV and it is not a firm's assets — but where the two can be linked, both are now on the same profile, each labelled with its own filing and its own date.

New: 13F holdings as filed

A profile now shows every Form 13F filer linked to that adviser, and the link is deliberately narrow: a filer appears only when the 13F cover page carries the firm's CRD or its SEC (801-) file number. Name-only matches are never shown. For each linked filer the section gives the filer name and CIK, how it was linked, the form type, the period of report and filing date, the filed 13F value with its entry count, the previous quarter's filed value beside it, the top positions exactly as reported, and a link to that filer on 13fmcp.ai.

One CRD can reach several filers; each is shown on its own and their values are never added together. A notice filing (13F-NT) says so plainly — those holdings were reported by another manager and are not attributed to this firm. Amendments are marked, with figures as stated in the amended filing.

The one figure computed here

Where a firm has both filings, the section shows filed 13F value divided by filed regulatory AUM, marked derived with both dates underneath. It is the only number this site calculates from the two, it is left out for notice filings and when AUM is missing or zero, and a result above 100% is reported as computed rather than trimmed — a firm can report 13F assets that sit outside its regulatory AUM, or the two filings can simply be dated differently.

What 13F is not

Form 13F covers Section 13(f) securities only: mainly exchange-listed equities, ETFs, and certain options and convertibles. Bonds, mutual funds, cash and private funds sit outside it. So a filed 13F value is not assets under management and not a portfolio, and the two figures answer different questions on different dates — 13F at a quarter end, regulatory AUM as of the firm's ADV filing. Nothing here infers performance, revenue, or value from holdings.

How to get it

  • get_firm now accepts include:["holdings"], and include:["brochure","holdings"] for both at once. The response adds a holdings_13f block with the same fields the page shows. Called without it, get_firm returns exactly what it returned before, byte for byte.
  • Firm pages: a 13F holdings as filed section under the profile figures, carrying the scope note and the derived ratio labelled the same way.
  • server_info reports the 13F source, the base it fetches from, when this server last pulled a filing successfully, and the latest period loaded — so a connected assistant can tell what is present before it answers a holdings question.

Fetched on request, and it never breaks a profile

13F data is pulled for one firm at a time, at the moment it is asked for, from 13fmcp.ai. A slow or missing upstream answer degrades to a labelled unavailable note, so the filed Form ADV profile and every other block still arrive.

Skills

The ADV Field Guide (v1.5.0) now explains Form 13F against Form ADV regulatory AUM — what each filing covers, why the values differ, and how the derived ratio must be labelled — and Firm Due-Diligence Brief (v1.4.0) adds a short holdings section to its brief, reported per filer. Both were appended to; no existing guardrail was changed. Skills are fetched at call time, so this reached already-connected clients with no refresh.

No change to the connection

The tool surface is still nine tools and the endpoint is unchanged — https://advmcp.ai/mcp, no account or key. What is new is one value on an existing input: get_firm's include parameter also takes "holdings". A client that never re-reads the tool list will not know it exists, so reconnect once to see it; skills need no refresh at all.

What's next

Current-year brochures — the access request is still with the SEC — and deeper 13F history per filer as the upstream dataset extends.

v1.0.6

24 October 2026

The other half of the filing. Form ADV Part 1A reports what a firm holds; Item 5 of its Part 2A brochure is where the firm says what it charges. That language is now here — quoted exactly, next to the sentence it came from — for 13,343 advisers.

New: fees as stated in the brochure

A firm's fee schedule is not a Form ADV number. It lives in prose, in the brochure a firm must deliver to clients. ADVmcp now stores each firm's latest available Part 2A brochure, its text page by page, and a fee schedule read from Item 5: tier floors and ceilings, rates, flat amounts, billing frequency, minimums, and whether the firm says its fees are negotiable.

Every row carries the verbatim sentence it was taken from and the page it sits on. A deterministic check rejects any stored figure that does not appear in its own excerpt, so a number can never be read into language that does not contain it. Nothing is filled in: no assumed tiers, no blended rate, no typical case. Where a brochure only says fees are negotiable, that is what is reported, with the sentence. Stated schedules are never multiplied by reported assets here — a fee schedule and an AUM figure are reported side by side and left that way.

What is covered, and what it is not

The dataset holds 18,850 documents for 14,309 firms, of which 13,343 have a selected primary Part 2A; supplemental documents such as wrap-fee appendices are kept but never treated as a firm's primary brochure. Fee language sits in 38,251 rows across 12,742 firms: 16,978 rows carry a figure and 21,273 are fee language kept as quoted text because it could not be reduced to one without guessing. Of the primary brochures, 2,797 yielded a readable schedule, 1,625 state fees without a schedule, 8,315 hold fee language kept as quoted text, 603 have no Item 5 heading the extractor could find, and three need OCR.

These are the latest documents available from the SEC's official 2024 archive bundles — the only source of brochure files this site may fetch automatically. So each brochure is the newest one we can load, not necessarily a firm's current year fees: the profile shows the brochure's own date, and where the firm's public adviser record lists a newer brochure, the page and the tool say so and link to it. No brochure PDFs are stored — only the source link, version, filing date, page count, content hash, and retrieval date.

How to get it

  • get_firm accepts an optional include:["brochure"]. The response then adds a brochure block — metadata, the IAPD link, and the fee rows with excerpts and page numbers — labelled as stated in the firm's Part 2A brochure. Called without it, get_firm returns exactly what it returned before, byte for byte.
  • Firm pages: a Fees as stated in brochure section with the schedule, the excerpt and page behind each row, the brochure date, a link to the brochure on IAPD, and a note when a newer brochure is on file.
  • server_info now reports brochure coverage and when the dataset was last loaded, so a connected assistant can tell what is and is not present before it answers a fee question.

Skills

fee-schedule-read (v1.0.0) is a new guided workflow: it presents a firm's stated schedule beside the sentences it came from, names the gaps that definitions leave (a stated schedule is not what a client actually pays; household versus account billing; negotiable fees), and never computes a blended rate, revenue, or a value, and never calls a fee high, low, or competitive. The ADV field guide (v1.4.0) now explains Part 2A against Part 1A, Firm Due-Diligence Brief (v1.3.0) pulls the brochure when the question is fees, and Verify a Claim (v1.2.0) checks a stated fee against the schedule. Skills are fetched at call time, so this reached already-connected clients with no refresh.

Interface and access

  • The site now sets in Schibsted Grotesk with Martian Mono for figures and code, aligned with ValuationMCP.
  • The header was rebuilt for phones: larger tap targets and a full-width ADV Analyst action, verified at several phone widths and on desktop.
  • The admin dashboard now signs in the same way the ADV Analyst does, and an account with access sees an Admin link in the Analyst sidebar instead of a separate password login.
  • On firm pages the Analyst prompt is now a quiet Discuss this firm link under the feed vintage line, so it no longer competes with the button in the header.

Fixes

  • Opening a saved Analyst conversation again shows its full history rather than the snapshot taken when it first loaded, so a returning session no longer writes over newer messages.
  • Cohort percentile calls were given the indexes they were missing, so a national cohort answers consistently instead of intermittently running past its time limit.

No change to the connection

The tool surface is still nine tools and the endpoint is unchanged — https://advmcp.ai/mcp, no account or key. One input is new: get_firm's include parameter. A client that never re-reads the tool list will not know it exists, so reconnect once to see it; skills need no refresh at all.

What's next

Current-year brochures. The SEC's bulk archive of brochure files stops at December 2024 and IAPD's brochure files are not open to automated retrieval, so an access request is with the agency. Until an official source exists, fee figures stay dated to the newest brochure this site may lawfully load, and the on-demand check keeps flagging firms that have filed something newer.

v1.0.5

15 October 2026

A free way to use ADVmcp without connecting anything. The same tools and skills that serve Claude or Cursor now answer questions on this site, in plain language, for anyone who can click a link.

New: the ADV Analyst

Sign in with Google, a Lovable account, or email and password, then ask something like "Run a due-diligence brief on Modera Wealth Management" or "Who should we acquire in Texas?". The Analyst works the question the way a connected assistant does — searching advisers, reading a filed profile, comparing a firm with its peers, checking what changed between filings — and writes a short brief. Every lookup it makes appears as a step you can open to see exactly what it pulled.

It calls the same tool definitions the MCP server exposes, in-process, so a figure has one source of truth whether it arrives through a connection or through this page.

Where it appears

  • Every page: an Ask the ADV Analyst button in the header, marked free.
  • Home page: a section introducing it with three sample questions to click, for visitors who have no AI assistant and want no setup.
  • Firm pages: a button that opens the Analyst with a due-diligence question about that firm already typed in. Nothing runs until you press send.

Saved sessions

Each investigation gets its own page in a side list, stored against your account. Come back to it, ask a follow-up, or delete it. A question clicked from a firm page survives signing in, so nothing is lost while making an account.

Guardrails and fair use

The Analyst carries the same hard rules as the skills: every figure comes from a tool result and is reported exactly as filed with its as-of date; revenue, profitability, and valuation figures are out of scope; a brief is never an endorsement or advice. Each signed-in visitor gets 30 questions an hour and 100 a day.

No change to the connection

The tool surface is still nine tools and the endpoint is unchanged — https://advmcp.ai/mcp, no account or key. Already-connected clients need no refresh for anything in this release.

v1.0.4

7 October 2026

Three more filed counts, wider screening, and a faster cohort engine. Every addition is an optional parameter or an extra output field on an existing tool — the nine-tool surface is unchanged.

New filed fields

Firm profiles and search rows now carry the number of qualified custodians (Item 9.F), employees performing advisory functions (Item 5.B(1)), offices other than the principal office (Item 1.F(5)), and the Item 5.K(3) answer. Each is shown exactly as filed and left blank when not filed. See the methodology page for what each count does and does not include.

Screening and paging

search_firms gains filters for custodians, advisory employees, offices, and client count, plus a cursor to page beyond 50 rows. firm_changes gains a screen mode: leave out the CRD number and screen every adviser for filed changes in one field by size of change, window, date, state, retail status, or AUM. Each row shows both filing dates and flags windows longer than 45 days. A filed difference is never presented as a reason.

Cohort statistics

cohort_stats now answers for the whole national population, including retail-only, where it previously timed out. It adds percentiles for the three new counts, a coverage figure for every measure, and base rates (2+ and 3+ custodians, 5+ advisory employees, 2+ offices, 5.K(3) = yes) that each state their denominator. Filters for custodians, advisory employees, offices, and client count match search.

Skills

The ADV field guide, Firm Due-Diligence Brief, and Peer Benchmark skills now explain the new fields. Skills are fetched fresh on every call, so no reconnect is needed for them. To see the new tool parameters, refresh or reconnect ADVmcp in your assistant once.

v1.0.3

4 September 2026

A presentation standard for how skills render their output — no change to any filed figure or to the tool surface.

New reference skill: Presentation Contract

presentation-contract is a house rendering standard every guided workflow now loads. It sets three rules for how an answer is laid out: lead with the answer rather than burying it in a paragraph; put any set of three or more parallel figures — firm attributes, cohort percentiles, a ranked shortlist, filing-history changes — in a table rather than a comma-run of a sentence; and collect the caveats (exactly as filed, definitional gaps, the coverage a screen did not walk, not an endorsement) into one block at the end. It governs layout only, and never changes what a tool reported or how it is filed.

It is wired as a dependency into all six guided workflows — Firm Due-Diligence Brief, RIA Acquisition Screen, Peer Benchmark, Custody & Disclosure Triage, Filing Change Monitor, and Verify a Claim — on top of each skill's own output_contract sections. Skills are fetched at call time, so this reached every already-connected client immediately: no reconnect, no tool-surface change.

v1.0.2

1 September 2026

A hardening and drift-detection follow-up to v1.0.1, plus one new guided skill.

New skill: Verify a Claim

verify-a-claim takes a public claim about an adviser — a website line, a pitch deck, a recruiter email — and puts it beside what the firm actually filed. It returns one of four verdicts: supported by the filing, differs from the filing, not on the form, or depends on definitions. Dates are attached to every comparison, and definitional gaps are named before any gap is reported.

The skill reports what the filing says and stops. It never characterises a claim as false or misleading, and a gap is a question for the firm rather than a finding.

This is the other half of the design v1.0.2 was about. Tools are cached at connection time, so adding server_info forced a one-time reconnect. Skills are fetched at call time, so a new guided workflow reaches every already-connected client immediately — no refresh, no reinstall.

Refreshing a client connected on v1.0.0

MCP clients read the tool list once, at connection time, and most never re-read it. A connection made on v1.0.0 still sees only the original four tools and none of the guided skills. A new server_info tool reports this server's live version, tool count, and tool names so an assistant can detect the drift itself and say so.

  • Cursor: Settings → MCP → toggle ADVmcp off and on, or hit refresh on the connection.
  • Claude: quit and reopen the app, or disconnect and re-add the connector.
  • Other clients: reconnect the server so it re-runs the handshake and re-reads tools/list.

The endpoint is unchanged — https://advmcp.ai/mcp, no account or key. Skills need no refresh at all: they are fetched at call time, so list_skills and get_skill always serve the latest versions to an already-connected client.

Reliability & trust hardening

  • Tool errors now return a short generic message instead of raw database detail, with the real error logged server-side — nothing about the database's internals leaks to a connected client.
  • Every tool's output schema is now explicit: responses describe exactly the filed columns they return (the cohort tools' statistics documents stay flexible by design, since their measure keys vary with the data). Nothing about the returned data changed — it is now precisely described, so clients can validate what they receive.
  • server_info joined the tool list (tool #9), reporting the server's live version, tool list, and skills catalog state so an assistant can detect a stale client cache on its own.
  • Every tool call now writes an audit record — tool, timing, outcome, and a parameter fingerprint (never the parameters themselves) — giving the server an examiner-grade usage trail.

v1.0.1

24–25 August 2026

This release expands the MCP tool surface from four to seven, ships 9 guided skills, extends the filing-history record back to April 2021, and fixes data-integrity issues found since launch.

Tools — from four to seven

The MCP surface grew from four tools to seven. Two of the additions serve the skills catalog below; the third makes cohort math a single call.

  • list_skills and get_skill — discover the guided workflows this server ships, and load one's full instructions at the moment it is needed. Nothing is installed and nothing is copied; an updated skill reaches every connected assistant on the next call.
  • cohort_stats — percentile benchmarking used to require walking a cohort page by page: a 193-firm band took four calls, a national one dozens. This tool computes the distribution server-side in one call — define a cohort by state, AUM band, and retail flag, and it returns the cohort size, summed AUM, custody and disclosure base rates, and p10/p25/p50/p75/p90 for eleven filed or derived measures: AUM, clients, accounts, employees, firm age, AUM per client, per account, and per employee, accounts per client, clients per employee, and discretionary share. Only approved registrants with reported AUM are counted, so exempt reporting advisers never distort a ratio.

The existing tools got richer payloads. search_firms and top_firms now return discretionary AUM alongside total AUM, the custody and disclosure flags, and each firm's registration date — so screening that previously needed a get_firm call per candidate can be done from the search results directly, and a peer list brings firm ages with it.

Skills — guided workflows the server ships itself

Skills are written procedures for Form ADV work — what to pull, in what order, and what not to say. A connected assistant reads them from the server via the two catalog tools above:

  • Form ADV Literacy — What every field on Form ADV actually means, and which conclusions the filing does and does not support.
  • Presentation Contract — The house rules for rendering any Form ADV output — lead with the answer, tabulate parallel figures, keep positions and caveats honest, and collect caveats at the end. Layout only; it never changes a filed figure.
  • Firm Due-Diligence Brief — A one-page read on any registered adviser: business shape, fee model, custody, disclosures, and the questions the filing cannot answer.
  • RIA Acquisition Screen — Turn an acquisition thesis into a ranked, evidence-backed shortlist of registered advisers — and an honest list of what the ADV cannot tell you about them.
  • Peer Benchmark — Place one adviser against a defined cohort as percentiles rather than adjectives — eleven distribution measures and two base rates in a single cohort_stats call, composition against named peers, and five years of filed trajectory (April 2021 – August 2026).
  • Custody & Disclosure Triage — Run a roster of advisers against Item 9 custody and Item 11 disclosure answers, and rank what actually needs a human to look at it.
  • Filing Change Monitor — Watch a list of advisers and report what actually changed between filings — separating real events from restatements, routine lifecycle, and noise. Filing history runs April 2021 to August 2026: 33 dated comparison points, month-over-month for most of it and daily since 12 August 2026.
  • Verify a Claim — Check a public claim about an adviser against what the firm actually filed — supported, differs, not on the form, or a definitional gap, with dates attached and no accusations.
  • Read a stated fee schedule — Presents a firm's fee schedule exactly as stated in its Part 2A brochure, each figure beside its verbatim excerpt and page.

Every skill carries explicit guardrails, published alongside it on the home page. They report figures exactly as filed, never estimate a number a firm did not file, and never characterise a disciplinary disclosure beyond what the filing literally says.

Two skills were rebuilt during this release to use the new tooling. Peer Benchmark (v2.1.0) runs its distribution tier in a single cohort_stats call, gained firm age as a measure, made national cohorts practical, and — with real percentile points to place against — now reports positions as brackets ("between p50 and p75") rather than implying single-digit precision the data does not support. Form ADV Literacy (v1.1.0) picked up the new tool in its reference.

Filing history now reaches back to April 2021

The change log was a fortnight deep at launch. It now spans April 2021 to August 2026 — 33 dated comparison points across 566,393 dated firm records, holding 163,317 filed changes on 27,881 advisers.

Coverage is not continuous, and the record says so rather than implying otherwise:

  • April 2021 to October 2022, month over month.
  • A single bridging comparison spanning October 2022 to May 2025.
  • A single bridging comparison spanning May 2025 to December 2025.
  • December 2025 to August 2026, month over month.
  • Daily from 12 August 2026.

A change recorded on one of the two bridging comparisons is real — the filed values genuinely differ between those dates — but the timing within the window is unknown. Every change row carries both the date it was recorded and the date it was compared against, so the window is always visible.

The deeper record makes the annual filing cycle measurable. Advisers must file an annual updating amendment within 90 days of fiscal year end, so calendar-year firms cluster in Q1. April 2026 recorded 12,171 AUM changes; April 2022, four years earlier, recorded 11,224, against 565 to 3,864 total changes in every other month of that year — roughly thirty times a normal month, in two independent years. A restatement filed in April means something different from the same restatement filed in July, and the Filing Change Monitor now reads it that way.

Two further patterns emerged at this depth. Of 1,341 registration status changes across the whole record, 1,339 are a newly registered adviser's 120-day provisional status maturing into full approval — routine lifecycle rather than news. Disclosure flips are the rare, high-signal type: 1,237 in five years, against 47,690 AUM changes, and roughly two in five are removals rather than additions.

Roughly 49 monthly rosters since 2020 remain uningested. The SEC published those months as XLSX workbooks whose sheet data runs to about 137 MB uncompressed, which the ingest worker cannot parse inside a single request; a two-phase reader is the planned fix. Two further months are SEC placeholders containing no data.

Data integrity fixes

Several defects were found and corrected:

  • firm_changes returned an error on every call. It sorted on a column that does not exist in the table; the tool had never worked. Fixed.
  • Unscoped name searches in search_firms could exceed the query timeout. A stored search column with a trigram index brings a representative query from roughly 1,650 ms to 2.4 ms.
  • The website field was wrong for 6,983 firms. Form ADV Item 1.I lists every web address a firm controls — staff social profiles, podcast pages, regional messaging accounts — and the first entry was being taken. The initial fix ranked the candidates instead, but its name test was inverted: it asked whether the domain contained the firm’s entire legal name, which is almost never true, so that test never passed and shortest-domain-wins became the effective rule. It left Vanguard on a Reddit page, BlackRock on Douyin, and AllianceBernstein on a messaging-app link. Name matching now runs on significant tokens of the firm name, ignoring industry words such as fund, advisors, and management, and a bare domain is preferred over a deep link. A further 1,793 firms were corrected, including many of the largest advisers in the country.
  • get_firm exposed an internal database column in its response. Removed.
  • Change detection recorded roughly 13,800 changes that never happened — about 35% of the log — where a field was simply being observed for the first time. Those rows were deleted and the comparison logic corrected.
  • The daily refresh was not completing. The pipeline ingests the feed in chunks and expects to be re-invoked until finished, but was being called only once a day, so no vintage had finished since 17 August and most of the directory was serving figures from that date. It now resumes every ten minutes and finishes an in-flight vintage before starting a newer one.
  • One change comparison spanned 38 months, compressing three years of amendments into a single dated row and attributing all of it to December 2025. It has been split into two properly bounded windows, and every change row now carries the date it was compared against.
  • Duplicate change rows were removed and a uniqueness constraint added. An index on snapshot date brought the change computation back inside its timeout, after repeated runs had been timing out and stacking concurrent copies.

One limitation remains on the website field: about 4,200 firms resolve to a domain that does not contain their own name. Most of those are correct — a firm branded differently from its legal name — but some are not, and 285 firms list no address other than a social profile anywhere in their filing.

Site

The home page now lists the skills catalog, reading live from the server so it cannot drift from what is actually published. The database metrics are live rather than hardcoded. The aggregate AUM figure is relabelled “Sum of reported RAUM” and carries a note that advisers who sub-advise for one another report the same assets, so it is not the size of the industry.

What’s next

The remaining monthly rosters. 226 of the SEC's monthly adviser files have been catalogued, reaching back to June 2006; 29 are ingested. Completing the roughly 49 months since 2020 needs the two-phase XLSX reader described above, and would deepen the record from five years to twenty.

A cross-firm change feed. The current change tool answers questions about one adviser at a time, so “what moved across the market this week” can be asked of a watchlist but not yet of the whole dataset.

v1.0.0

17 August 2026

SEC Form ADV data foundation

The site is built directly on the SEC Investment Adviser Public Disclosure (IAPD) compilation feed. The current production vintage contains 23,740 firm records, of which 16,865 carry an APPROVED registration status and 10,552 are retail-facing.

Ingestion is fully automated: a streaming parser downloads the daily SEC feed, normalizes each filing, and writes it to a versioned schema with support for diffing and historical snapshots.

  • firms — the latest view of every registered investment adviser.
  • firm_snapshots — dated point-in-time copies used for change tracking.
  • firm_changes — field-by-field diffs between successive snapshots.
  • cohort_stats — percentile context for AUM, clients, accounts, and employees.
  • zip_centroids — US Census ZIP Code Tabulation Area geocoding data.
  • ingest_runs, ingest_warnings, ingest_locks — audit trail and concurrency control.

Directory and firm profiles

The public directory at /firms lets anyone search and filter all 23,740+ firms by state, AUM tier, and retail status. Each firm has its own profile at /firms/$crd with Item-by-Item provenance and cohort percentiles.

MCP-first API

The site is designed as an MCP-first application. The server exposes four public tools at https://advmcp.ai/mcp with no login or API key required:

  • search_firms — find advisers by name, city, or state.
  • get_firm — full profile for a given CRD number.
  • top_firms — largest advisers by reported AUM.
  • firm_changes — recent filing changes for a firm.

Rate limits are enforced at 60 calls/minute, 900/hour, and 5,000/day per caller IP to keep the service stable.

Automatic daily refresh

A resumable ingestion pipeline runs once a day at 07:00 UTC via a scheduled cron job. It pulls the latest SEC feed, processes it in chunks to stay within platform limits, and finalizes by geocoding firms, computing changes, and rebuilding cohort stats. If the current vintage is already up to date, the run skips automatically.

Admin dashboard

A private admin dashboard at /admin shows how many assistants have connected the MCP, how many tool calls have been made, latency distributions, tool usage breakdowns, and daily activity trends. Access is protected by the admin password.

Security and abuse protection

Row-level security policies make firm data publicly readable while keeping logging and rate-limiting functions restricted to the server-side service role. A public security review hardened the schema and verified that the MCP endpoint remains intentionally open for read-only access to public SEC records.

Site, brand, and discoverability

The brand is now ADVmcp, with theme-aware logos, a warm custom palette, and support for both light and dark modes. The footer appears on every page, and legal pages (Privacy Policy, Terms of Use), a sitemap, and robots.txt help search engines index the site.