# Dot MCP server

> Allows AI clients to query data warehouses using plain English to generate SQL, data answers, and charts.

- Repository: https://github.com/Snowboard-Software/getdot
- Page: https://hostedmcp.org/servers/snowboard-software/getdot
- Transport: remote
- Stars: 1
- License: MIT
- Latest version: 1.0.2

## Install

### Claude Code

```sh
claude mcp add --transport http getdot https://app.getdot.ai/ai/mcp
```

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

```json
{
  "mcpServers": {
    "getdot": {
      "url": "https://app.getdot.ai/ai/mcp"
    }
  }
}
```

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

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

### VS Code CLI

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

### Codex

```sh
codex mcp add getdot --url https://app.getdot.ai/ai/mcp
```

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

```toml
[mcp_servers.getdot]
url = "https://app.getdot.ai/ai/mcp"
```

### Gemini CLI

```sh
gemini mcp add -s user --transport http getdot https://app.getdot.ai/ai/mcp
```

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

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

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `DOT_API_BASE_URL` | no | no |  |
| `DOT_API_TOKEN` | no | no |  |

## FAQ

### What happens when I ask a question in plain English?

Dot identifies the correct tables, writes and executes SQL on your warehouse, and provides the result along with the SQL used and visual charts.

### How do I authenticate if my client does not support OAuth?

You can generate an MCP token in your Dot Profile under 'Use Dot elsewhere > MCP' and provide it via the X-API-KEY header.