# datatomcp MCP server

> Provides an AI-native data layer that connects agents to Google Sheets, databases, and apps with exact answers and an audit trail.

- Repository: https://github.com/datatomcp/datatomcp-mcp
- Page: https://hostedmcp.org/servers/datatomcp/datatomcp-mcp
- Transport: remote
- Stars: 0
- License: MIT
- Latest version: 1.3.0

## Install

### Claude Code

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

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

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

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

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

### VS Code CLI

```sh
code --add-mcp '{"name":"datatomcp-mcp","type":"http","url":"https://app.datatomcp.com/mcp"}'
```

### Codex

```sh
codex mcp add datatomcp-mcp --url https://app.datatomcp.com/mcp
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.datatomcp-mcp]
url = "https://app.datatomcp.com/mcp"
```

### Gemini CLI

```sh
gemini mcp add -s user --transport http datatomcp-mcp https://app.datatomcp.com/mcp
```

### Gemini settings.json (`~/.gemini/settings.json`)

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

## Tools (17)

- `workspace_overview`
- `list_datasets`
- `describe_dataset`
- `query_rows`
- `aggregate`
- `distinct_values`
- `chart`
- `create_dashboard`
- `list_dashboards`
- `refresh_dashboard`
- `report_issue`
- `propose_definition`
- `propose_link`
- `propose_term`
- `propose_brief`
- `connect_source`
- `activity`

## FAQ

### How is data security handled?

Your data is hosted in the EU and is never used for training. AI features are off by default unless you turn them on.

### Can agents change my data?

No, agents can query your data but cannot change it or run raw SQL. They can only use tools that create dashboards or propose changes for human approval.

### What kind of data sources can I connect?

You can connect Google Sheets, CSV and Excel files, PostgreSQL, MySQL, Stripe, HubSpot, and Airtable.

### How do I authenticate with the server?

The server uses OAuth 2.1 for authentication, meaning you can sign in without needing to paste an API key into your agent.