MCP Dataverse logo

MCP Dataverse

by codeurali

Access Microsoft Dataverse records, schema, queries, workflows, audit data, and Power Platform operations through MCP.

Install MCP Dataverse

Pick your client, then add it in one click or paste the config.

STDIONode.js
~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "codeurali-mcp-dataverse": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dataverse"
      ]
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

We couldn’t confirm it starts correctly

We ran the install command but it didn't respond within our test window — this can mean a slow first-time install rather than a real problem.

npx -y mcp-dataverse

No response to initialize.

This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked 1mo ago.

Overview

The codeurali/mcp-dataverse MCP server exposes Microsoft Dataverse operations to AI agents through MCP. It supports metadata inspection, OData and FetchXML queries, record CRUD, relationships, actions, files, audit logs, workflows, and Power Platform customization. Authentication supports device code for local use, client credentials for unattended environments, and managed identity for Azure-hosted deployments. Reach for the codeurali/mcp-dataverse MCP server when an agent needs current Dataverse schema and controlled access to tables, records, permissions, or platform configuration.

Use cases

  • Query Dataverse tables with OData or FetchXML
  • Inspect live table schemas and relationships
  • Create, update, upsert, or delete Dataverse records
  • Review audit and workflow trace logs
  • Manage Power Platform metadata and customizations

Key features

  • Dataverse metadata and schema inspection
  • OData and FetchXML querying
  • Record CRUD, relationships, and batch operations
  • Users, teams, roles, and record access management
  • Audit, plugin, and workflow trace access
  • Device code, client credentials, and managed identity authentication

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked 1d ago

Recent health check succeeded.

6/6 checks healthy over the last 80d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 9d ago via OSV.dev · mcp-dataverse (npm)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars18Stargazers on the source repository.
npm downloads513Package downloads in the last 30 days.
Last commit15d agoMost recent push to the default branch.
Install checkInconclusiveDidn't respond in our test window — often a slow first install.
Directory activity4 viewsConfig copies, upvotes, and views on AllMCPs.

How MCP Dataverse works

What codeurali/mcp-dataverse MCP server does

The codeurali/mcp-dataverse MCP server connects MCP-compatible clients to Microsoft Dataverse. It gives agents access to live environment data instead of requiring them to infer table names, columns, relationships, or query syntax. The repository documents 79 tools, four resources, and 10 guided workflows.

Supported operations cover table and schema metadata, option sets, relationships, entity keys, OData queries, FetchXML, pagination, and full record lifecycle actions. Agents can also associate records, execute bound and unbound Dataverse actions and functions, run atomic batches of up to 1,000 operations, publish customizations, create sitemaps, and use relevance search.

Additional areas include users, teams, roles, role privileges, files and images, annotations, audit logs, plug-in and workflow traces, custom actions, plug-ins, environment variables, connection references, columns, custom tables, relationships, record sharing, record merging, views, business units, impersonation, and duplicate detection.

How it works

The codeurali/mcp-dataverse MCP server uses the Model Context Protocol to present Dataverse functionality as individual tools. Responses use a structured shape containing a summary, data, and suggestions. Destructive operations require explicit confirmation, and cached credentials are protected with AES-256-GCM rather than written to logs.

For local development, device-code authentication starts when the first tool is called. The user retrieves the sign-in code from the MCP output, submits it at Microsoft's device-login page, and then continues with an encrypted cached token. Client credentials are intended for CI/CD, Docker, and other unattended workloads. Managed identity is intended for Azure-hosted services such as App Service and Container Apps.

The server can use standard local MCP communication or HTTP transport. HTTP mode exposes an /mcp endpoint and can protect requests with a bearer secret.

Setup and configuration

Node.js 20 or newer is required. The repository provides an interactive setup command:

Terminal
npx mcp-dataverse install

The wizard configures the environment, registers the server in VS Code, and starts Microsoft account authentication. Client-specific configuration is required for clients such as Claude, Cursor, and Windsurf. The repository also provides an update command and a diagnostic command for setup or connectivity issues.

HTTP operation is configured with MCP_TRANSPORT=http, MCP_HTTP_PORT, and MCP_HTTP_SECRET, followed by starting the built server. Client credentials and managed identity require the corresponding authentication configuration described by the project documentation.

Tools and capabilities

The documented capability groups include:

  • Metadata inspection and schema operations
  • OData, FetchXML, paginated retrieval, and relevance search
  • Create, read, update, delete, upsert, assign, and merge operations
  • Relationship association, disassociation, and association queries
  • Actions, functions, workflows, and atomic batches
  • Users, teams, roles, privileges, sharing, and impersonation
  • File and image columns, notes, attachments, and trace data
  • Solutions, customizations, columns, tables, relationships, and environment settings

Tool selection can be reduced in the MCP client when an agent only needs a subset of these capabilities.

Limitations and notes

The server is comprehensive, so exposing every tool may make agent tool selection less focused. The README recommends deselecting tools that are not needed. Device-code authentication requires interactive sign-in and access to the MCP output channel; client credentials or managed identity are better suited to unattended deployments. The HTTP example uses a local secret and should be configured according to the deployment's security requirements.

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about MCP Dataverse

Run `npx mcp-dataverse install` with Node.js 20 or newer. The interactive wizard configures the environment and registers the server in VS Code.

Client-specific setup is documented separately.

It supports device code authentication for local development, client credentials for unattended workloads, and managed identity for Azure-hosted deployments.

Yes. FetchXML, OData, and paginated retrieval are listed among its query capabilities.

Yes. Set the documented HTTP transport variables, start the built server, and connect to its `/mcp` endpoint with the configured bearer secret.

Related MCP servers

Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewMCP Dataverse AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/codeurali-mcp-dataverse?style=directory)](https://allmcps.com/mcp/codeurali-mcp-dataverse)
HTML Embed
<a href="https://allmcps.com/mcp/codeurali-mcp-dataverse"><img src="https://allmcps.com/api/badge/codeurali-mcp-dataverse?style=directory" alt="MCP Dataverse on AllMCPs" /></a>