Fruit Stand Fund Returns — MCP Server
OfficialFund return data is refreshed daily from the same pipeline that builds the Fruit Stand datasets on Snowflake Marketplace, and the Fund Returns dataset remains available on the Snowflake Marketplace.
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., "@Fruit Stand Fund Returns — MCP ServerCompare the 1-year and 5-year total returns of SPY, QQQ, and VTI."
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.
Fruit Stand Fund Returns — MCP Server
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

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/mcpRemote 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_KEYClaude 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.
Related MCP server: MCP-Server-Financial-Analyzer
Tools
Six tools, mirroring the REST API. Returns come back as decimal fractions (0.1234 = 12.34%).
Tool | Does | Key inputs |
| Search / list the fund universe (keyset paginated) |
|
| Fund metadata by ticker |
|
| Trailing returns for one fund (latest or as-of a date) |
|
| Trailing returns for up to 100 funds in one call |
|
| Calendar-year return for one fund (latest or a given year) |
|
| Calendar-year returns for up to 100 funds in one call |
|
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.
This server cannot be deployed
Maintenance
Related MCP Connectors
Stock market data for AI agents: real-time quotes, financials, options, SEC filings and news.
Provide AI assistants with real-time access to official SEC EDGAR filings and financial data. Enab…
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.
9,900+ US equities, 64 years of prices, financials, technicals, and earnings. Ask in plain English.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to access real-time stock, crypto, and market index data from Yahoo Finance, supporting queries for prices, history, company info, and comparisons.MIT
- FlicenseAqualityDmaintenanceProvides AI assistants with real-time stock prices, financial statements, SEC filings, and analytical tools like DCF valuation and ratio analysis.14-

ROIC.ai Financial Data MCPofficial
AlicenseAqualityBmaintenanceEnables AI assistants to access stock prices, financial statements, earnings call transcripts, and fundamental data for 60,000+ public companies via 25 read-only tools.253MIT- FlicenseNot gradedqualityCmaintenanceEnables AI assistants to perform live stock and portfolio research using Yahoo Finance data, including quotes, fundamentals, price history, news, portfolio analysis, and ticker comparisons.-