azure-sql-managed-instance

DevOps Community

Repo stars 0
Author repo skills-registry

Interpretation is structured for decision-making; original keeps the upstream SKILL.md unchanged.

Decide Fit First

Core job: Expert knowledge for Azure SQL Managed Instance development including troubleshooting, best practices, decision making, architec…
Best fit: Use it when the task has reusable inputs, steps, and validation criteria rather than a one-off answer.
Avoid forcing it: If the source lacks commands, platform support, or external-service evidence, keep those fields unknown instead of guessing.

Design Intent

Structure: The skill is organized around “How to Use This Skill”, “Category Index”, “Troubleshooting”, “Best Practices”, showing how the author expects the agent to judge fit, collect context, and produce verifiable output.
Trigger evidence: Prioritize the author’s wording around when to use it, what context to collect, and what output shape to produce.
Evidence boundary: Author text states facts, repository files prove commands and paths, and Fluxly only adds fit, limits, and usage judgment.

How To Use It

Inputs: Provide target material, scope, expected result, forbidden changes, and validation method.
Invocation: Name azure-sql-managed-instance directly; if the source includes slash commands, start with the command and then add task context.
Validation: Start small and check whether the result follows “How to Use This Skill / Category Index / Troubleshooting” before expanding.

Boundaries And Review

Dependencies: It usually needs no extra API key, so start with a small validation task.
Permissions: Declared permissions include read / write / shell-exec; ask the agent to state file, command, and rollback boundaries before acting.
Quality bar: A useful result names the deliverable, evidence, and next action. Generic prose means the task needs tighter context.

Azure SQL Managed Instance Skill

This skill provides expert guidance for Azure SQL Managed Instance. 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: This file may be large. Use the Category Index below to locate relevant sections, then use read_file with specific line ranges (e.g., L136-L144) to read the sections needed for the user's question This skill requires network access to fetch documentation content. Use mcp_microsoftdocs:microsoft_docs_fetch to retrieve full articles.

Fallback: Use the built-in WebFetch tool if the Microsoft Learn MCP server is not available.

Category Index

Category	Lines	Description
Troubleshooting	L31-L47	Diagnosing and fixing Azure SQL Managed Instance issues: performance, connectivity, capacity, memory, transaction logs, geo‑replication, MI Link, and Entra Kerberos auth.
Best Practices	L49-L69	Guidance on performance tuning, monitoring, HA/DR, failover/geo-replication, maintenance, alerts, and app design best practices for Azure SQL Managed Instance.
Decision Making	L71-L84	Guidance for choosing Azure SQL Managed Instance vs other Azure SQL options, tiers, pools, networking, HA/DR options, ML differences, and planning Db2/Oracle migrations.
Architecture & Design Patterns	L86-L89	Connectivity architecture, networking models, and connection options for Azure SQL Database, including gateways, endpoints, firewalls, and integration with VNets and private access.
Limits & Quotas	L91-L99	Limits, quotas, and performance caps for Azure SQL MI: DTUs, free tier limits, memory/OLTP usage, resource ceilings, monitoring behavior, and how to request quota increases.
Security	L101-L153	Entra/Windows auth, identities, access control, auditing, encryption (TDE, CMK), threat protection, TLS, and security best practices for Azure SQL Managed Instance.
Configuration	L155-L205	Configuring and monitoring SQL Managed Instance: networking, connectivity, backups/restore, maintenance windows/updates, alerts, metrics/logs, Intelligent Insights, and Extended Events.
Integrations & Coding Patterns	L207-L230	Connecting apps and tools to SQL Managed Instance (.NET, Java, Python, etc.), automation, data import, DTC, XEvents, MI Link, backups, tracing, and Spark integration.
Deployment	L232-L252	Deploying and managing Azure SQL Managed Instance: provisioning (Bicep/ARM/Terraform), networking, region/subnet moves, start/stop, DR/replication, migrations, and feature availability.

Troubleshooting

