csv-token-counter-mcp

# csv-token-counter-mcp A lightweight MCP (Model Context Protocol) server that counts tokens in CSV and Excel files using [tiktoken](https://github.com/openai/tiktoken). Works with VS Code, Claude Desktop, and any MCP-compatible application. No LLM or API key required — runs fully offline. --- ## Why Use This? Before sending CSV or Excel data to any LLM (ChatGPT, Claude, Gemini etc.), you need to know how many tokens your data contains — to estimate cost, check context window limits, or split large files. This tool does exactly that, directly inside your editor or AI assistant. --- ## Features - Count total tokens across an entire CSV or Excel file - Break down token counts column by column - Analyze tokens in a single specific column (avg, min, max per row) - Preview file schema — column names, types, row counts - Supports `.csv`, `.xlsx`, and `.xls` formats - Works fully offline — no API key or internet needed - Compatible with VS Code, Claude Desktop, and any MCP client --- ## Installation ### Option 1 — pip (traditional) ```bash pip install csv-token-counter-mcp ``` Add to your `.vscode/mcp.json`: ```json { "servers": { "csv-token-counter": { "type": "stdio", "command": "csv-token-counter-mcp", "args": [] } } } ``` ### Option 2 — uvx (recommended, no install needed) First install `uv` if you don't have it: ```bash pip install uv ``` Add directly to your `.vscode/mcp.json` — no separate install step needed: ```json { "servers": { "csv-token-counter": { "type": "stdio", "command": "uvx", "args": ["csv-token-counter-mcp"] } } } ``` ### Option 3 — Claude Desktop Add to your Claude Desktop config file: **Mac:** `~/Library/Application Support/Claude/claude_desktop_config.json` **Windows:** `%APPDATA%\Claude\claude_desktop_config.json` ```json { "mcpServers": { "csv-token-counter": { "command": "uvx", "args": ["csv-token-counter-mcp"] } } } ``` --- ## Available T…