Login
microsoftdocs/agent-skills1 file

Azure SQL Database

Expert knowledge for Azure SQL Database development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when choosing tiers (DTU/vCore/serverless), configuring geo-replication/DR, Hyperscale, Data Sync, or elastic pools, and other Azure SQL Database related development tasks. Not for Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Cosmos DB (use azure-cosmos-db), Azure Data Factory (use azure-data-factory).

Use this skillView repositoryView on skills.sh
Specification
Skill ID
microsoftdocs/agent-skills/azure-sql-database
Publisher
microsoftdocs
Repository
agent-skills
Installs
0
Files
1
Requires
Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation.
Synced
Sep 23, 2026
How to use it

Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.

microsoftdocs/agent-skills/azure-sql-databaseInstalls these files
  • SKILL.md

What this skill tells the agent

Azure SQL Database Skill

This skill provides expert guidance for Azure SQL Database. 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-L62Diagnosing and fixing Azure SQL issues: performance, deadlocks, blocking, CPU/memory, capacity, import/export, connectivity, geo-replication, Data Sync, serverless, and log-full errors.
Best PracticesL63-L78Best practices for securing, monitoring, tuning, and operating Azure SQL: HA/DR, failover, read replicas, maintenance, auditing, TDE, Data Sync, and adapting T-SQL.
Decision MakingL79-L106Guidance for choosing Azure SQL deployment, tiers, pricing, Hyperscale options, DR/HA, automation, reservations, and migration paths (SQL Server, DTU↔vCore, Data Sync, elastic sharding).
Architecture & Design PatternsL107-L125Architectural patterns for Azure SQL apps: geo-replication, DR/BCP, connectivity/routing, sharding & elastic scale, multi-tenant SaaS models, Hyperscale internals, and upgrade/failover designs.
Limits & QuotasL126-L141Limits, quotas, and behaviors for Azure SQL: free tier and offers, DTU/vCore and serverless resource caps, backups immutability, maintenance windows, and billing rules.
SecurityL142-L210Securing Azure SQL: authentication (Entra, MFA, managed identity), network/firewall, auditing and Defender, encryption (TDE, Always Encrypted), masking, DR, compliance, and policy configuration.
ConfigurationL211-L281Configuring Azure SQL: monitoring, backups, security (encryption, TDE, immutability), scaling, geo-replication/failover, elastic pools/jobs, Data Sync, CLI/PowerShell/REST setup and maintenance.
Integrations & Coding PatternsL282-L311Connecting apps and tools to Azure SQL (EF Core, .NET, Node.js, Python, Go), plus PowerShell/CLI automation for auditing, scaling, geo-replication, data sync, and streaming/Spark integration.
DeploymentL312-L323Deploying and migrating Azure SQL: CI/CD with GitHub/Terraform, scaling and tier changes (Hyperscale, elastic pools), region moves, zone redundancy, dev environments, and feature availability.

Troubleshooting

TopicURL
Troubleshoot Azure SQL capacity deployment and scaling errorshttps://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
Resolve common Azure SQL database watcher issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
Analyze and prevent deadlocks in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/analyze-prevent-deadlocks?view=azuresql
Fix slow database import and export in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Use RecoveryManager to fix Azure SQL shard mapshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-recovery-manager?view=azuresql
Troubleshoot Azure SQL Database Elastic Scale issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-faq?view=azuresql
Diagnose and fix high CPU in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-cpu-diagnose-troubleshoot?view=azuresql
Troubleshoot performance issues in Azure SQL Hyperscalehttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-performance-diagnostics?view=azuresql
Diagnose Azure SQL query performance bottleneckshttps://learn.microsoft.com/en-us/azure/azure-sql/database/identify-query-performance-issues?view=azuresql
Monitor and troubleshoot In-Memory OLTP storage capacityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-monitor-space?view=azuresql
Use DMVs to troubleshoot Azure SQL performancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql
Use Azure Resource Health to troubleshoot Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql
Troubleshoot auto-pause and resume in Azure SQL serverlesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-auto-pause-resume?view=azuresql
Troubleshoot common Azure SQL Data Sync issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot?view=azuresql
Troubleshoot transient connectivity errors for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
Troubleshoot Azure SQL and Fabric SQL connectivity errorshttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
Troubleshoot geo-replication and redo lag in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
Investigate and fix memory issues in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
Resolve transaction log full errors in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
Identify and resolve blocking in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/understand-resolve-blocking?view=azuresql
Resolve known issues in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
Resolve transaction log full errors in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi

Best Practices

TopicURL
Analyze Azure SQL monitoring data with KQL and T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Apply auditing best practices in production Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-best-practices?view=azuresql
Run disaster recovery drills for Azure SQL workloadshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-drills?view=azuresql
Optimize resource management in dense Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql
Configure and operate Azure SQL failover groups with best practiceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql

More from microsoftdocs

microsoftdocs/agent-skills

Azure Container Apps

Expert knowledge for Azure Container Apps development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when configuring ACA ingress/scale, Dapr or Functions workloads, GitHub Actions CI/CD, private networking, or GPUs, and other Azure Container Apps related development tasks. Not for Azure App Service (use azure-app-service), Azure Functions (use azure-functions), Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure Spring Apps (use azure-spring-apps).

microsoftdocs/agent-skills

Azure Well Architected

Expert guidance for designing, assessing, and optimizing Azure workloads using Azure Well Architected. Covers design review checklists, recommendations, design principles, tradeoffs, service guides, workload patterns, and assessment questions. Use when designing AI, HPC, SaaS, AVD, or mission-critical workloads and optimizing Azure services by WAF pillars, and other Azure Well Architected related development tasks.

microsoftdocs/mcp

Microsoft Code Reference

Find working code samples, verify API signatures, and fix Microsoft SDK errors using official docs. Use whenever the user is writing, debugging, or reviewing code that touches any Microsoft SDK, .NET library, Azure client library, or Microsoft API—even if they don't ask for a "reference." Catches hallucinated methods, wrong signatures, and deprecated patterns. If the task involves producing or fixing Microsoft-related code, this is the right skill.

Use this skill in a project

Open any RiverX project, search the Skills panel for microsoftdocs/agent-skills/azure-sql-database, and install it in one click.

Use this skill