Dataverse MCP server

This is a helper that connects your AI assistant to Microsoft Dataverse, the place where Power Platform apps keep their data. Once it is set up, you can ask your AI in plain words to look up records, add new ones, or check what tables exist, and it will do it for you. It is handy if you work with Dataverse or Power Apps and want to skip a lot of clicking around.

What this MCP server does

You ask your AI something in normal words, like to find a customer or add a note. The AI uses this helper to talk to your Dataverse environment. The helper signs in with your Microsoft work account, runs the request, and sends the answer back. Your AI then shows you the result in the chat, as a list, a summary, or a confirmation that something changed. It can also check the structure of your tables so it does not guess column names.

Click to zoom

What you can do with it

• Look up records in any table you have access to
• Create, update, or delete records
• Run OData and FetchXML queries
• Inspect tables, columns, and relationships
• Upload or download file and image columns
• Check audit logs and workflow trace logs
• Publish customizations and manage users and roles

Try asking your AI

• “Show me the last 10 accounts created this month”
• “Add a note to the contact named Jane Doe”
• “What columns does the Account table have?”
• “Find all open cases assigned to me”

What it gives back to you

You get answers right in the chat: lists of records, short summaries, counts, or the details of a single item. When it changes something, it tells you what it did. When it looks at your setup, it shows table names, column names, and relationships. Everything comes back in a tidy shape with a short summary and a few suggested next steps.

Before you start

Who it's for

People who work with Microsoft Dataverse, Power Apps, or Power Platform and want their AI to help with everyday data tasks.