Topic	URL
Resolve Azure SQL capacity deployment and scaling errors	https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
Fix slow database import and export in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Troubleshoot Azure SQL performance using Intelligent Insights	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?view=azuresql
Handle transient connectivity errors in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
Troubleshoot common connection issues for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
Troubleshoot geo-replication and redo lag in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
Investigate and fix memory issues in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
Troubleshoot transaction log full errors in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
Resolve known issues in Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
Monitor XTP in-memory storage and fix capacity error 41823	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-monitor-space?view=azuresql
Troubleshoot Azure SQL Managed Instance link issues	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-troubleshoot-how-to?view=azuresql
Use Azure Resource Health to diagnose SQL Managed Instance issues	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-health-to-troubleshoot-connectivity?view=azuresql
Troubleshoot transaction log full errors in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi
Troubleshoot Entra Kerberos Windows auth for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql

Best Practices

Topic	URL
Analyze Azure SQL monitoring data with KQL and T-SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Application development considerations for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/develop-overview?view=azuresql
Performance tuning guidance for Azure SQL applications	https://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?view=azuresql
Plan for Azure SQL planned maintenance events	https://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
Configure and use read scale-out replicas in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
Identify and resolve Azure SQL query performance issues	https://learn.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues?view=azuresql
Set up alerts and notifications for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?view=azuresql
Run disaster recovery drills for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-drills?view=azuresql
Design Azure SQL Managed Instance disaster recovery	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-guidance?view=azuresql
Use failover groups for geo-replication in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql
Manage database file space on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/file-space-manage?view=azuresql-mi
High availability and disaster recovery checklist for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-disaster-recovery-checklist?view=azuresql
Identify and resolve query bottlenecks on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/identify-query-performance-issues?view=azuresql
Migrate to Azure SQL Managed Instance with Log Replay Service	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql
Best practices for using Managed Instance link with Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-best-practices?view=azuresql
Monitor Azure SQL Managed Instance performance using DMVs	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-with-dmvs?view=azuresql
Tune Azure SQL Managed Instance performance for applications	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/performance-guidance?view=azuresql
Use batching to improve Azure SQL application performance	https://learn.microsoft.com/en-us/azure/azure-sql/performance-improve-use-batching?view=azuresql

Decision Making

Topic	URL
Use Azure SQL decision tree to choose service	https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
Compare Azure SQL Database vs Managed Instance features	https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
Configure license-free standby replica for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-standby-replica-how-to-configure?view=azuresql
Decide when to use SQL Managed Instance pools	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-pools-overview?view=azuresql
Choose between Log Replay Service and Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-compare-mi-link?view=azuresql
Compare ML Services in SQL Managed Instance vs SQL Server	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/machine-learning-services-differences?view=azuresql
Choose vCore service tiers for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-managed-instance-vcore?view=azuresql
Adopt Next-gen General Purpose tier for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use?view=azuresql
Determine subnet size and IP range for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-determine-size?view=azuresql
Plan and execute Db2 to SQL Managed Instance migration	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/db2-to-managed-instance-guide?view=azuresql
Plan Oracle to Azure SQL Managed Instance migration	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/oracle-to-managed-instance-guide?view=azuresql

Architecture & Design Patterns

Topic	URL
Understand connectivity architecture for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql

Limits & Quotas

Topic	URL
Review database watcher FAQ for Azure SQL monitoring behavior	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
Understand DTU benchmark characteristics for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
Request quota increases for Azure SQL resources	https://learn.microsoft.com/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql
Understand free-tier limits for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/free-offer?view=azuresql
Adopt In-memory OLTP and understand memory limits in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-configure?view=azuresql
Review Azure SQL Managed Instance resource limits	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

Security

