setup-datamodel

Orchestrates Dataverse table, column, and relationship creation via the OData API.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/butchersoft-msn/power-platform-mcpserver-for-openai --skill setup-datamodel-butchersoft-msn
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: setup-datamodel
Source: https://github.com/butchersoft-msn/power-platform-mcpserver-for-openai/tree/main/Assets/Plugins/power-pages/skills/setup-datamodel
Command: npx skills add https://github.com/butchersoft-msn/power-platform-mcpserver-for-openai --skill setup-datamodel-butchersoft-msn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Builds a safe, approval-driven workflow to define and deploy Dataverse tables, columns, and relationships for a Power Pages site, reducing manual setup and errors.

Core Features & Use Cases

  • End-to-end provisioning workflow: verify prerequisites, ingest or analyze a data model, present a proposal for explicit user approval, and execute creation of tables, columns, and relationships via the Dataverse OData API, followed by publishing and manifest generation.
  • Safety and governance: requires user confirmation before any creation, checks for existing objects to avoid duplicates, and logs progress with Task tracking across all phases.
  • Automated deployment and validation: uses deep-insert table creation, creates 1:N and many-to-many relationships, publishes customizations, and writes a .datamodel-manifest.json for post-creation validation.

Quick Start

Provide a data model or upload an ER diagram and approve the resulting proposal to automatically provision Dataverse tables, columns, and relationships for your Power Pages site.

Frequently Asked Questions about setup-datamodel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automatically create Dataverse tables and relationships for Power Pages?

You can automatically create Dataverse tables and relationships for Power Pages by uploading an ER diagram or letting an autonomous architect propose a model, approving the design, and executing table creation via the OData API.

What's the best way to deploy a Dataverse data model from an existing ER diagram?

Deploying a Dataverse data model from an existing ER diagram involves ingesting the diagram, generating a proposal for explicit approval, and using deep-insert table creation via the Dataverse OData API to provision tables, columns, and relationships.

Do I need PAC CLI to provision Dataverse tables for Power Pages?

Yes, you need PAC CLI and Azure token refresh to provision Dataverse tables for Power Pages, as the automated workflow requires these prerequisites to authenticate and execute table creation via the OData API.

Can I prevent duplicate tables when automating Dataverse data model creation?

You can prevent duplicate tables during Dataverse data model creation because the workflow includes pre-creation checks against existing objects and requires explicit user approval before executing any table, column, or relationship setup.

How are many-to-many relationships handled when setting up a Dataverse data model?

Many-to-many relationships are handled during Dataverse data model setup by using deep-insert table creation methods that establish 1:N and many-to-many connections, followed by publishing customizations and generating a validation manifest.

Is there a way to validate Dataverse table provisioning after deployment?

You can validate Dataverse table provisioning after deployment because the workflow generates a .datamodel-manifest.json file specifically for post-creation validation and logs progress with Task tracking across all phases.