Lookup Dataverse Table

Use this skill whenever the user wants to search, browse, or look up records in a Microsoft Dataverse table — for example "look up accounts", "find opportunities for Contoso", "show me contact details", or "search cases by status". Always prefer this skill (which queries Dataverse live via the Dataverse MCP Server) BEFORE answering any question about Dataverse records.

110 stars 122 forksAI, LLMs & AgentsOfficial

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add microsoft/cat-agent-skills --skill lookup-dataverse-table
Manual install
git clone --depth 1 https://github.com/microsoft/cat-agent-skills.git /tmp/cat-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/cat-agent-skills/submissions/lookup-dataverse-table ~/.claude/skills/lookup-dataverse-table

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

Help the user search any Microsoft Dataverse table, browse matching records, and
view full record details — all sourced live from Dataverse via the Dataverse MCP
Server tool.

## Data source (critical)

- Always source data **dynamically** from Microsoft Dataverse using the Dataverse
  MCP Server tool.
- **NEVER** fabricate, invent, hardcode, guess, or reuse records from examples or
  prior general knowledge. Every record and every field value you show must come
  from a live query via the tool.
- If the tool returns no results or fails, say so plainly and ask the user to try
  again or refine their search. Do not make up data.

## Workflow

### Step 1 — Identify the table

- If the user names a table (e.g. "accounts", "opportunities", "contacts"), use
  that table.
- If the user is ambiguous, ask: *"Which table would you like to search? For
  example: contacts, accounts, opportunities, leads, etc."*
- Use `describe('tables/')` to resolve the table's logical name if needed.

### Step 2 — Discover the schema

Before querying, call `describe('tables/{tablename}')` to retrieve:

- The table's **primary name field** (used for display).
- The table's **primary key field** (used internally for record lookup).
- Available columns and their logical names and types.

Note the **primary key field name** (e.g. `accountid`) so you can request its
value when querying. The primary key GUID **values** returned by later queries
stay **internal** — never display them to the user.
Read the full skill on GitHub

Details

Skill name
lookup-dataverse-table
Path
submissions/lookup-dataverse-table/SKILL.md
License
MIT
Repo updated
15 November 2026

FAQ

What does the Lookup Dataverse Table skill do?

Use this skill whenever the user wants to search, browse, or look up records in a Microsoft Dataverse table — for example "look up accounts", "find opportunities for Contoso", "show me contact details", or "search cases by status". Always prefer this skill (which queries Dataverse live via the Dataverse MCP Server) BEFORE answering any question about Dataverse records.

How do I install the Lookup Dataverse Table skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add microsoft/cat-agent-skills --skill lookup-dataverse-table. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Lookup Dataverse Table popular?

It lives in microsoft/cat-agent-skills, which has 110 GitHub stars and 122 forks.

Related skills

3 Statements

110

microsoft/cat-agent-skills

Completes existing income statement, balance sheet and cash flow templates while preserving layout, grounding historical inputs and linking forecast formulas with reconciliation checks. Use for "fill in a 3-statement template", "complete an IS/BS/CF framework", "populate my integrated financial model", "link statements in this template", or "finish the forecasts in my three-statement workbook". Do NOT use for blank-slate models or general workbook edits (use xlsx), DCF valuation (use dcf-valuation), or buyout modeling (use lbo-model).

AI, LLMs & Agents122

Accessibility Pass

110

microsoft/cat-agent-skills

Use this skill whenever the user asks to check, review, or fix the accessibility of a PowerPoint deck, Word document, HTML page, or Markdown file, and before handing over any deck or document this agent just generated, so it does not ship with missing alt text, untitled slides, or unreadable colour contrast.

Frontend & Design122

Accessible Learning Materials

110

microsoft/cat-agent-skills

Maintains instructionally equivalent, accessible variants of a set of learning materials — lessons, readings, slides, and handouts — with parity checks against the original learning goals and recorded approvals. Use when the user asks to "make these materials accessible", "audit this lesson set for accessibility", "create an accessible version of this reading", "check reading level and alt text", or "keep my accessible variants in sync". Do NOT use for individual student accommodation or support-plan decisions (IEP, EHCP, or local equivalent), and do NOT use for generic document formatting (us

Learning & Education122

Merger Model

110

microsoft/cat-agent-skills

Models what an acquisition does to pro forma EPS: offer terms and premium, sources and uses, purchase price allocation, the five-part adjustment stack, accretion or dilution by year with its attribution, and the breakeven synergy level tested as a share of the acquired company's cost base. Use when the user asks "is this deal accretive", "run the accretion dilution", "what does this do to EPS", "model the acquisition", "build the merger model", or "merger consequences for the pitch". Do NOT use for pitch book slides — use pitch-deck-skeleton instead; peer multiples — use comps-analysis instead

AI, LLMs & Agents122

Lbo Model

110

microsoft/cat-agent-skills

Builds a leveraged buyout model: sources and uses, a debt schedule with cash sweep, operating projections, and returns to the sponsor as IRR and money multiple, plus sensitivity on entry multiple, exit multiple, and leverage. Use when the user asks to "build an LBO model", "what returns does this deal generate", "run the sponsor returns", "how much leverage can this support", "model the buyout", or "IRR and MOIC for this transaction". Do NOT use for intrinsic cash-flow valuation, trading comparables, or corporate budgeting and forecasting.

AI, LLMs & Agents122

Microsoft AI Platform Advisor

110

microsoft/cat-agent-skills

Use this skill when the user needs to choose the right Microsoft AI platform for a project, is comparing Microsoft 365 Copilot, Agent Builder, Copilot Studio, Microsoft Foundry, Foundry Agent Service, Windows AI Foundry, or Agent 365, needs to gather requirements for an AI or agent build, needs a solution architecture recommendation, needs to estimate effort as technical complexity and risk, or asks any variant of "which platform should I use", "how do I choose", "help me scope this AI project", or "what's the right tool for this AI use case".

AI, LLMs & Agents122

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.