# datatomcp

Connect CSV files and Google Sheets to an agent for filtering rows and calculating summaries. Useful when you want answers from a table without writing queries yourself.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI
- Author: datatomcp
- License: MIT · policy=link-only · description only; the file stays with the author
- Source: https://github.com/datatomcp/datatomcp-mcp
- Updated: 2026-10-24
- HTML: https://affpapa.org/en/nevibecode/mcp/datatomcp

## What it does

datatomcp exposes a CSV upload, a CSV link, or a Google Sheet to an agent as a remote data source. Add `https://app.datatomcp.com/mcp` to your client, sign in with OAuth, then select or upload a dataset in the service.

The agent can inspect column names, filter and sort records, or group data and calculate totals, averages, and counts. DuckDB performs the calculations, so they are not estimates generated by the model. Access is read-only: the agent cannot edit a sheet or run arbitrary SQL. Hourly Google Sheets refresh requires the Pro plan.

## Requirements
- Remote server: `https://app.datatomcp.com/mcp`

## Install

### Claude Code (native platform)

**Platform CLI: remote server**
```bash
claude mcp add --transport http datatomcp https://app.datatomcp.com/mcp
```

### Codex

**Platform CLI: remote server**
```bash
codex mcp add datatomcp --url https://app.datatomcp.com/mcp
```

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "datatomcp": {
            "url": "https://app.datatomcp.com/mcp"
        }
    }
}
```

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "datatomcp": {
            "type": "http",
            "url": "https://app.datatomcp.com/mcp"
        }
    }
}
```

### Gemini CLI

**Platform CLI: remote server**
```bash
gemini mcp add -t http datatomcp https://app.datatomcp.com/mcp
```

## When to use it
- filter CSV records by column values
- calculate totals and averages for grouped records
- inspect a column’s actual values before filtering
- count records that match chosen conditions

## Example prompts
- Calculate revenue by country from the connected orders sheet.
- Find records with the status “refunded” and count them.
- Show the actual values in `region`, then group the records by that column.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89609
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89899
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16730
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40459
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27844
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49863

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md