Skip to content
MCP server

MCP Dataverse

Give AI agents the real Microsoft Dataverse schema and 100 tools to query and update it

Runs locallyStatus and history
Pricing
Open source
Platforms
CLI, vscode, Windows
Runs
Locally
Version
0.7.10
Listing updated
2 days ago

About MCP Dataverse

MCP Dataverse is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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.

Install

Run in a terminal

claude mcp add dataverse -- npx -y mcp-dataverse

Add to claude_desktop_config.json

{
  "mcpServers": {
    "dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Configuration

  • MCP_CONFIG_PATHPath to a config.json file (overrides all other env vars). Recommended for VS Code / Claude Desktop setups.
  • DATAVERSE_ENV_URLYour Dataverse environment URL

Tools this server provides (3)

Taken from the project documentation; the running server may differ.

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.

What it does

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

Pricing

Open source

MIT licensed

Prices change. Check codeurali.github.io before you buy.

MCP Dataverse 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 to MCP Dataverse

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ouroboros

    MCP server

    Spec-first layer that pins requirements and verifies results of AI coding agent work

    Runs locally
    • Open source
    • 6.4K GitHub stars
    • Developer tools