Topic	URL
Configure Microsoft Entra authentication for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
Assign Directory Readers role for Azure SQL identities	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role-tutorial?view=azuresql
Configure Directory Readers and permissions for Azure SQL identities	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
Create and use Microsoft Entra guest admins for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-guest-users?view=azuresql
Use Microsoft Entra authentication with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
Use Entra service principals with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal?view=azuresql
Create and use Microsoft Entra logins in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins-tutorial?view=azuresql
Use Microsoft Entra server principals in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql
Create Azure SQL server with Entra-only authentication	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql
Use Azure Policy to require Entra-only auth for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy-how-to?view=azuresql
Enforce Entra-only authentication with Azure Policy for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy?view=azuresql
Enable Entra-only authentication on existing Azure SQL resources	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-tutorial?view=azuresql
Enable Microsoft Entra-only authentication for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication?view=azuresql
Configure managed identities for Azure SQL access	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
Configure Microsoft Entra authentication for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql?view=azuresql
Configure and use Microsoft Defender for SQL in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql
Configure Block T-SQL CRUD governance for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
Configure Conditional Access policies for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/conditional-access-configure?view=azuresql
Classify and label sensitive data in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
Configure dynamic data masking in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
Configure logins and users for Azure SQL access control	https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
Use built-in Azure Policy definitions for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
Apply Azure SQL security best practices for common requirements	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
Use Azure Policy regulatory compliance controls for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
Configure Advanced Threat Protection for Azure SQL workloads	https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql
Enable Azure SQL TDE with Key Vault BYOK	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql
Configure cross-tenant customer-managed keys for Azure SQL TDE	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
Use user-assigned managed identities for TDE customer-managed keys	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
Set up customer-managed TDE with Azure Key Vault	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
Enable and manage transparent data encryption in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql
Secure SQL Managed Instance with Microsoft Entra logins	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial?view=azuresql
Configure auditing for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql
Create Azure SQL Managed Instance with user-assigned identity	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/authentication-azure-ad-user-assigned-managed-identity-create-managed-instance?view=azuresql
Migrate SQL Server Windows users to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/migrate-sql-server-users-to-instance-transact-sql-tsql-tutorial?view=azuresql
Configure minimum TLS version for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/minimal-tls-version-configure?view=azuresql
Use native Windows principals with SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql
Secure public endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-overview?view=azuresql
Configure TDE with customer-managed keys using PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-powershell?view=azuresql
Enable TDE with customer-managed keys using CLI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-sql-managed-instance-cli?view=azuresql
Apply security best practices to Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/secure-managed-instance?view=azuresql
Configure server trust groups for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/server-trust-group-overview?view=azuresql
Configure storage service endpoint policies for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-endpoint-policies-configure?view=azuresql
Migrate TDE certificates from SQL Server to Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tde-certificate-migrate?view=azuresql
Configure Advanced Threat Protection for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/threat-detection-configure?view=azuresql
Configure SQL Managed Instance for Entra Windows auth	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-instance?view=azuresql
Configure incoming trust-based Windows auth for SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-trust-based-flow?view=azuresql
Configure modern interactive Windows auth flow for SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-modern-interactive-flow?view=azuresql
Set up Windows Authentication for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql
Understand Kerberos-based Windows auth for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-implementation-aad-kerberos?view=azuresql
Prepare for Azure SQL TLS root certificate rotation	https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql

Configuration

