Fruit Stand Fund Returns

dev.fruitstandv1.0.1Updated Oct 11, 2026

Trailing & calendar-year returns for 32,000+ US mutual funds & ETFs — fund performance by ticker.

VerifiedStreamable HTTPWeb executableFinanceData & Analytics

Overview

AI-generated overview

Retired hosted MCP server that gave assistants trailing and calendar-year total returns for 32,000+ US mutual funds and ETFs by ticker.

What you can do
  • Search and list the fund universe with filters and keyset pagination
  • Look up fund metadata by ticker
  • Fetch trailing returns for one fund or up to 100 funds in a batch, optionally as of a date
  • Fetch calendar-year returns for one fund or up to 100 funds in a batch, optionally for a given year
  • Returns are reported as decimal fractions, and tickers use the SYMBOL.US form
When to use it
It was meant for comparing fund performance by ticker without a Morningstar or Bloomberg contract. The hosted server is retired and shut down, so it is not usable for new setups; the dataset is still offered on the Snowflake Marketplace instead.
Requirements
A remote Streamable HTTP endpoint and a Fruit Stand API key sent as an Authorization bearer token; the free tier needs no card. Clients without native remote MCP support need a bridge such as mcp-remote via npx or the provided Docker image. The hosted endpoint has been shut down, so these instructions no longer work.
Before you install
The server is retired and archived, so tool calls will not work. The API key is a secret sent in the Authorization header. Tool calls are metered like REST calls and count against a monthly quota, and a key without an active plan gets a 403. Fund data comes from the hosted third-party service.

Installation

In SourceWeft

  1. Open Fruit Stand Fund Returns in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/dev.fruitstand%2Ffund-returns/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "fruit-stand-fund-returns": {
      "type": "http",
      "url": "https://api.fruitstand.dev/mcp"
    }
  }
}

README

Fruit Stand Fund Returns — MCP Server

[!WARNING] Retired 2026-10-12. The hosted Fruit Stand Fund Returns MCP server (https://api.fruitstand.dev/mcp) has been shut down and removed from the MCP registry. The instructions below no longer work. This repository is archived for reference only. The Fund Returns dataset is still available on the Snowflake Marketplace — see fruitstand.dev/datasets/fund-returns.

Live trailing & calendar-year total returns for 32,000+ US mutual funds and ETFs, as an MCP server. Ask an AI assistant to compare fund performance by ticker — no Morningstar or Bloomberg contract, free tier, same API key as the REST API.

Hosted, remote MCP over Streamable HTTP · works with Claude, Cursor, and any MCP client · get a free API key

[Comparing SPY, QQQ and VTI ETF returns through the Fruit Stand Fund Returns MCP server in Claude]

Quick start

1. Get an API key

Sign up at app.fruitstand.dev — the free tier needs no card.

2. Point your client at the endpoint

https://api.fruitstand.dev/mcp

Remote MCP over Streamable HTTP, authenticated with your API key as a bearer token.

Native remote-MCP clients (Claude web/desktop "Add custom connector", Cursor, etc.) — use the URL above and add the header:

Authorization: Bearer YOUR_API_KEY

Claude Desktop config (claude_desktop_config.json) — bridge to the remote endpoint with mcp-remote:

json
{  "mcpServers": {    "fruit-stand": {      "command": "npx",      "args": [        "mcp-remote",        "https://api.fruitstand.dev/mcp",        "--header",        "Authorization: Bearer YOUR_API_KEY"      ]    }  }}

Restart the client and the Fruit Stand tools appear.

Docker — the same bridge as a container (this repo's Dockerfile), for clients that take a docker command:

json
{  "mcpServers": {    "fruit-stand": {      "command": "docker",      "args": ["run", "--rm", "-i", "-e", "FRUITSTAND_API_KEY", "ghcr.io/fruitstanddev/fruitstand-mcp"],      "env": { "FRUITSTAND_API_KEY": "YOUR_API_KEY" }    }  }}

The container only bridges stdio to api.fruitstand.dev/mcp — all data comes from the hosted server.

3. Ask a question

"Compare the 1-year, 5-year, and since-inception returns of SPY, QQQ, and VTI, and tell me which had the best 2022 calendar year."

The assistant calls batchTrailingReturns and batchCalendarReturns and summarizes.

Tools

Six tools, mirroring the REST API. Returns come back as decimal fractions (0.1234 = 12.34%).

ToolDoesKey inputs
searchFundsSearch / list the fund universe (keyset paginated)q, type, country, exchange, cursor, limit
getFundFund metadata by tickercode
getTrailingReturnsTrailing returns for one fund (latest or as-of a date)code, as_of?
batchTrailingReturnsTrailing returns for up to 100 funds in one callcodes[], as_of?
getCalendarReturnsCalendar-year return for one fund (latest or a given year)code, year?
batchCalendarReturnsCalendar-year returns for up to 100 funds in one callcodes[], year?

Tickers use the SYMBOL.US form (e.g. SPY.US, VTSAX.US).

About the data

  • Coverage: ~32,000 US mutual funds & ETFs.
  • Trailing returns: standard windows through since-inception, total return (distributions reinvested).
  • Calendar returns: full-year total return per calendar year.
  • Freshness: refreshed daily from the same pipeline that builds the Fruit Stand datasets on Snowflake Marketplace.
  • Methodology & field reference: app.fruitstand.dev/api/mcp and the docs.

MCP tool calls are metered exactly like REST calls and count against your monthly quota. A key with no active plan gets a 403 on tool calls.

Links

License

MIT — this repo holds the public docs and connector metadata for the hosted service; the service implementation lives in a separate repo.

Source: README.md at commit 6039a75

Tools

0
SourceWeft has not read this server's tools yet.

Version history

1
  1. v1.0.1LatestSep 16, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declaredRequired10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts