# datatomcp

> datatomcp is a freemium MCP server for analytics and data. Governed data layer that lets agents query sheets, databases, Stripe and HubSpot. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** Web, API
- **Website:** https://datatomcp.com
- **Repository:** https://github.com/datatomcp/datatomcp-mcp
- **MCP Registry name:** com.datatomcp/datatomcp
- **Categories:** analytics and data, databases
- **Listing updated:** 2026-11-14

## About

datatomcp sits between a team's spreadsheets and its AI assistants. You upload CSV or Excel files, link public or private Google Sheets, or connect PostgreSQL, MySQL, Stripe, HubSpot or Airtable. Each source becomes a versioned dataset, and the service finds shared ids such as customer_id so an agent can answer across datasets in a single query.

Answers are counted by a database rather than estimated by the model, and name the dataset version used. datatomcp drafts metric definitions from your columns, a person approves them, and agents only use approved ones. Every agent question is logged with repeated questions compared, kept 30 days on Free and 90 on Pro.

The MCP tools are read-only for data, with chart rendering in chat and dashboard tools that never change data. A REST API with bearer keys is also available. The service is hosted in the EU.

## Features

- **Many source types:** Reads files, Google Sheets, PostgreSQL, MySQL, Stripe, HubSpot and Airtable.
- **Linked datasets:** Detects shared key columns so agents can join across datasets.
- **Approved definitions:** Agents use only metric definitions a person has approved.
- **Audit trail:** Records every agent question, with CSV export.
- **Charts and dashboards:** Draws answers in chat and manages workspace dashboards.
- **REST API:** Provides an OpenAPI 3.1 API with bearer keys.

## Good for

- Ask revenue questions of Stripe and spreadsheet data together
- Give several agents one agreed definition of each metric
- Review what agents asked of company data
- Build a dashboard from a chat answer

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http datatomcp https://app.datatomcp.com/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://app.datatomcp.com/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "datatomcp": {
      "url": "https://app.datatomcp.com/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "datatomcp": {
      "type": "http",
      "url": "https://app.datatomcp.com/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "datatomcp": {
      "serverUrl": "https://app.datatomcp.com/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "datatomcp": {
      "type": "http",
      "url": "https://app.datatomcp.com/mcp"
    }
  }
}
```

## Tools

- `workspace_overview`: Overview of the workspace.
- `list_datasets`: List datasets.
- `describe_dataset`: Describe a dataset.
- `distinct_values`: Distinct values of a column.
- `query_rows`: Read rows from a dataset.
- `aggregate`: Aggregate data.
- `chart`: Draw the answer in the chat.
- `create_dashboard`: Create a dashboard in the workspace.
- `list_dashboards`: List dashboards.
- `refresh_dashboard`: Refresh a dashboard.
- `report_issue`: Flag a data problem to the team.

## FAQ

### Which assistants can connect?

Claude, Claude Code, Cursor, Codex and any MCP client, with ChatGPT listed as coming soon.

### How does sign-in work?

OAuth for the MCP server and no API key; the REST API uses a Bearer key.

### Where is data hosted?

In the EU.

### Can agents change my data?

The data tools are read-only and the dashboard tools never change data.

### Is datatomcp free?

datatomcp has a free plan, with paid plans for more usage or features.

### How do I add datatomcp to Claude Code?

Run this command in your terminal: claude mcp add --transport http datatomcp https://app.datatomcp.com/mcp

### What are the best alternatives to datatomcp?

The closest alternatives to datatomcp are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

## Alternatives

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/datatomcp
