本文へ移動
cccskills
無料GitHub で公開

azure-data-explorer

Expert knowledge for Azure Data Explorer development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when securing ADX (RBAC/MI), automating cluster/schema deploys, tuning ingestion/queries, or integrating via ODBC/JDBC/Power BI, and other Azure Data Explorer related development tasks. Not for Azure Synapse Analytics (use azure-synapse-analytics), Azure HDInsight (use azure-hdinsight), Azure Databricks (use azure-databricks), Azure Stream Analytics (use azure-stream-analytics).

MicrosoftDocs/Agent-Skills
インストール方法を見る

含まれるファイル（1）

  • SKILL.md19.1 KB

SKILL.md（原文）

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Azure Data Explorer Skill

This skill provides expert guidance for Azure Data Explorer. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

IMPORTANT for Agent: If metadata.generated_at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp_microsoftdocs tools are not available, suggest the user install it: Installation Guide

This skill requires network access to fetch documentation content:

  • Preferred: Use mcp_microsoftdocs:microsoft_docs_fetch with query string from=learn-agent-skill. Returns Markdown.
  • Fallback: Use fetch_webpage with query string from=learn-agent-skill&accept=text/markdown. Returns Markdown.

Category Index

CategoryLinesDescription
TroubleshootingL37-L49Diagnosing and fixing ADX cluster health, connection, creation, ingestion, dashboard, DB/table, private endpoint, and resource health issues, including error codes and common failure patterns.
Best PracticesL50-L61Guidance on optimizing ADX clusters and schemas, handling duplicates and JSON ingestion, tuning for high concurrency, monitoring queued ingestion, using hot windows, and applying Power BI best practices.
Decision MakingL62-L76Guidance on ADX capacity planning, SKU and compute choices, scaling, cost optimization, reservations, business continuity, confidential compute, streaming ingestion, and Elasticsearch migration.
Architecture & Design PatternsL77-L83Designing ADX architectures for DR/BCP, cross-cluster access via follower DBs, and multitenant patterns (isolation, scaling, and resource sharing).
Limits & QuotasL84-L93Cluster limits and behaviors: free cluster quotas, auto-stop, safe delete/recover, ingestion file size and invalid data handling, and supported data/compression formats.
SecurityL94-L121Securing Azure Data Explorer: authn/z (RBAC, principals, Entra apps, Conditional Access), encryption, managed identities, network isolation, policies, data purging, and outbound/public access control.
ConfigurationL122-L136Configuring ADX environments: database/table policies, retention/cache, cross-tenant Event Hubs, Kusto emulator, plugins, monitoring, schema sync, T-SQL, and web UI settings/shortcuts.
Integrations & Coding PatternsL137-L171Integrating Azure Data Explorer with tools and platforms (SQL, ODBC/JDBC, Power Automate/Apps, Functions, Grafana, Splunk, OpenTelemetry, etc.) and coding patterns for querying, ingestion, and automation.
DeploymentL172-L178Automating ADX cluster provisioning and schema deployment, plus guidance for migrating clusters to availability zones and from VNet injection to private endpoints.

Troubleshooting

TopicURL
Monitor and troubleshoot Azure Data Explorer cluster healthhttps://learn.microsoft.com/en-us/azure/data-explorer/check-cluster-health
Diagnose and fix Azure Data Explorer dashboard tile errorshttps://learn.microsoft.com/en-us/azure/data-explorer/dashboard-troubleshoot-tile-errors
Diagnose Azure Data Explorer ingestion errors by codehttps://learn.microsoft.com/en-us/azure/data-explorer/error-codes
Resolve common Azure Data Explorer ingestion issueshttps://learn.microsoft.com/en-us/azure/data-explorer/ingestion-faq
Use Resource Health to diagnose ADX issueshttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-with-resource-health
Troubleshoot Azure Data Explorer private endpoint issueshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint-troubleshoot
Fix Azure Data Explorer cluster connection issueshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-connect-cluster
Troubleshoot Azure Data Explorer cluster creation failureshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-create-cluster
Resolve Azure Data Explorer DB and table operation failureshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-database-table