Topic	URL
Configure alerts on Azure SQL monitoring data with database watcher	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
Understand database watcher datasets and collected metrics	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
Create and configure database watcher for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
Monitor Azure SQL workloads using database watcher	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-overview?view=azuresql
Create a database watcher with Entra auth and private connectivity	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-quickstart?view=azuresql
Configure Intelligent Insights performance monitoring for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
Use Intelligent Insights diagnostics logs for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log?view=azuresql
Configure long-term backup retention for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql
Configure metrics and diagnostic log streaming for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql
Reference monitoring metrics and logs for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
Configure temporal table retention in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/temporal-tables-retention-policy?view=azuresql
Configure Azure SQL XEvent sessions with ring_buffer	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-ring-buffer?view=azuresql
Configure Extended Events differences in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-db-diff-from-svr?view=azuresql
Configure advance maintenance notifications for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/advance-notifications?view=azuresql
API options to create and configure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance?view=azuresql
Deploy SQL Managed Instance with ARM templates	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/arm-templates-content-guide?view=azuresql
Change automated backup retention and redundancy for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-change-settings?view=azuresql
Understand automatic and geo-redundant backups in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql
Monitor Azure SQL Managed Instance backup activity using msdb and XEvents	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-activity-monitor?view=azuresql
View backup history with backup transparency in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-transparency?view=azuresql
Configure Azure VM connectivity to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-vm-instance-configure?view=azuresql
Configure connection types for Azure SQL Managed Instance endpoints	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connection-types-overview?view=azuresql
Configure failover groups for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-configure-sql-mi?view=azuresql
Configure long-term backup retention for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/long-term-backup-retention-configure?view=azuresql
Configure maintenance windows for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-configure?view=azuresql
Maintenance window FAQ for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-faq?view=azuresql
Understand maintenance window behavior in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window?view=azuresql
Prepare WSFC environment for Managed Instance link with Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation-wsfc?view=azuresql
Prepare environment for Managed Instance link replication	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation?view=azuresql
Monitor Azure SQL Managed Instance management operations	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-monitor?view=azuresql
Reference monitoring metrics and logs for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql
Configure monitoring for Azure SQL Managed Instance with Azure Monitor	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor?view=azuresql
Perform point-in-time database restores on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql
Set up point-to-site connectivity to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?view=azuresql
Configure Private Link and private endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/private-endpoint-overview?view=azuresql
Configure public endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure?view=azuresql
Restore databases from backups on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql
Configure private domain name resolution for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resolve-private-domain-names?view=azuresql
Add SQL Managed Instance to failover group with PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/add-to-failover-group-powershell?view=azuresql
Create and network-configure SQL Managed Instance with CLI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-cli?view=azuresql
Create and network-configure SQL Managed Instance with PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-powershell?view=azuresql
Restore Azure SQL Managed Instance database from geo-backup	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/restore-geo-backup?view=azuresql
Enable service-aided subnet configuration for Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/subnet-service-aided-configuration-enable?view=azuresql
Configure tempdb files and growth on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tempdb-configure?view=azuresql
Configure time zone behavior for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/timezones-overview?view=azuresql
Handle T-SQL differences between SQL Server and SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
Configure update policy for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql
Restart Azure SQL Managed Instance using manual failover	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/user-initiated-failover?view=azuresql

Integrations & Coding Patterns

Topic	URL
Connect to Azure SQL from .NET on all OSes	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-core?view=azuresql
Use Visual Studio .NET to query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-visual-studio?view=azuresql
Connect to Azure SQL using Go and go-mssqldb	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-go?view=azuresql
Connect Java applications to Azure SQL with JDBC	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql
Use Node.js to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-nodejs?view=azuresql
Use PHP to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-php?view=azuresql
Connect and query Azure SQL using Python	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
Use Ruby to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-ruby?view=azuresql
Configure and use Spark connector with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
Create Azure SQL XEvent sessions with event_file	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file?view=azuresql
Import CSV data into Azure SQL using bcp	https://learn.microsoft.com/en-us/azure/azure-sql/load-from-csv-with-bcp?view=azuresql
Manage SQL Managed Instance at scale with Azure Automation	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automation-manage?view=azuresql
Connect applications to Azure SQL Managed Instance in various networks	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance?view=azuresql
Use Distributed Transaction Coordinator with SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/distributed-transaction-coordinator-dtc?view=azuresql
Use in-memory OLTP and columnstore samples on SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-sample?view=azuresql
Automate jobs with SQL Server Agent on SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql
Configure Managed Instance link using T-SQL and Azure scripts	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql
Configure Managed Instance link using SQL Server Management Studio	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-ssms?view=azuresql
Fail over databases using Managed Instance link between SQL Server and Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-failover-how-to?view=azuresql
Restore Azure SQL Managed Instance backups to SQL Server 2022 or 2025	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-database-to-sql-server?view=azuresql
Run traces on SQL Managed Instance using Windows auth	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-run-trace-managed-instance?view=azuresql

Deployment

