# Microsoft Dataverse MCP server

> Lets an AI client read and change Microsoft Dataverse data, schema, solutions and security through the Web API.

- Repository: https://github.com/codeurali/mcp-dataverse
- Page: https://hostedmcp.org/servers/codeurali/mcp-dataverse
- Transport: stdio
- Stars: 18
- License: MIT
- Latest version: 0.7.10

## Install

### Claude Code

```sh
claude mcp add mcp-dataverse -- npx -y mcp-dataverse
```

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

```json
{
  "mcpServers": {
    "mcp-dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
```

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

```json
{
  "servers": {
    "mcp-dataverse": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "mcp-dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
```

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

```toml
[mcp_servers.mcp-dataverse]
command = "npx"
args = ["-y", "mcp-dataverse"]
```

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

```json
{
  "mcpServers": {
    "mcp-dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `DATAVERSE_ENV_URL` | no | no | Your Dataverse environment URL |
| `MCP_CONFIG_PATH` | no | no | Path to a config.json file (overrides all other env vars). Recommended for VS Code / Claude Desktop setups. |
| `MCP_TRANSPORT` | no | no |  |

## FAQ

### How does the Dataverse MCP server authenticate?

It supports three modes: device code sign-in for local development, client credentials for CI/CD and Docker, and managed identity for Azure-hosted deployments.

### Can it query Dataverse records with OData or FetchXML?

Yes, it includes query tools for OData, FetchXML and paginated retrieval.

### Does it support creating and changing table metadata?

Yes, it can read schema, relationships and option sets, and can also create custom tables, relationships and columns.

### Can the Dataverse MCP server run over HTTP for multiple clients?

Yes, setting MCP_TRANSPORT=http enables an HTTP transport with a /mcp endpoint and optional bearer token or Entra JWT auth.

### Does it work with non-VS Code MCP clients like Claude or Cursor?

Yes, it works with any MCP client, including VS Code, Claude, Cursor, Windsurf, Gemini and Codex CLI.