
MCP Dataverse
Give AI agents the real Microsoft Dataverse schema and 100 tools to query and update it
- 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-dataverseAdd to claude_desktop_config.json
{
"mcpServers": {
"dataverse": {
"command": "npx",
"args": [
"-y",
"mcp-dataverse"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"dataverse": {
"command": "npx",
"args": [
"-y",
"mcp-dataverse"
]
}
}
}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

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Ouroboros
MCP serverSpec-first layer that pins requirements and verifies results of AI coding agent work
Runs locally- Open source
- 6.4K GitHub stars
- Developer tools