Best Practices

TopicURL
Apply Azure Advisor recommendations to optimize Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/azure-advisor
Handle duplicate data in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/dealing-with-duplicates
Optimize Azure Data Explorer clusters for high-concurrency workloadshttps://learn.microsoft.com/en-us/azure/data-explorer/high-concurrency
Use hot windows to efficiently query cold data in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/hot-windows
Ingest JSON into Azure Data Explorer with KQL, C#, and Pythonhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats
Monitor queued ingestion metrics in ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-queued-ingestion
Apply Power BI best practices for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/power-bi-best-practices
Optimize Azure Data Explorer table schema designhttps://learn.microsoft.com/en-us/azure/data-explorer/schema-best-practice

Decision Making

TopicURL
Choose Azure Data Explorer business continuity optionshttps://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-overview
Deploy Azure Data Explorer with confidential computehttps://learn.microsoft.com/en-us/azure/data-explorer/confidential-compute
Decide when to use streaming ingestion in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-streaming
Select isolated compute SKUs for Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/isolated-compute
Choose optimal Azure Data Explorer compute SKUhttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-choose-sku
Plan vertical scaling and SKU changes for clustershttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-vertical-scaling
Migrate Elasticsearch workloads to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/migrate-elasticsearch-to-azure-data-explorer
Use ADX pricing calculator for cluster planninghttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-calculator
Optimize ADX cost per GB ingestedhttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-cost-drivers
Understand ADX reservation discount applicationhttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-reservation-discount
Choose and purchase Azure Data Explorer reserved capacityhttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-reserved-capacity

Architecture & Design Patterns

TopicURL
Design Azure Data Explorer business continuity and DRhttps://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-create-solution
Use follower databases for cross-cluster ADX accesshttps://learn.microsoft.com/en-us/azure/data-explorer/follower
Choose multitenant architectures for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/multi-tenant

Limits & Quotas

TopicURL
Understand automatic stop behavior for inactive clustershttps://learn.microsoft.com/en-us/azure/data-explorer/auto-stop-clusters
Apply Event Grid ingestion file size limits in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/create-event-grid-connection
Delete and recover Azure Data Explorer clusters safelyhttps://learn.microsoft.com/en-us/azure/data-explorer/delete-cluster
Understand invalid data behavior during ADX ingestionhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-invalid-data
Supported data and compression formats for Azure Data Explorer ingestionhttps://learn.microsoft.com/en-us/azure/data-explorer/ingestion-supported-formats
Upgrade free Azure Data Explorer clusters and remove limitshttps://learn.microsoft.com/en-us/azure/data-explorer/start-for-free-upgrade

Security

TopicURL
Programmatically add Azure Data Explorer cluster principalshttps://learn.microsoft.com/en-us/azure/data-explorer/add-cluster-principal
Programmatically add Azure Data Explorer database principalshttps://learn.microsoft.com/en-us/azure/data-explorer/add-database-principal
Enable disk encryption for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-disk
Configure encryption options for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-overview
Configure managed identities on Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/configure-managed-identities-cluster
Configure cross-tenant access for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/cross-tenant-query-and-commands
Configure customer-managed keys for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/customer-managed-keys
Purge personal data from Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/data-purge-portal
Authenticate Azure Data Explorer external tables with managed identitieshttps://learn.microsoft.com/en-us/azure/data-explorer/external-tables-managed-identities
Ingest data using managed identity authenticationhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-managed-identity
Configure and manage Azure Data Explorer cluster lockshttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-locks
Configure Azure Data Explorer cluster RBAC permissionshttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-permissions
Configure database RBAC permissions in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/manage-database-permissions
Use managed identities with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/managed-identities-overview
Apply built-in Azure Policy definitions to ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/policy-reference
Securely connect private-endpoint clusters to Power BIhttps://learn.microsoft.com/en-us/azure/data-explorer/power-bi-private-endpoint
Create and authorize Microsoft Entra apps for Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/provision-entra-id-app
Configure Conditional Access for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-conditional-access
Apply Azure Policy compliance controls to Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-controls-policy
Configure managed private endpoints for Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-managed-private-endpoint-create
Plan network security for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-overview
Secure Azure Data Explorer with private endpointshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint
Restrict outbound access from Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-outbound-access
Control public network access to Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-public-access

