Can I manage firewall rules using this skill?

Yes, it includes comprehensive patterns for configuring firewall rules to allow Azure services or specific client IP ranges to access your SQL server.

What is the best way to handle authentication with this SDK?

It is recommended to use DefaultAzureCredential from the Azure.Identity library, which provides a secure and flexible way to authenticate without hardcoding credentials.

Does this skill help with executing SQL queries?

No, this skill is specifically for management plane operations like creating or configuring resources. For executing queries or stored procedures, you should use the Microsoft.Data.SqlClient data plane SDK.

Which .NET packages are required to use these features?

You need to install the Azure.ResourceManager.Sql and Azure.Identity packages via dotnet add package.

Does this skill support Azure SQL Elastic Pools?

Yes, it provides workflows for creating elastic pools, configuring their SKUs (eDTUs or vCores), and adding or removing databases from those pools.

Azure SQL Management for .NET

Name: Azure SQL Management for .NET
Author: microsoft

bymicrosoft

•

1,777

•

Cloud Infrastructure

Provisions and manages Azure SQL servers, databases, and elastic pools using the .NET Resource Manager SDK.

This skill empowers Claude to automate the management plane of Azure SQL infrastructure within .NET environments. It provides specialized guidance for creating and configuring SQL servers, databases, and elastic pools, as well as managing firewall rules and failover groups via the Azure Resource Manager (ARM) SDK. By clearly distinguishing between management operations and data-plane queries, it ensures developers use the correct architectural patterns for infrastructure-as-code and cloud resource orchestration, complete with authentication best practices and SKU selection guidance.

Key Features

01Provides standardized C# code snippets for ARM client operations

02Manages complex resource hierarchies and failover group configurations

03Automates provisioning of Azure SQL Servers, Databases, and Elastic Pools

04Configures security via SQL firewall rules and virtual network rules

051,777 GitHub stars

06Guides SKU selection for various performance tiers and cost optimization

Use Cases

01Programmatically scaling Azure SQL resources based on application demand

02Automating the setup of dev/test environments with specific SQL configurations

03Managing database security and network access rules across an entire Azure subscription

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microsoft/skills azure-resource-manager-sql-dotnet

For use in Claude.ai and ChatGPT

Download Skill