Fruit Stand Fund Returns

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:

{  "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:

{  "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%).

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

• Get a key / pricing: https://app.fruitstand.dev/pricing
• MCP setup docs: https://app.fruitstand.dev/api/mcp
• REST API reference: https://app.fruitstand.dev/api
• Marketing site: https://fruitstand.dev
• Status of the data pipeline / datasets: https://fruitstand.dev/datasets

License

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