dv-query SKILL.md skillA

dv-query from microsoft/dataverse-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add microsoft/dataverse-skills/dv-query@git:20261105.65bb1d3

Pins git:20261105.65bb1d3 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
microsoft/dataverse-skills
Path
.github/plugins/dataverse/skills/dv-query/SKILL.md
Versions recorded
6
Latest version
git:20261105.65bb1d3, committed Nov 5, 2026
First version recorded
Aug 11, 2026
Size
18,409 bytes
Repository stars
254
License
MIT

Bulk reads, multi-page iteration, and analytics over Dataverse data. Use when the user wants to read, list, filter, aggregate, group, join, or analyze records — including pandas DataFrame workflows and notebook exploration. Also covers ERP (Finance and Operations / F&O) business-data reads and runtime entity, schema, or action discovery; load dv-overview first, then this skill.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Skill: Query — Read and Analyze Dataverse Records

> **This skill uses Python and the Dataverse CLI.** Do not use Node.js, JavaScript, or any other language for Dataverse scripting. See the overview skill's Hard Rules.

## Reads: prefer a managed surface, choose by shape

**Fast path for simple reads:** If `dataverse auth who` shows an active profile, skip workspace setup and query directly with the CLI examples below. No `.env`, `auth.py`, pip install, or PAC needed for data reads.

Pick **MCP, the Dataverse CLI, or the SDK by the shape of the read** — all three handle auth and retry (see the routing table below and the overview's **Tool Capabilities** / Hard Rule 2). MCP fits small, interactive reads; the CLI fits headless one-liners (OData, SQL, count); the SDK fits bulk iteration and analytics. For `$apply` aggregation and N:N `$expand`, prefer `client.query.fetchxml()` (aggregates + link-entity) or the managed `dataverse api` escape hatch; reach for hand-rolled `urllib`/`get_token()` **only** to stay in-process inside a tight Python loop (e.g. paging thousands of rows with client-side processing — see web-api-advanced.md).
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add microsoft/dataverse-skills/dv-query@sha256:dabb7d67a17878a2

The line at the top of this page pins the label git:20261105.65bb1d3, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_ocx6e27mzf5zqmye.svg)](https://markdownregistry.com/a/art_ocx6e27mzf5zqmye)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 6 versions of this file, between Aug 11, 2026 and Nov 5, 2026, about one every 17 days.

versioncommittedcommitsizeaudit
git:20261105.65bb1d3 latest2026-11-05 65bb1d3 18,409 BA view · diff
git:20261012.19661922026-10-12 1966192 18,300 BA view · diff
git:20260918.669e7152026-09-18 669e715 18,097 BA view · diff
git:20260911.ee929192026-09-11 ee92919 18,073 BA view · diff
git:20260821.a2bddb82026-08-21 a2bddb8 17,940 BA view · diff
git:20260811.a8d4a812026-08-11 a8d4a81 16,457 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (18409 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

microsoft/dataverse-skills · 254 stars · license MIT · pushed 2026-11-06 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ocx6e27mzf5zqmye
GET https://markdownregistry.com/api/v1/resolve?ref=microsoft/dataverse-skills/dv-query
GET https://markdownregistry.com/api/v1/blob/dabb7d67a17878a2a53894969af566646b274f7ae80676726bb631e2221688c8

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from microsoft/dataverse-skills

dv-admin SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-admin/SKILL.md · Environment-level Dataverse administration — bulk delete, retention/archival, organization settings, OrgDB settings…
git:20260918.669e715 · audit A · 254 stars
dv-connect SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-connect/SKILL.md · One-step setup and connection diagnostics for a Dataverse environment — installs tools, authenticates, registers MCP…
git:20261103.8d0b654 · audit A · 254 stars
dv-data SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-data/SKILL.md · Record-level CRUD and bulk operations — create, update, delete, upsert, CSV import, multi-table foreign-key loads…
git:20261012.1966192 · audit F · 254 stars
dv-metadata SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-metadata/SKILL.md · Dataverse schema authoring and inspection — tables, columns, relationships, forms, and views. Use when the user wants…
git:20261012.1966192 · audit A · 254 stars
dv-overview SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-overview/SKILL.md · Foundational cross-cutting context for Dataverse / Power Platform work — scope and the skill map, the tool-capability…
git:20261105.65bb1d3 · audit A · 254 stars
dv-security SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-security/SKILL.md · Security-role assignment, user access, application users, business units, and admin self-elevation in Dataverse…
git:20260811.a8d4a81 · audit A · 254 stars
dv-solution SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/dv-solution/SKILL.md · Dataverse solution lifecycle — create, export, import, promote across environments, and validate deployments. Use when…
git:20260811.a8d4a81 · audit A · 254 stars
erp-sql SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/erp-sql/SKILL.md · Temporary Finance and Operations SQL access and bounded physical-table reads for unified development environments…
git:20261105.65bb1d3 · audit A · 254 stars
erp-xpp SKILL.md skill
microsoft/dataverse-skills · .github/plugins/dataverse/skills/erp-xpp/SKILL.md · X++ code development lifecycle for Finance and Operations — scaffold models, author classes, custom services/APIs, and…
git:20261105.65bb1d3 · audit A · 254 stars
CLAUDE.md@.github/plugins/dataverse/templates CLAUDE.md file
microsoft/dataverse-skills · .github/plugins/dataverse/templates/CLAUDE.md
git:20260721.92cf5a3 · audit A · 254 stars
CLAUDE.md CLAUDE.md file
microsoft/dataverse-skills · CLAUDE.md
git:20261103.9d995d8 · audit A · 254 stars

Every file in microsoft/dataverse-skills

Browse by kind, by grade A, or by owner.