# MCP Dataverse

> MCP Dataverse is an open-source MCP server for databases. Give AI agents the real Microsoft Dataverse schema and 100 tools to query and update it. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, vscode, Windows, macOS, Linux
- **Website:** https://codeurali.github.io/mcp-dataverse/
- **Repository:** https://github.com/codeurali/mcp-dataverse
- **MCP Registry name:** io.github.codeurali/dataverse
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-15

## About

The pitch is that agents should read the schema before writing a query. The server exposes entity definitions, relationships, option sets and keys so column names are checked rather than guessed, then offers 100 tools, 4 resources and 5 guided workflows. The README groups them into metadata, query (OData, FetchXML, paginated retrieval), CRUD, relations, actions and more; example calls include dataverse_query, dataverse_get and dataverse_execute_fetchxml.

Every response comes back as a summary, data and suggested next steps, both as text and as structured content. Batch requests can carry up to 1,000 operations, with changesets for atomic groups. Tools declare read-only or destructive hints, and the riskiest operations need confirm: true.

Authentication uses Microsoft Entra ID in three modes: device code for local work, client credentials for CI/CD and managed identity for Azure-hosted setups. Dataverse security roles decide what is allowed, since the server adds no privilege, and the token cache is encrypted with AES-256-GCM. Setup is npx mcp-dataverse install with Node.js 20 or later. The project is MIT licensed.

## Features

- **Schema first:** Reads entity definitions, relationships, option sets and keys before acting.
- **100 tools:** Covers metadata, queries, CRUD, relations, actions, audit and security roles.
- **Batch with changesets:** Runs up to 1,000 operations per request with atomic groups.
- **Three Entra ID modes:** Device code, client credentials and managed identity.
- **Structured results:** Returns a summary, data and next-step suggestions.
- **Guardrails:** Destructive tools carry hints and risky ones require explicit confirmation.

## Good for

- Map tables and relationships in a Dataverse org
- Query records with OData or FetchXML in plain language
- Run a large data migration as an atomic batch
- Audit security roles and over-permissioned users
- Pull plugin trace logs and flow history to debug errors

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

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

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

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

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

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

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

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

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

## Tools

- `dataverse_query`: Queries a table with select, filter, order and top options.
- `dataverse_get`: Fetches the full details of one record.
- `dataverse_execute_fetchxml`: Runs a FetchXML query for complex joins.

## FAQ

### How do I install it?

Run npx mcp-dataverse install; it needs Node.js 20 or later and walks you through setup.

### Which sign-in methods are supported?

Device code, client credentials and managed identity through Microsoft Entra ID.

### Does it bypass Dataverse security?

No. Dataverse security roles decide what is allowed; the server adds no privilege.

### Which clients work?

VS Code Copilot, Claude Desktop, Cursor, Windsurf, Gemini CLI, Copilot Studio and Codex CLI.

### Is MCP Dataverse free?

Yes. MCP Dataverse is open source, so you can use and self-host it for free.

### How do I add MCP Dataverse to Claude Code?

Run this command in your terminal: claude mcp add dataverse -- npx -y mcp-dataverse

### What are the best alternatives to MCP Dataverse?

The closest alternatives to MCP Dataverse are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

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