home / skills / partme-ai / full-stack-skills / cloud-azure-sql

cloud-azure-sql skill

safe

This skill helps you provision, configure, and manage Azure SQL databases with security and best practices guidance.

npx playbooks add skill partme-ai/full-stack-skills --skill cloud-azure-sql

Review the files below or copy the command above to add this skill to your agents.

Files (2)

SKILL.md

685 B

---
name: cloud-azure-sql
description: Provides comprehensive guidance for Azure SQL Database including database creation, configuration, security, and Azure SQL management. Use when the user asks about Azure SQL, needs to create Azure SQL databases, configure Azure SQL, or manage Azure database services.
license: Complete terms in LICENSE.txt
---

## When to use this skill

Use this skill whenever the user wants to:
- [待完善：根据具体工具添加使用场景]

## How to use this skill

[待完善：根据具体工具添加使用指南]

## Best Practices

[待完善：根据具体工具添加最佳实践]

## Keywords

[待完善：根据具体工具添加关键词]

Overview

This skill provides comprehensive, practical guidance for Azure SQL Database tasks including provisioning, configuration, security hardening, performance tuning, backups, and operational management. It helps engineers and DBAs make repeatable decisions when creating or managing Azure SQL resources. Use it to get step-by-step instructions, recommended settings, and troubleshooting approaches for common Azure SQL scenarios.

How this skill works

The skill inspects your goal and environment constraints (single database, managed instance, or elastic pool) and maps them to recommended Azure SQL deployment patterns. It provides concrete commands, ARM/Bicep snippets, or Azure CLI/PowerShell examples for provisioning and configuration. It also outlines security controls, auditing/backup settings, and performance diagnostics to validate the database is configured correctly.

When to use it

Creating a new Azure SQL Database or Managed Instance with production-ready defaults
Migrating on-premises SQL Server workloads to Azure SQL or performance-tuning migrated systems
Implementing security controls: firewall rules, VNet integration, Always Encrypted, TDE, and role-based access
Configuring automated backups, long-term retention, and point-in-time restore policies
Diagnosing high CPU/IO issues, query plan regressions, or connection throttling

Best practices

Choose the right service tier (vCore vs DTU) and compute size based on workload profiling and cost targets
Use private endpoints or VNet integration to avoid public exposure; restrict firewall and enable Azure AD authentication
Enable Transparent Data Encryption and Always Encrypted for data at rest and in use; audit and monitor with Azure SQL Auditing and Threat Detection
Configure automatic backups and set an appropriate retention period; test restores regularly to validate DR procedures
Use Query Performance Insight, Intelligent Insights, and Query Store to capture regressions and guide indexing decisions

Example use cases

Provision an Azure SQL Database for a web application with CI/CD-friendly ARM/Bicep snippets and connection string guidance
Design an elastic pool for multi-tenant SaaS to optimize cost and resource sharing
Harden an existing Azure SQL deployment by adding managed identities, encrypting columns, and removing public endpoints
Tune slow queries by capturing execution plans with Query Store and applying targeted indexing or parameterization fixes

FAQ

Can I migrate an on-premises SQL Server to Azure SQL Database?

Yes. Use Data Migration Assistant to assess compatibility, then migrate schema and data with Azure Database Migration Service or bacpac/replication approaches depending on downtime tolerance.

How do I secure access to Azure SQL without exposing it publicly?

Use private endpoints or VNet service endpoints, enforce Azure AD authentication, apply firewall rules, and restrict access to specific subnets and managed identities.