Create Dataverse tables, columns, and relationships from a proposed site data model.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "setup-datamodel" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/power-platform-skills/main/plugins/power-pages/skills/setup-datamodel/SKILL.md 2. Save it as ~/.claude/skills/setup-datamodel/SKILL.md 3. Reload skills and tell me it's ready
Based on the following Power Pages event registration site requirements, create a Dataverse data model: include Event, Registration, and Attendee tables, plus relationships between Event and Registration, and Registration and Attendee. List key columns, data types, and relationship settings for each table.
A Dataverse schema proposal with table structures, column definitions, and relationship configuration for event registration.
I am building a Power Pages customer support portal. Create a Dataverse schema from this data model proposal: Customer, Ticket, Ticket Comment, and Attachment entities. It should support customers submitting tickets, agents replying, and multiple comments per ticket.
A set of required tables, key columns, primary/foreign key relationships, and one-to-many schema design for the support portal.
Here is a business draft for a site. Convert it into a Dataverse schema: we need to manage Courses, Instructors, Students, and Enrollments. A course can have multiple instructors, and a student can enroll in multiple courses. Create the tables, columns, and relationships.
A Dataverse entity design for course management, including many-to-many and junction table recommendations.
Plugin check: Run
node "${CLAUDE_PLUGIN_ROOT}/scripts/check-version.js"— if it outputs a message, show it to the user before proceeding.
Guide the user through creating Dataverse tables, columns, and relationships for their Power Pages site. Follow a systematic approach: verify prerequisites, obtain a data model (via AI analysis or user-provided diagram), review and approve, then create all schema objects via OData API.
Initial request: $ARGUMENTS
Goal: Confirm PAC CLI authentication, acquire an Azure CLI token, and verify API access
Actions:
${CLAUDE_PLUGIN_ROOT}/references/dataverse-prerequisites.md to verify PAC CLI auth, acquire an Azure CLI token, and confirm API access. Note the environment URL as <envUrl> for subsequent script calls.Output: Verified PAC CLI auth, valid Azure CLI token, confirmed API access, <envUrl> noted
Goal: Determine whether the user will upload an existing ER diagram or let AI analyze the site
Actions:
Ask the user how they want to define the data model using the AskUserQuestion tool:
Question: "How would you like to define the data model for your site?"
| Option | Description |
|---|---|
| Upload an existing ER diagram | Provide an image (PNG/JPG) or Mermaid diagram of your existing data model |
| Let the Data Model Architect figure it out | The Data Model Architect will analyze your site's source code and propose a data model automatically |
Route to the appropriate path:
If the user chooses to upload an existing diagram:
Ask the user to provide their ER diagram. Supported formats:
Read tool to view the image and extract tables, columns, relationships, and cardinalities from itParse the diagram into the same structured format used by the data-model-architect agent:
pac env who)logicalName, displayName, status (new/modified/reused), columns, relationshipslogicalName, displayName, type, requiredQuery existing Dataverse tables (same as Phase 3 would) to mark each table as new, modified, or reused.
Generate a Mermaid ER diagram from the parsed data (if the user provided an image or text) for visual confirmation.
Proceed directly to Phase 4: Review Proposal with the parsed data model.
If the user chooses to let the Data Model Architect figure it out, proceed to Phase 3: Invoke Data Model Architect (the existing automated flow).
Output: Data model source chosen and, for Path A, parsed data model ready for review
Goal: Spawn the data-model-architect agent to autonomously analyze the site and propose a data model
Actions:
…
Set up Power Platform Pipelines for automated Power Pages deployments.
Review and fix Power Pages security headers, CSP, CORS, cookies, and embedding settings.
Run an end-to-end Power Pages security review with a consolidated HTML report.
Test deployed Power Pages sites with browsing, crawling, and API verification.
Add a data source or connector to a Power Apps code app.
Integrate Power Automate cloud flows into Power Pages with generated metadata and code.
Add Dataverse tables to Power Apps code apps with generated TypeScript services.
Generate sample Dataverse records for testing and demoing a Power Pages site.
Integrate Power Pages Web API into frontend with permissions and deployment.
Connect AI to Microsoft Dataverse for everyday record CRUD operations.
Audit Power Pages table permissions and get prioritized security findings with fixes.
Lets AI query and manage Microsoft Dataverse data, metadata, and environments.