Configuration

TopicURL
Use KQL database scripts in ARM deploymentshttps://learn.microsoft.com/en-us/azure/data-explorer/database-script
Programmatically create Azure Data Explorer database and table policieshttps://learn.microsoft.com/en-us/azure/data-explorer/database-table-policies
Create cross-tenant Event Hubs data connections for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-cross-tenant
Install and configure Azure Data Explorer Kusto emulatorhttps://learn.microsoft.com/en-us/azure/data-explorer/kusto-emulator-install
Manage language extension plugins in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/language-extensions
Configure Azure Data Explorer monitoring reference settingshttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-data-explorer-reference
Synchronize ADX schema with Sync Kusto toolhttps://learn.microsoft.com/en-us/azure/data-explorer/sync-kusto
Use T-SQL queries against Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/t-sql
Configure Azure Data Explorer table retention and cachehttps://learn.microsoft.com/en-us/azure/data-explorer/table-retention-policy-wizard
Customize Azure Data Explorer web UI environment settingshttps://learn.microsoft.com/en-us/azure/data-explorer/web-customize-settings
Use Azure Data Explorer web UI query keyboard shortcutshttps://learn.microsoft.com/en-us/azure/data-explorer/web-ui-query-keyboard-shortcuts

Integrations & Coding Patterns

TopicURL
Manage ADX with Azure PowerShell Kusto cmdletshttps://learn.microsoft.com/en-us/azure/data-explorer/azure-powershell
Clone Azure Data Explorer database schema via commandshttps://learn.microsoft.com/en-us/azure/data-explorer/clone-database-schema
Connect common SQL tools to Azure Data Explorer via emulationhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-common-apps
Configure JDBC connectivity to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-jdbc
Set up ODBC connections to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-odbc
Query Azure Storage external tables from Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/external-azure-storage-tables-query
Use ADX connector in Power Automate flowshttps://learn.microsoft.com/en-us/azure/data-explorer/flow
Automate ADX queries with Power Automate exampleshttps://learn.microsoft.com/en-us/azure/data-explorer/flow-usage
Configure Grafana integration with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/grafana
Configure Event Grid ingestion from storage to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-event-grid-overview
Ingest Splunk Enterprise data into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk
Ingest data from Splunk Universal Forwarder into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk-uf
Configure Telegraf Azure Data Explorer output pluginhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-telegraf
Use ADX input/output bindings in Azure Functionshttps://learn.microsoft.com/en-us/azure/data-explorer/integrate-azure-functions
Integrate MCP servers with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/integrate-mcp-servers
Connect Azure Data Explorer to Kibana via K2Bridgehttps://learn.microsoft.com/en-us/azure/data-explorer/k2bridge
Query ADX from Jupyter using Kqlmagichttps://learn.microsoft.com/en-us/azure/data-explorer/kqlmagic
Query ADX as a linked server from SQL Serverhttps://learn.microsoft.com/en-us/azure/data-explorer/linked-server
Run ADX queries via Logic Apps connectorhttps://learn.microsoft.com/en-us/azure/data-explorer/logic-apps
Configure OpenTelemetry collector to ingest into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/open-telemetry-connector
Build Power Apps that query Azure Data Explorer via connectorhttps://learn.microsoft.com/en-us/azure/data-explorer/power-apps-connector
Integrate Azure Data Explorer with Microsoft Purviewhttps://learn.microsoft.com/en-us/azure/data-explorer/purview
Query Azure Data Explorer using the Python data client libraryhttps://learn.microsoft.com/en-us/azure/data-explorer/python-query-data
Query Azure Data Explorer from MATLAB using authorization tokenshttps://learn.microsoft.com/en-us/azure/data-explorer/query-matlab
Use Redash native connector with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/redash
Use Serilog sink to stream logs into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/serilog-sink
Set up Sisense integration with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/sisense
Run KQL queries and stored functions over TDS from SQL clientshttps://learn.microsoft.com/en-us/azure/data-explorer/sql-kql-queries-and-stored-functions
Connect to Azure Data Explorer using SQL Server emulation (TDS endpoint)https://learn.microsoft.com/en-us/azure/data-explorer/sql-server-emulation-overview
Connect Azure Data Explorer to Tableau via ODBChttps://learn.microsoft.com/en-us/azure/data-explorer/tableau
Debug KQL inline Python plugin code using Visual Studio Codehttps://learn.microsoft.com/en-us/kusto/debug-inline-python?view=microsoft-fabric

