Ask Claude or ChatGPT about Bitcoin & Ethereum ETF flows with a remote MCP server

Yasin Özen — Fri, 31 Jul 2026 13:42:14 +0000

Every evening I used to open ETF flow tables to see how much money moved in or out of the US spot Bitcoin and Ethereum ETFs. I turned that habit into a small data service that AI assistants can query directly.

Update (September 2026): the project moved to yasinozen.com/etf-flows and now runs as a remote MCP server, so there is nothing to install.

Connect it in 30 seconds

Claude: Settings → Connectors → Add custom connector → https://yasinozen.com/etf-flows/mcp

Claude Code:

claude mcp add --transport http etf-flows https://yasinozen.com/etf-flows/mcp

Cursor / VS Code (mcp.json):

{ "mcpServers": { "etf-flows": { "url": "https://yasinozen.com/etf-flows/mcp" } } }

Then ask things like:

"Summarize spot Bitcoin ETF flows this week."
"Did IBIT have outflows in the last 10 days?"
"Compare Ethereum ETF flows in August and September."

Tools

Tool	What it returns
`get_etf_flow_summary`	Latest day, 7/30-day, month-to-date, YTD and cumulative flows, streak, top funds
`get_latest_etf_flows`	Daily totals for recent trading days
`get_etf_flows_by_date_range`	Daily totals between two dates
`get_fund_flows`	One ETF (e.g. IBIT) with its cumulative total

Prefer plain JSON?

curl "https://yasinozen.com/etf-flows/api/v1/flows?asset=BTC&limit=7"

Values are in USD; negative means net outflow. Docs: https://yasinozen.com/etf-flows/api/

How it's built

PHP + MariaDB on ordinary shared hosting.
A GitHub Actions job parses the daily tables and pushes them with a short-lived OIDC token, so no secret is stored anywhere.
Every page (per fund, per month) is pre-rendered to static HTML after each update.
The MCP endpoint is stateless and supports both the 2026-07-28 spec and older initialize-based clients. It's listed in the official MCP Registry as com.yasinozen/etf-flows.

Data and pricing

Figures come from the public tables published by Farside Investors, credited on every page. Browsing the site and the last 7 days via the API or MCP are free; a free key adds per-fund data; a paid Pro tier adds full history and CSV export.

Live pages: Bitcoin ETF flows today · Ethereum ETF flows today · IBIT flows

The local (stdio) version is open source: https://github.com/yasinozen35/free-etf-flows-mcp