azure-sql-database
- Repo stars 0
- Author repo skills-registry
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: This file may be large. Use the Category Index below to locate relevant sections, then use
read_filewith 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. Usemcp_microsoftdocs:microsoft_docs_fetchto retrieve full articles.
- Fallback: Use the built-in
WebFetchtool if the Microsoft Learn MCP server is not available.
Category Index
| Category | Lines | Description |
|---|---|---|
| Troubleshooting | L31-L52 | Diagnosing and fixing Azure SQL issues: performance (CPU, memory, deadlocks, blocking), capacity/log, import/export, connectivity, geo-replication, Data Sync, and Managed Instance errors. |
| Best Practices | L54-L69 | Best practices for Azure SQL operations: monitoring, auditing, security, HA/DR, failover, read replicas, maintenance, file space, Data Sync, and post-migration behavior. |
| Decision Making | L71-L93 | Guidance for choosing Azure SQL service tiers, pricing models, automation/DR options, Hyperscale choices, and migration paths (DTU↔vCore, sharding, Data Sync, Hybrid Benefit, reservations). |
| Architecture & Design Patterns | L95-L112 | Architectural patterns for Azure SQL: geo-replication, HA/DR, backups, connectivity, sharding/elastic scale-out, multi-tenant SaaS models, and rolling upgrade/failover designs. |
| Limits & Quotas | L114-L126 | Limits, quotas, and resource caps for Azure SQL (free tiers, DTU/vCore, elastic pools, Hyperscale), plus how to request quota increases and watcher/operational constraints. |
| Security | L128-L197 | Configuring Azure SQL security: auth (Entra, MFA, MI), network isolation, auditing, Defender, data protection (TDE, Always Encrypted, masking, classification), compliance, and best‑practice hardening. |
| Configuration | L199-L264 | Configuring Azure SQL databases and pools: monitoring, backups, geo-replication/failover, maintenance windows, security/immutability, scaling, elastic jobs/queries, and CLI/PowerShell/REST setup. |
| Integrations & Coding Patterns | L266-L295 | Connecting apps and tools to Azure SQL (EF Core, .NET, Node.js, Python), sharding/elastic patterns, and automating management, replication, sync, and streaming via PowerShell/Spark/Stream Analytics |
| Deployment | L297-L311 | Guides for deploying and moving Azure SQL databases: automation (GitHub, ARM, Bicep, Terraform), Hyperscale setup, regional moves, feature availability, and dev environment setup. |
Troubleshooting
Best Practices
Decision Making
Architecture & Design Patterns
Limits & Quotas
Security
Configuration
Integrations & Coding Patterns
Deployment
<!-- tomevault:4.0:skill_md:2026-05-22 -->Source: atc-net/atc-agentic-toolkit — distributed by TomeVault.
- 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,默认拥有全部工具权限。
The current SKILL.md does not define a fixed output example. IMPORTANT for Agent: This file may be large. Use the Category Index below to locate relevant sections, then use readfile 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…
Category · Lines · Description Troubleshooting · L31-L52 · Diagnosing and fixing Azure SQL issues: performance (CPU, memory, deadlocks, blocking), capacity/log, import/export, connectivity, geo-replication, Data Sync, and Managed Instance errors.
Topic · URL Troubleshoot Azure SQL capacity deployment and scaling errors · https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql Analyze and prevent deadlocks in Azure SQL Database ·…
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 Apply auditing best practices in production Azure SQL ·…
Topic · URL Decide when to use Azure Hybrid Benefit for Azure SQL · https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql Use Azure SQL decision tree to choose service ·…
Topic · URL Design and use active geo-replication for Azure SQL databases · https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql Use automatic geo-redundant backups and restore in Azure SQL ·…
# 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**: 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-L52 | Diagnosing and fixing Azure SQL issues: performance (CPU, memory, deadlocks, blocking), capacity/log, import/export, connectivity, geo-replication, Data Sync, and Managed Instance errors. |
| Best Practices | L54-L69 | Best practices for Azure SQL operations: monitoring, auditing, security, HA/DR, failover, read replicas, maintenance, file space, Data Sync, and post-migration behavior. |
| Decision Making | L71-L93 | Guidance for choosing Azure SQL service tiers, pricing models, automation/DR options, Hyperscale choices, and migration paths (DTU↔vCore, sharding, Data Sync, Hybrid Benefit, reservations). |
… 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 -> 00cdbd0fe8ba
Decide Fit First
Design Intent
How To Use It
Boundaries And Review