# Dataverse

> Dataverse Schema and Data Modeling. Use when: designing tables, columns, relationships, alternate keys, security roles, cascade behaviors, elastic tables, virtual tables, Dataverse search, query patterns (OData/FetchXML), naming conventions.

- **Type:** Skill
- **Install:** `agentstack add skill-korchard333-claude-power-platform-community-dataverse`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [korchard333](https://agentstack.voostack.com/s/korchard333)
- **Installs:** 0
- **Category:** [Search](https://agentstack.voostack.com/c/search)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [korchard333](https://github.com/korchard333)
- **Source:** https://github.com/korchard333/claude-power-platform-community/tree/main/.claude/skills/dataverse

## Install

```sh
agentstack add skill-korchard333-claude-power-platform-community-dataverse
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Skill: Dataverse Schema & Data Modeling

## When to Use
Trigger when designing tables, columns, relationships, security roles, views, or querying Dataverse via OData/FetchXML.

---

## Table Type Selection

| Factor | Standard Table | Elastic Table | Virtual Table |
|---|---|---|---|
| Data volume | < 10M rows | 10M+ rows, high write throughput | External data (no copy) |
| Transactions | Full ACID (multi-record) | Per-record only | None |
| Security | Full row/column | Organization-owned only | Organization-owned only |
| BPF support | Yes | No | No |
| Charts/dashboards | Yes | No | No |
| Calculated/rollup | Yes | No | No |
| TTL auto-expiry | No | Yes | N/A |
| Offline support | Yes | No | No |
| Best for | Business data, CRUD apps | IoT, logs, telemetry, high-volume ingestion | Read-only external data (SQL, SharePoint, Fabric) |

---

## ⚠️ REQUIRED: Load Sub-Files Before Implementation

**SKILL.md is a summary only — it is NOT sufficient for implementation.**

The detailed content (complete payloads, XML templates, working examples, edge-case handling) lives in sub-files in the **same directory** as this SKILL.md. Before writing any code, you MUST use `read_file` on the sub-files relevant to your task:
- **[Table Design](table-design.md)** — Table design principles, column type guide, auto-number columns, alternate keys
- **[Relationships](relationships.md)** — N:1, 1:N, N:N, manual intersect tables, cascade behaviors
- **[Query Patterns](query-patterns.md)** — OData queries, FetchXML, lookup handling in Code Apps, schema discovery via metadata API
- **[Naming Conventions](naming-conventions.md)** — Publisher prefix, table/column/relationship naming standards
- **[Elastic & Virtual Tables](elastic-virtual-tables.md)** — Elastic tables (Cosmos DB), virtual tables, Dataverse search, long-term retention

---

## Anti-Patterns

- Text columns used as primary identifiers without alternate keys
- Cascade delete without documenting intended behavior
- Org-owned tables where row-level security is needed
- Rollup columns on tables with millions of rows
- Storing JSON blobs in text columns to avoid proper schema
- Duplicate choice definitions across tables (use global option sets)
- N:N relationship used when the intersect needs attributes
- Missing indexes on frequently-filtered lookup columns
- Over-permissive security roles ("just give them System Admin")

---

## Related Skills

- `dataverse-web-api` — CRUD operations and metadata management via API
- `security` — Security roles, column security, row-level access
- `plugins` — Server-side logic operating on Dataverse schema
- `code-apps` — Client-side Dataverse queries from React
- `model-driven-apps` — Forms and views built on Dataverse tables

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [korchard333](https://github.com/korchard333)
- **Source:** [korchard333/claude-power-platform-community](https://github.com/korchard333/claude-power-platform-community)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-korchard333-claude-power-platform-community-dataverse
- Seller: https://agentstack.voostack.com/s/korchard333
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.