home/categories/data-analysis/microsoft-dataverse-skills-github-plugins-dataverse-skills-dv-query-skill-md
data-analysisdata-ai

dv-query

Bulk reads, multi-page iteration, and analytics using the Python SDK and Web API. Use when: "query records", "read data", "bulk read", "all records", "iterate records", "expand lookup", "cross-table query", "join tables", "aggregate", "group by", "average", "sum", "count with HAVING", "$apply", "N:N expand", "notebook", "pandas", "DataFrame", "analyze data", "load into dataframe". Do not use when: MCP is sufficient (simple filter, single-record read, small result set — use MCP first), creating or modifying records (use dv-data), creating tables or columns (use dv-metadata).

microsoft
maintainer
microsoft
更新於 4/7/2026
星標
55
分支
10
quick start

Installation and usage

Bulk reads, multi-page iteration, and analytics using the Python SDK and Web API. Use when: "query records", "read data", "bulk read", "all records", "iterate records", "expand lookup", "cross-table query", "join tables", "aggregate", "group by", "average", "sum", "count with HAVING", "$apply", "N:N expand", "notebook", "pandas", "DataFrame", "analyze data", "load into dataframe". Do not use when: MCP is sufficient (simple filter, single-record read, small result set — use MCP first), creating or modifying records (use dv-data), creating tables or columns (use dv-metadata).

安裝
$ install --globalskills.sh
使用

安裝後,您可以透過在終端機執行以下指令來使用此技能:

skills use dv-query