generated: '2026-09-06'
method: searched
source: >-
  https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-mcp-other-clients
  and https://learn.microsoft.com/en-us/microsoft-copilot-studio/mcp-dataverse (both fetched
  2026-09-06, HTTP 200)
name: Microsoft Dataverse MCP Server
status: preview
description: >-
  Microsoft ships a first-party MCP server for Dataverse, the data platform underneath Power
  Platform. It is reachable two ways: a remote HTTP endpoint on the customer's own Dataverse
  environment host, and a local stdio proxy distributed on npm as @microsoft/dataverse. Both
  are the same server; the npm package authenticates and forwards to the remote endpoint.
deployment:
  mode: both
  endpoint: https://{org}.crm.dynamics.com/api/mcp
  install: npx -y @microsoft/dataverse mcp https://yourorg.crm.dynamics.com
  package: https://www.npmjs.com/package/@microsoft/dataverse
  auth: oauth
  verified: searched
  note: >-
    The endpoint is per-tenant and templated on the customer's Dataverse organization host - it
    is not a single shared vendor URL, so it cannot be probed anonymously. Microsoft documents
    the exact form (https://contoso.crm.dynamics.com/api/mcp) and a preview sibling at
    /api/mcp_preview enabled per environment. mode is `both` because the hosted endpoint and
    the stdio package are both published and documented by Microsoft.
endpoints:
- url: https://{org}.crm.dynamics.com/api/mcp
  channel: remote
  availability: ga
- url: https://{org}.crm.dynamics.com/api/mcp_preview
  channel: remote
  availability: preview
  note: must be enabled for the environment; carries preview tools.
authentication:
  type: oauth2
  provider: Microsoft Entra ID
  scope: Dynamics CRM mcp.tools delegated permission
  clients:
  - name: Dataverse CLI (local proxy)
    client_id: 0c412cc3-0dd6-449b-987f-05b053db9457
    note: >-
      Published by Microsoft in the docs as the app id a tenant admin consents to for the
      npm proxy. Not a secret.
  - name: custom Microsoft Entra app
    note: >-
      Required for direct remote-endpoint use; the client id must be added to the environment's
      allowed MCP clients list in the Power Platform admin center.
  admin_gate: >-
    The Dataverse MCP server must be enabled per environment (Settings > Product > Features >
    Dataverse Model Context Protocol) and each client app id allow-listed. There is no
    self-serve public endpoint.
tools_source: >-
  https://learn.microsoft.com/en-us/microsoft-copilot-studio/mcp-dataverse - the published tool
  table. Input schemas were NOT introspected: tools/list requires an authenticated Entra token
  against a customer environment, so names and descriptions here are documentation-grade and
  the parameter shapes need authenticated introspection.
tools:
- name: create_record
  description: Insert a new record into a specified Dataverse table; returns the GUID of the new row.
  consequence: write
- name: read_query
  description: Execute SELECT statements to query Dataverse data with filters and conditions.
  consequence: read
- name: update_record
  description: Modify an existing record in a Dataverse table by GUID and the fields to update.
  consequence: write
- name: delete_record
  description: Delete a specific record from a Dataverse table using its unique identifier.
  consequence: destructive
- name: list_tables
  description: Return all available tables within the current Dataverse environment.
  consequence: read
- name: describe_table
  description: Retrieve the complete T-SQL schema for a given Dataverse table - fields, types, relationships.
  consequence: read
- name: create_table
  description: Create a new Dataverse table by defining column names, data types and relationships.
  consequence: write
- name: update_table
  description: Modify an existing table's schema or metadata - add columns, rename fields, update constraints.
  consequence: write
- name: delete_table
  description: Permanently remove a table from the Dataverse environment, including its schema and data.
  consequence: destructive
- name: search
  description: Keyword search across Dataverse to locate records, entities or fields.
  consequence: read
- name: fetch
  description: Retrieve complete record details from Dataverse using the table name and record ID.
  consequence: read
related_servers:
- name: Environment Management MCP Server
  source: https://learn.microsoft.com/en-us/connectors/powerplatformadminv2/
  note: >-
    Announced September 2025 in the programmability changelog as part of the Power Platform for
    Admins V2 connector. Surfaced through the connector rather than as a standalone endpoint;
    not separately probed in this pass.
warnings:
- >-
  Preview surface. Microsoft states it "might change preview MCP tool names and parameters" and
  that preview features are not meant for production use.
- >-
  delete_record and delete_table are irreversible at the tool layer. See conventions/ for the
  environment-level restore windows that are the only reversal path.