MCP Dataverse
The most complete MCP server for Microsoft Dataverse.
67 tools · 4 resources · 10 guided workflows · Zero config auth
Why MCP Dataverse?
AI agents hallucinate schema, guess column names, and build broken OData queries. This server gives them real-time access to your Dataverse environment — schema, records, metadata, solutions — through the Model Context Protocol.
| Feature | Details |
|---|---|
| No Azure AD app registration | Device code flow — zero pre-configuration |
| Works with any MCP client | VS Code, Claude, Cursor, Windsurf, Gemini, Codex CLI |
| Atomic tools | Each tool does one thing well; the AI picks the right one |
| Structured outputs | Every response returns {summary, data, suggestions} |
| Guardrails | Destructive operations require explicit confirmation |
| Encrypted tokens | AES-256-GCM cached credentials, never logged |
Quick Install
npx mcp-dataverse install
The interactive wizard configures your environment, registers the server in VS Code, and authenticates your Microsoft account in under 2 minutes.
Requires Node.js 20+. See Multi-Client Setup for Claude, Cursor, Windsurf, and more.
Capabilities at a Glance
| Category | Count | Description |
|---|---|---|
| Metadata | 8 | Tables, schema, relationships, option sets, entity keys |
| Query | 3 | OData, FetchXML, paginated retrieval |
| CRUD | 6 | Get, create, update, delete, upsert, assign |
| Actions & Functions | 6 | Bound/unbound Dataverse actions and functions |
| Batch | 1 | Up to 1 000 operations atomically |
| Solutions | 3 | List solutions, components, publish customizations |
| Search | 1 | Full-text Relevance Search |
| Users & Teams | 3 | Users, roles, teams |
| Files | 2 | Upload/download file and image columns |
| Audit & Trace | 3 | Audit log, plugin trace logs, workflow trace logs |
| Annotations | 2 | Notes and file attachments |
| Customization | 6 | Custom actions, plugins, workflows, env variables, entity updates |
| RBAC | 2 | Assign/remove security roles |
| Assistance | 4 | Tool router, workflow guides |
| + more | … | Delta tracking, impersonation, views, business units, duplicate detection |