datatomcp — Claude Code MCP server: features and setup
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.
claude mcp add --transport http datatomcp https://app.datatomcp.com/mcpWhat datatomcp 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.
What it helps with
- 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 for the agent
- 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.
How to install datatomcp
Platform CLI: remote server
claude mcp add --transport http datatomcp https://app.datatomcp.com/mcpPlatform CLI: remote server
codex mcp add datatomcp --url https://app.datatomcp.com/mcpConfig file
{
"mcpServers": {
"datatomcp": {
"url": "https://app.datatomcp.com/mcp"
}
}
}Config file
{
"servers": {
"datatomcp": {
"type": "http",
"url": "https://app.datatomcp.com/mcp"
}
}
}Platform CLI: remote server
gemini mcp add -t http datatomcp https://app.datatomcp.com/mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about datatomcp
How do I install datatomcp in Claude Code?
Run claude mcp add --transport http datatomcp https://app.datatomcp.com/mcp. Then open /mcp, select datatomcp, and sign in.
What does datatomcp do?
It connects CSV files and Google Sheets to an agent over MCP. The agent can filter or group records and calculate summaries; DuckDB handles the calculations.
Can an agent change data through datatomcp?
No. The server grants read-only access, so an agent can query records but cannot edit them or run arbitrary SQL.
