export_solution_schema
Export Dataverse solution schema to JSON for documenting data models, generating diagrams, and analyzing table structures with customizable filtering options.
Instructions
Exports a comprehensive JSON schema of Dataverse tables, columns, relationships, and option sets. Use this to document your data model, generate diagrams, or analyze solution structure. Supports filtering by prefixes, system/custom components, and specific tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| customizationPrefixes | No | List of customization prefixes to include (e.g., ["new", "xyz", "its"]). If not provided and prefixOnly is true, uses solution context prefix | |
| excludeColumnPrefixes | No | List of column prefixes to exclude from export (default: ["adx_", "msa_", "msdyn_", "mspp_"]) | |
| includeAllSystemTables | No | Whether to include all system tables in the export | |
| includeSystemColumns | No | Whether to include system columns in the export | |
| includeSystemOptionSets | No | Whether to include system option sets in the export | |
| includeSystemRelationships | No | Whether to include system (non-custom) relationships in the export | |
| outputPath | No | Path where to save the schema JSON file (default: schema-export.json) | |
| prefixOnly | No | Whether to export only tables that match the solution customization prefix (deprecated - use customizationPrefixes instead) | |
| prettify | No | Whether to format the JSON output for readability | |
| systemTablesToInclude | No | List of system tables to include when includeAllSystemTables is false (default: contact, account) |
Input Schema (JSON Schema)
{
"properties": {
"customizationPrefixes": {
"description": "List of customization prefixes to include (e.g., [\"new\", \"xyz\", \"its\"]). If not provided and prefixOnly is true, uses solution context prefix",
"items": {
"type": "string"
},
"type": "array"
},
"excludeColumnPrefixes": {
"default": [
"adx_",
"msa_",
"msdyn_",
"mspp_"
],
"description": "List of column prefixes to exclude from export (default: [\"adx_\", \"msa_\", \"msdyn_\", \"mspp_\"])",
"items": {
"type": "string"
},
"type": "array"
},
"includeAllSystemTables": {
"default": false,
"description": "Whether to include all system tables in the export",
"type": "boolean"
},
"includeSystemColumns": {
"default": false,
"description": "Whether to include system columns in the export",
"type": "boolean"
},
"includeSystemOptionSets": {
"default": false,
"description": "Whether to include system option sets in the export",
"type": "boolean"
},
"includeSystemRelationships": {
"default": false,
"description": "Whether to include system (non-custom) relationships in the export",
"type": "boolean"
},
"outputPath": {
"description": "Path where to save the schema JSON file (default: schema-export.json)",
"type": "string"
},
"prefixOnly": {
"default": false,
"description": "Whether to export only tables that match the solution customization prefix (deprecated - use customizationPrefixes instead)",
"type": "boolean"
},
"prettify": {
"default": true,
"description": "Whether to format the JSON output for readability",
"type": "boolean"
},
"systemTablesToInclude": {
"default": [
"contact",
"account"
],
"description": "List of system tables to include when includeAllSystemTables is false (default: contact, account)",
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
}