dayour/a2swe/lookup-dataverse-table

Claude Code and agent skill by dayour/a2swe

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

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.

Install

npx vskill@latest install dayour/a2swe/lookup-dataverse-table

SKILL.md

The same SKILL.md was published earlier as dayour/a2swe/lookup-dataverse-table.

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.

Step 3 — Find records
  1. Query the table using read_query, always retrieving at least:
  • The primary name field
  • A key identifier field (e.g. email, account number, status)
  • The primary key (for internal use only)
  1. Apply any search filters the user provides (name, keyword, status, date range,

related record, etc.).

  1. Return at most 15 rows. If more than 15 records match, show the first 15

and prompt the user to narrow the search.

  1. If a field has no value, show (none).

Present results as a numbered markdown list, or a table with a leading number column so the user can select by number:

#Record NameKey Identifier
1Example Corpaccount@example.com
2Another Record555-0100
Step 4 — Select a record

When the user selects a record (by number, name, or identifier):

  1. Re-query the Dataverse table using the internally stored primary key GUID.
  2. Display the most useful ~20 fields for that record, presented as a readable

labeled list or table.

  1. Omit empty/null fields unless the user requests the full record.
  2. Never reveal GUIDs or internal identifiers.

Example detail view:

FieldValue
NameExample Corp
Emailaccount@example.com
Phone555-0100
CitySeattle
StateWA

Remembering preferred fields

  • If the user requests a different set of fields (add, remove, or replace),

remember those preferences using memory tools.

  • Default to the user's preferred field set on all subsequent detail lookups — in

this and future conversations — until the user changes it again.

Supported tables

The skill works with any Dataverse table. Common examples:

Table display nameLogical name
Contactscontact
Accountsaccount
Opportunitiesopportunity
Leadslead
Casesincident
Productsproduct
Orderssalesorder
Invoicesinvoice
Activitiesactivitypointer
Userssystemuser

Use describe('tables/') to discover all available tables in the environment.

Guardrails

  • Present matching records as a numbered markdown list, or a table with a leading

number column (# / Record Name / Key Identifier).

  • Do not expose raw GUIDs, internal IDs, query syntax, or raw tool payloads

to the user.

  • Do not emit adaptive card or suggested-action code blocks.
  • When a search yields no results, say so clearly and suggest alternative search

terms.

  • When a table is not found, suggest similar table names or ask the user to

clarify.

  • When more than 15 records match, always prompt the user to refine the search

rather than paginating silently.

Tone

Be concise and helpful. Explain uncertainty rather than hiding it, and never present fabricated data as if it came from Dataverse.

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

7-day trend score
0

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/dayour/a2swe/lookup-dataverse-table/badge)](https://verified-skill.com/skills/dayour/a2swe/lookup-dataverse-table)

Something wrong with this skill or its page? Tell us.