Introduce Metadata Command Group

[mathiasbl-alistar]

This idea introduces a new metadata command that would provide programmatic access to data model information - particularly valuable for AI-assisted development tools like GitHub Copilot and other LLMs.

Problem Statement

• Limited AI Context: GitHub Copilot and other LLMs lack real-time access to current Dataverse schema information
• AI Code Generation Friction: Without schema context, AI tools generate generic or incorrect code that requires significant manual correction

Benefits for AI-Assisted Development

• Real-time Schema Context: Copilot can access current table structures, column names, and data types
• Accurate Code Suggestions: Generate plugins, PCF components, and client scripts with correct attribute references
• Intelligent Autocomplete: Copilot understands your specific Dataverse environment schema

Example

# List all tables in the environment
pac metadata list tables

# List all tables in a solution
pac metadata list tables -solution MySolution

# Get detailed information about a specific table
pac metadata get table --name account --output json

# List all columns for a table
pac metadata list columns --table account

# Get relationship information
pac metadata list relationships --table account

# Export complete schema for code generation
pac metadata export --tables account,contact --output schema.json

# Export schema in AI-friendly formats
pac metadata export --tables account --format markdown --output account-schema.md

# Generate context files for AI tools
pac metadata generate-context --solution "MySolution" --output .copilot/dataverse-context.json

In combination with the PAC MCP server introduced in most recent version this would allow LLM's to be aware of your data model.
Similar to the Dataverse MCP server with the tools describe_tables and list_tables however these output T-SQL syntax and is not really usable for development purposes and overall lack extra context needed during development.

[petrochuk]

This is a good idea that aligns with the new MCP support. #1182

[laneswenka]

Thanks I have added this to our backlog for review and prioritization. If accepted we will update the discussion.