ETF Flow MCP

1# ETF Flow MCP
2 
3An MCP server that delivers crypto ETF flow data to power AI agents' decision-making.
4 
5<a href="https://glama.ai/mcp/servers/@kukapay/etf-flow-mcp">
6  <img width="380" height="200" src="https://glama.ai/mcp/servers/@kukapay/etf-flow-mcp/badge" alt="etf-flow-mcp MCP server" />
7</a>
8 
9[![Discord](https://img.shields.io/discord/1353556181251133481?cacheSeconds=3600)](https://discord.gg/aRnuu2eJ)
10![Python](https://img.shields.io/badge/Python-3.10%2B-blue)
11![License](https://img.shields.io/badge/License-MIT-green)
12![Status](https://img.shields.io/badge/Status-Active-brightgreen)
13 
14## Features
15 
16- **Unified Tool**: The `get_etf_flow` tool dynamically fetches historical ETF flow data for BTC or ETH.
17- **Markdown Table Output**: Leverages pivot tables to present data with ETF tickers as columns, dates as rows, and a total column for summed flows.
18- **Prompt Guidance**: Includes a prompt (`etf_flow_prompt`) to streamline LLM interactions for user-friendly queries.
19 
20## Prerequisites
21 
22- **Python**: Version 3.10 or higher.
23- **uv**: A fast Python package and project manager ([install instructions](https://github.com/astral-sh/uv)).
24- **CoinGlass API Key**: Obtain a key from [CoinGlass](https://www.coinglass.com/).
25- **Claude Desktop**: Optional, for interactive querying.
26- **Git**: For cloning the repository.
27 
28## Installation
29 
301. **Clone the Repository**:
31   ```bash
32   git clone https://github.com/kukapay/etf-flow-mcp.git
33   cd etf-flow-mcp
34   ```
35 
362. **Set Up with uv**:
37   Install dependencies using `uv`:
38   ```bash
39   uv sync
40   ```
41 
42## Usage
43 
44### Integrating with Claude Desktop
45 
461. **Configure Claude Desktop**:
47   Add the server to `claude_desktop_config.json` (located in `~/Library/Application Support/Claude` on macOS or `%APPDATA%\Claude` on Windows):
48   ```json
49   {
50     "mcpServers": {
51       "etf-flow-mcp": {
52         "command": "uv",
53         "args": ["--directory", "/absolute/path/to/etf-flow-mcp", "run", "etf-flow-mcp"],
54         "env": { "COINGLASS_API_KEY": "your_coinglass_api_key_here" }
55       }
56     }
57   }
58   ```
59   Replace `/absolute/path/to/etf-flow-mcp/cli.py` with the full path to `cli.py`.
60 
612. **Restart Claude Desktop**:
62   Verify the hammer icon appears in the Claude Desktop UI to confirm the server is loaded.
63 
643. **Query Examples**:
65   - "Show me the latest BTC ETF flow data in a table"
66   - "Get the ETH ETF flow history"
67 
68### Example Output
69 
70- **BTC ETF Flow**:
71  ```markdown
72  | Date       | GBTC      | IBIT      | FBTC      | ARKB      | BITB      | BTCO     | HODL     | BRRR     | EZBC     | BTCW     | Total     |
73  |------------|-----------|-----------|-----------|-----------|-----------|----------|----------|----------|----------|----------|-----------|
74  | 2025-04-24 | 0         | 327300000 | 0         | 97700000  | 10200000  | 7750000  | 0        | 0        | 0        | 0        | 442200000 |
75  | 2025-04-23 | 0         | 643200000 | 124400000 | 129500000 | -15200000 | 0        | 5300000  | 0        | 0        | 0        | 917700000 |
76  | 2025-04-22 | 65100000  | 193500000 | 253800000 | 267100000 | 76700000  | 18300000 | 6500000  | 0        | 10600000 | 0        | 912700000 |
77  | 2025-04-21 | 36600000  | 41600000  | 88100000  | 116100000 | 45100000  | 0        | 11700000 | 0        | 10100000 | 0        | 381300000 |
78  | 2025-04-18 | 0         | 0         | 0         | 0         | 0         | 0        | 0        | 0        | 0        | 0        | 0         |
79  ```
80 
81- **ETH ETF Flow**:
82  ```markdown
83  | Date       | ETHE      | GETH     | ETHA      | ETHW     | FETH      | ETHV     | EZET     | CETH     | QETH     | Total     |
84  |------------|-----------|----------|-----------|----------|-----------|----------|----------|----------|----------|-----------|
85  | 2025-04-24 | -6600000  | 18300000 | 40000000  | 5100000  | 0         | 2600000  | 0        | 4100000  | 0        | 63550000  |
86  | 2025-04-23 | 0         | 6400000  | -30300000 | 0        | 0         | 0        | 0        | 0        | 0        | -23900000  |
87  | 2025-04-22 | 0         | 0        | 0         | 6100000  | 32700000  | 0        | 0        | 0        | 0        | 38800000  |
88  | 2025-04-21 | -25400000 | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | -25400000  |
89  | 2025-04-18 | 0         | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | 0         |
90  | 2025-04-17 | 0         | 0        | 0         | 0        | 0         | 0        | 0        | 0        | 0        | 0         |
91  ```
92 
93## License
94 
95This project is licensed under the [MIT License](LICENSE).