azure-sql-managed-instance
Expert knowledge for Azure SQL Managed Instance development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when planning MI networking, HA/DR, backups, Managed Instance link, or app connectivity patterns, and other Azure SQL Managed Instance related development tasks. Not for Azure SQL Database (use azure-sql-database), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Virtual Machines (use azure-virtual-machines).
How do I install this agent skill?
npx skills add https://github.com/microsoftdocs/agent-skills --skill azure-sql-managed-instanceIs this agent skill safe to install?
- Gen Agent Trust Hubpass
This skill acts as a documentation index for Azure SQL Managed Instance and is safe to use. It provides references to official Microsoft documentation and suggests using standard tools for content retrieval.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
- Runlayerpass
1/1 file flagged
- ZeroLeakspass
Score: 93/100 · 2 sections analyzed
What does this agent skill do?
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: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g.,
L35-L120), useread_filewith the specified lines. For categories with file links (e.g.,[security.md](security.md)), useread_fileon the linked reference file
IMPORTANT for Agent: If
metadata.generated_atis more than 3 months old, suggest the user pull the latest version from the repository. Ifmcp_microsoftdocstools 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_fetchwith query stringfrom=learn-agent-skill. Returns Markdown. - Fallback: Use
fetch_webpagewith query stringfrom=learn-agent-skill&accept=text/markdown. Returns Markdown.
Category Index
| Category | Lines | Description |
|---|---|---|
| Troubleshooting | L37-L60 | Diagnosing and fixing Azure SQL Managed Instance/Database issues: performance, connectivity, capacity, backups, transaction logs, security (ransomware), auth, geo-replication, and known errors. |
| Best Practices | L61-L89 | Performance, HA/DR, security, ransomware resilience, monitoring, and maintenance best practices for Azure SQL Managed Instance and applications using it. |
| Decision Making | L90-L106 | Guidance for choosing Azure SQL services and tiers, planning subnet/IPs, and deciding or executing migrations (SQL Server, Db2, Oracle) and replication options (link, LRS, standby). |
| Architecture & Design Patterns | L107-L111 | Connectivity architecture for Azure SQL DB and HA design for Managed Instance, including network topology, routing, failover behavior, and resilience patterns. |
| Limits & Quotas | L112-L122 | Backup retention/immutability rules, DTU benchmarks, free-tier and memory limits, maintenance windows, operation durations, and all key resource/scale limits for Azure SQL Managed Instance. |
| Security | L123-L177 | Authentication, encryption, access control, auditing, network protection, and Azure Policy for securing Azure SQL Managed Instance and related Azure SQL resources. |
| Configuration | L178-L227 | Configuring and managing Azure SQL Managed Instance: deployment, networking, backups/restore, monitoring, maintenance windows, update policy, time zone/tempdb, and high availability/failover. |
| Integrations & Coding Patterns | L228-L251 | Client connectivity, coding patterns, and tools for apps using Azure SQL Managed Instance, plus automation, DTC, XEvents, Spark, Managed Instance link, and backup/restore scenarios. |
| Deployment | L252-L267 | Deploying and managing Azure SQL Managed Instance and databases: scaling, start/stop for cost control, DR/replication, region/subnet moves, and required virtual network setup. |
Troubleshooting
Best Practices
Decision Making
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
Security
Configuration
Integrations & Coding Patterns
Deployment
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/microsoftdocs/agent-skills/azure-sql-managed-instance">View azure-sql-managed-instance on skillZs</a>