Deployment

TopicURL
Automate provisioning of Azure Data Explorer environmentshttps://learn.microsoft.com/en-us/azure/data-explorer/automated-deploy-overview
Use Azure DevOps pipelines for Azure Data Explorer schema deploymenthttps://learn.microsoft.com/en-us/azure/data-explorer/devops
Migrate Azure Data Explorer clusters to multiple availability zoneshttps://learn.microsoft.com/en-us/azure/data-explorer/migrate-cluster-to-multiple-availability-zone
Migrate Azure Data Explorer VNet injection to private endpointshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-migrate-vnet-to-private-endpoint

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

ログインしてレビューを書く

同じリポジトリのスキル

概要と使いどころ

azure-active-directory-b2c

無料

Expert knowledge for Azure Active Directory B2C development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building B2C user flows/custom policies, configuring IdPs/MFA, securing APIs, automating CI/CD, or monitoring with Sentinel, and other Azure Active Directory B2C related development tasks. Not for Azure Role-based access control (use azure-rbac), Azure Information Protection (use azure-information-protection), Azure Security (use azure-security), Azure Sentinel (use azure-sentinel).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

azure-advisor

無料

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when configuring Advisor alerts/digests, managing rec states, using workbooks, Resource Graph, or RBAC for access, and other Azure Advisor related development tasks. Not for Cost Management (use azure-cost-management), Azure Monitor (use azure-monitor), Azure Policy (use azure-policy), Azure Security (use azure-security).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

azure-ai-vision

無料

Expert knowledge for Azure AI Vision development including decision making, limits & quotas, configuration, integrations & coding patterns, and deployment. Use when using Image Analysis, Read OCR containers, smart-crop thumbnails, background removal, or video frame analysis, and other Azure AI Vision related development tasks. Not for Azure AI Custom Vision (use azure-custom-vision), Azure AI Video Indexer (use azure-video-indexer), Azure AI Document Intelligence (use azure-document-intelligence), Azure AI Immersive Reader (use azure-immersive-reader).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

azure-aks-edge-essentials

無料

Expert knowledge for Azure Kubernetes Service Edge Essentials development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when managing AKS Edge/Hybrid with Arc, GitOps, IoT/OPC/ONVIF, TPM/Key Vault secrets, or AI model workloads, and other Azure Kubernetes Service Edge Essentials related development tasks. Not for Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure IoT Edge (use azure-iot-edge), Azure Stack Edge (use azure-stack-edge), Azure Container Apps (use azure-container-apps).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

azure-analysis-services

無料

Expert knowledge for Azure Analysis Services development including troubleshooting. Use when resolving server connectivity, firewall/VNet, DNS, client connection, or network error issues, and other Azure Analysis Services related development tasks. Not for Azure Synapse Analytics (use azure-synapse-analytics), Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

azure-anomaly-detector

無料

Expert knowledge for Azure AI Anomaly Detector development including troubleshooting, best practices, limits & quotas, configuration, and deployment. Use when tuning Docker-based Anomaly Detector, ACI or IoT Edge deployments, univariate/multivariate APIs, or service limits, and other Azure AI Anomaly Detector related development tasks. Not for Azure AI Metrics Advisor (use azure-metrics-advisor), Azure Monitor (use azure-monitor), Azure Machine Learning (use azure-machine-learning).

日本語の概要は準備中です。原文の説明を表示しています。

MicrosoftDocs/Agent-Skills7772026年10月11日 更新

MicrosoftDocs のスキルをすべて見る

このスキルの問題を報告する