Azure.ResourceManager.Sql (.NET)
Provision Azure SQL Resources with .NET SDK
Managing Azure SQL infrastructure manually through the portal is time-consuming and error-prone. This skill enables automated provisioning and management of SQL servers, databases, and elastic pools using the Azure.ResourceManager.Sql SDK.
Download the skill ZIP
Upload in Claude
Go to Settings → Capabilities → Skills → Upload skill
Toggle on and start using
Test it
Using "Azure.ResourceManager.Sql (.NET)". Create a SQL server with a database
Expected outcome:
Server 'my-sql-server' created in EastUS with TLS 1.2 enforced. Database 'my-db' provisioned with S0 SKU (10 DTUs) and 2GB storage. Connection endpoint: my-sql-server.database.windows.net
Using "Azure.ResourceManager.Sql (.NET)". Add firewall rule for office IP range
Expected outcome:
Firewall rule 'OfficeIPs' created allowing 203.0.113.0 - 203.0.113.255. Rule is active immediately. Existing connections are not affected.
Security Audit
SafeThis is a prompt-only documentation skill with no executable code. It provides instructions for using Azure.ResourceManager.Sql SDK for management plane operations. The skill teaches proper security practices including DefaultAzureCredential for authentication and TLS 1.2 minimum version. Static analysis scanned 0 files with risk score 0/100. No security concerns identified.
Risk Factors
🔑 Env variables (1)
Quality Score
What You Can Build
DevOps Engineer Automating Infrastructure
Automate SQL server and database provisioning as part of CI/CD pipelines using .NET applications
Developer Building Management Tools
Create internal tools for self-service database provisioning and resource management
Cloud Architect Designing Solutions
Implement infrastructure-as-code patterns for Azure SQL resources with proper security configuration
Try These Prompts
Create an Azure SQL server named 'prod-sql-server' in East US with TLS 1.2 minimum version and administrator login configured.
Create a SQL database named 'app-db' in the existing elastic pool 'shared-pool' with Standard S0 SKU and 2GB max size.
Add firewall rules to allow Azure services and the corporate IP range 203.0.113.0/24 to access the SQL server.
Provision a complete SQL infrastructure: server with AAD admin, elastic pool with 100 eDTUs, three databases in the pool, firewall rules for Azure services and specific IPs, and enable audit logging.
Best Practices
- Use DefaultAzureCredential for authentication - supports managed identity, CLI, and environment credentials
- Use WaitUntil.Completed for operations that must finish before dependent actions
- Configure firewall rules and network settings before attempting database connections
Avoid
- Do not hardcode administrator passwords - use Azure Key Vault or managed identity
- Do not use this SDK for executing queries - use Microsoft.Data.SqlClient instead
- Avoid creating databases without elastic pools when managing multiple databases - pools reduce costs