ETF Flow MCP

An MCP server that delivers crypto ETF flow data to power AI agents' decision-making.

Features

• Unified Tool: The get_etf_flow tool dynamically fetches historical ETF flow data for BTC or ETH.
• Markdown Table Output: Leverages pivot tables to present data with ETF tickers as columns, dates as rows, and a total column for summed flows.
• Prompt Guidance: Includes a prompt (etf_flow_prompt) to streamline LLM interactions for user-friendly queries.

Prerequisites

• Python: Version 3.10 or higher.
• uv: A fast Python package and project manager (install instructions).
• CoinGlass API Key: Obtain a key from CoinGlass.
• Claude Desktop: Optional, for interactive querying.
• Git: For cloning the repository.

Installation

1. Clone the Repository:

   git clone https://github.com/kukapay/etf-flow-mcp.git
   cd etf-flow-mcp

2. Set Up with uv: Install dependencies using uv:

   uv sync

Usage

Integrating with Claude Desktop

1. Configure Claude Desktop: Add the server to claude_desktop_config.json (located in ~/Library/Application Support/Claude on macOS or %APPDATA%\Claude on Windows):

   {
     "mcpServers": {
       "etf-flow-mcp": {
         "command": "uv",
         "args": ["--directory", "/absolute/path/to/etf-flow-mcp", "run", "etf-flow-mcp"],
         "env": { "COINGLASS_API_KEY": "your_coinglass_api_key_here" }
       }
     }
   }

   Replace /absolute/path/to/etf-flow-mcp/cli.py with the full path to cli.py.

2. Restart Claude Desktop: Verify the hammer icon appears in the Claude Desktop UI to confirm the server is loaded.

3. Query Examples:

   • "Show me the latest BTC ETF flow data in a table"
   • "Get the ETH ETF flow history"

Example Output

• BTC ETF Flow:

  | Date       | GBTC      | IBIT      | FBTC      | ARKB      | BITB      | BTCO     | HODL     | BRRR     | EZBC     | BTCW     | Total     |
  |------------|-----------|-----------|-----------|-----------|-----------|----------|----------|----------|----------|----------|-----------|
  | 2025-04-24 | 0         | 327300000 | 0         | 97700000  | 10200000  | 7750000  | 0        | 0        | 0        | 0        | 442200000 |
  | 2025-04-23 | 0         | 643200000 | 124400000 | 129500000 | -15200000 | 0        | 5300000  | 0        | 0        | 0        | 917700000 |
  | 2025-04-22 | 65100000  | 193500000 | 253800000 | 267100000 | 76700000  | 18300000 | 6500000  | 0        | 10600000 | 0        | 912700000 |
  | 2025-04-21 | 36600000  | 41600000  | 88100000  | 116100000 | 45100000  | 0        | 11700000 | 0        | 10100000 | 0        | 381300000 |
  | 2025-04-18 | 0         | 0         | 0         | 0         | 0         | 0        | 0        | 0        | 0        | 0        | 0         |

• ETH ETF Flow:

  | Date       | ETHE      | GETH     | ETHA      | ETHW     | FETH      | ETHV     | EZET     | CETH     | QETH     | Total     |
  |------------|-----------|----------|-----------|----------|-----------|----------|----------|----------|----------|-----------|
  | 2025-04-24 | -6600000  | 18300000 | 40000000  | 5100000  | 0         | 2600000  | 0        | 4100000  | 0        | 63550000  |
  | 2025-04-23 | 0         | 6400000  | -30300000 | 0        | 0         | 0        | 0        | 0        | 0        | -23900000  |
  | 2025-04-22 | 0         | 0        | 0         | 6100000  | 32700000  | 0        | 0        | 0        | 0        | 38800000  |
  | 2025-04-21 | -25400000 | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | -25400000  |
  | 2025-04-18 | 0         | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | 0         |
  | 2025-04-17 | 0         | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | 0         |

License

This project is licensed under the MIT License.