Topic	URL
Export Azure SQL databases to BACPAC files	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql
Import BACPAC files to create Azure SQL databases	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql
Check Azure SQL Database feature availability by region	https://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
Deploy Azure SQL Managed Instance using Bicep	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-bicep-quickstart?view=azuresql
Deploy Azure SQL Managed Instance via ARM template	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?view=azuresql
Provision Azure SQL Managed Instance with Terraform	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-create-terraform?view=azuresql
Stop and start Azure SQL Managed Instance to control costs	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql
Configure disaster recovery to Azure SQL Managed Instance using Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-disaster-recovery?view=azuresql
Migrate SQL Server to Azure SQL Managed Instance using Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-migrate?view=azuresql
Cancel Azure SQL Managed Instance management operations	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-cancel?view=azuresql
Understand duration of management operations in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-duration?view=azuresql
Move Azure SQL Managed Instance to another region	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/move-resources-across-regions?view=azuresql
Check SQL Managed Instance feature availability by region	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql
Configure transactional replication between SQL Managed Instances	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql
Set up replication between SQL Managed Instance and SQL Server	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql
Create a virtual network for Azure SQL Managed Instance deployment	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/virtual-network-subnet-create-arm-template?view=azuresql
Configure existing virtual networks for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-existing-add-subnet?view=azuresql
Move Azure SQL Managed Instance to another subnet with minimal downtime	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-move-instance?view=azuresql

Source: atc-net/atc-agentic-toolkit — distributed by TomeVault.

Fluxly profile Author and license come from source; runtime, permissions, and network are Fluxly detections or estimates

Fluxly category: DevOps
Author-declared agents: No explicit declaration found; this is not inferred or tested compatibility
Static check: 88 / 100 · heuristic scan, not runtime safety proof
Author / version / license: @tomevault-io · no license declared
Fluxly token estimate: Moderate
Fluxly setup estimate: Manual integration
External API key: No requirement detected
Detected OS requirements: Windows
Runtime requirements: Node.js · Python
Detected file/system behavior: Read-only
Write / modify
Shell exec
Detected network behavior: External requests
Install commands: None (reference only)

Profile is derived at build time from SKILL.md and install vectors. Subject to drift from author intent.

Heads up: 未限定 allowed-tools，默认拥有全部工具权限。

Output preview azure-sql-managed-instance.preview

The current SKILL.md does not define a fixed output example.

SKILL.md SKILL.md

# Azure SQL Managed Instance Skill

This skill provides expert guidance for Azure SQL Managed Instance. 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**: This file may be large. Use the **Category Index** below to locate relevant sections, then use `read_file` with specific line ranges (e.g., `L136-L144`) to read the sections needed for the user's question
This skill requires **network access** to fetch documentation content.
Use `mcp_microsoftdocs:microsoft_docs_fetch` to retrieve full articles.
- **Fallback**: Use the built-in `WebFetch` tool if the Microsoft Learn MCP server is not available.

## Category Index

| Category | Lines | Description |
|----------|-------|-------------|
| Troubleshooting | L31-L47 | Diagnosing and fixing Azure SQL Managed Instance issues: performance, connectivity, capacity, memory, transaction logs, geo‑replication, MI Link, and Entra Kerberos auth. |
| Best Practices | L49-L69 | Guidance on performance tuning, monitoring, HA/DR, failover/geo-replication, maintenance, alerts, and app design best practices for Azure SQL Managed Instance. |
| Decision Making | L71-L84 | Guidance for choosing Azure SQL Managed Instance vs other Azure SQL options, tiers, pools, networking, HA/DR options, ML differences, and planning Db2/Oracle migrations. |
| Architecture & Design Patterns | L86-L89 | Connectivity architecture, networking models, and connection options for Azure SQL Database, including gateways, endpoints, firewalls, and integration with VNets and private access. |

…

Evidence boundary and execution chain

Author text anchors workflow facts; Fluxly only indexes current sections, terms, files, and commands.

sections -> How to Use This Skill → Category Index → Troubleshooting → Best Practices → Decision Making → Architecture & Design Patterns
terms    -> IMPORTANT for Agent · Category Index · network access · Fallback
files/cmd -> readfile · L136-L144 · mcpmicrosoftdocs:microsoftdocsfetch · WebFetch
body sha256 -> e2df443f0d81